Likelihood to Recommend As any other archiving solution, it is very well suited for environments with a large footprint of unstructured data (CIFS / NFS shares for user data) with a large amount of unused/old files and a need to keep those unused files for long term. In our scenario, due to some legal and contractual constraints we need to keep these files for 15 years. Archiving is a good choice to move the unused files to a cheaper storage tier, both on-prem or cloud.
Read full review If your company's value is not increased by maintaining databases, you should use the ATP.
Read full review Pros It gives you a good overview on user data: files age, sizes, file types, owners, etc. It is very flexible on the archiving policies. The data scans are really fast without affecting storage's performance. It has a great alternative to STUB files, which they call 'bread crumbs' (symlinks to files). Read full review Quick and simple to deploy (less than 5 steps to create a new instance) No administrative tasks (backup, re-sizing) required Read full review Cons Its licensing plan, which takes into account the amount of data analyzed instead of data transferred. Read full review Connectivity between ATP and Oracle Kuberentes Engine cluster seems to drop randomly The ATP could come in an even smaller shape as the smallest shape is already quite big . But if must be more than always free, as that version does have connectivity limitations about 20 connections Read full review Usability You get almost all the features of Oracle Database, including the ability to deploy APEX applications, without having to worry about system, storage or database configuration and maintenance, backups, etc. Also, you can start for free and move up adding resources as you need.
Read full review Alternatives Considered We have used
Veritas Enterprise Vault in the past, and besides its being a well-known player on the data archiving market, their tool is far more complex to implement, to manage and to keep working. Komprise is very robust and also very easy to implement, as most part of the job is done on Komprise side. The management console is delivered through a public URL as a SaaS platform. You only need to deploy a few VMs for scan/archiving/user access, which they call "Observer VMs." Komprise also doesn't uses Stub files, which is a poor implementation adopted by the competitor for file access. We had a lot of issues in the past with stub files. Komprise has implemented 'bread crumbs', which are CIFS symlinks to the files on the Observer. It is a very good implementation and it works really well.
Read full review Both
Azure SQL Database and Oracle Autonomous Transaction Processing offer a powerful and robust database platform. The advantage of Autonomous Transaction Processing is the ability to host APEX applications for free and without any special/complicated deployment or configuration process. Having a rapid development environment embedded for free was the main advantage for choosing Oracle as my cloud database provider.
Read full review Return on Investment It allowed us to free up some space on our main storage during a time where we didn't have the budget to expand it. It allows us to move unused data to a cheaper storage tier (Azure Blobs). Read full review Approx 100 times faster spin up than manual setup of an Oracle DB 3h annual maintenance for big version releases (18c to 19c) compared to est. 500h annual maintenance with manual database updates Read full review ScreenShots Oracle Autonomous Transaction Processing Screenshots