Coming October 25: PeerSpot Awards will be announced! Learn more

Oracle Autonomous Data Warehouse Room for Improvement

DV
Web Developer at NuBean

The service could be improved by:

  • Providing Access to SYS schema
  • Allowing access to SYSTEM schema
  • Provisioning to apply user patches, and not just automated patches
  • Having provisions to administer the database by a DBA as an add-on to autonomous management
  • Getting provisions for fine-grained configuration
  • Allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora
  • Data Pump integration
  • Simplified Integration with other Oracle cloud services such as the Autonomous Container Database
  • Simplified migration from a local database 
View full review »
JA
Head of Data and Analytics at a financial services firm with 10,001+ employees

We are thinking of changing to a data warehouse on the cloud. I don't know if Oracle is in the cloud as well or if we will turn to another solution such as Google Cloud. 

The initial setup was pretty complex. It was not easy.

It would be ideal if the company could manage semi-structured data such as JSON. Some other data warehouses can handle that. However, Oracle doesn't seem to be able to.

View full review »
Abhik Ray - PeerSpot reviewer
Co-Founder at Quantic

It is good as data warehouses go, but it is not that good for really big data.

It doesn't work well when you have unstructured data or you need online analytics. It is not as nice as Hadoop in these aspects.

View full review »
Buyer's Guide
Oracle Autonomous Data Warehouse
September 2022
Learn what your peers think about Oracle Autonomous Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
635,513 professionals have used our research since 2012.
KR
Information Technology Administrator at a tech services company with 51-200 employees

It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment. On-premises,  you can integrate with different vendors such as Microsoft. There should be flexibility in terms of how you can accomplish things and not just with a single vendor, but with all vendors.

View full review »
Buyer's Guide
Oracle Autonomous Data Warehouse
September 2022
Learn what your peers think about Oracle Autonomous Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
635,513 professionals have used our research since 2012.