Try our new research platform with insights from 80,000+ expert users
Oracle Autonomous Data Warehouse Logo

Oracle Autonomous Data Warehouse pros and cons

Vendor: Oracle
4.3 out of 5
174 followers
Post review
 

Oracle Autonomous Data Warehouse Pros review quotes

Miodrag Milojevic - PeerSpot reviewer
Jul 25, 2023
It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions.
MS
Apr 2, 2024
The solution has a self-backup, so you don't need a DBA (database administrator) to do a backup.
it_user1182006 - PeerSpot reviewer
Jul 16, 2020
Self-patching and runs machine-learning across its logs all the time
Learn what your peers think about Oracle Autonomous Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
reviewer2324613 - PeerSpot reviewer
Dec 29, 2023
With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main reason we use it.
DV
Nov 3, 2021
The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle.
reviewer1501608 - PeerSpot reviewer
Feb 22, 2021
The solution integrates well with Power BI.
SH
May 15, 2020
It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues.
Abhik Ray - PeerSpot reviewer
Jul 18, 2022
One advantage is that if you already have an Oracle Database, it easily integrates with that.
KopanoRamaphoi - PeerSpot reviewer
Mar 16, 2021
The performance and scalability are awesome.
DV
May 16, 2019
I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW.
 

Oracle Autonomous Data Warehouse Cons review quotes

Miodrag Milojevic - PeerSpot reviewer
Jul 25, 2023
There is a need for more storage to be allocated, but over a period of time, it becomes impossible to reduce it after using it.
MS
Apr 2, 2024
Oracle Autonomous Data Warehouse is not available as an on-premises solution.
it_user1182006 - PeerSpot reviewer
Jul 16, 2020
Ease of connectivity could be improved.
Learn what your peers think about Oracle Autonomous Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
reviewer2324613 - PeerSpot reviewer
Dec 29, 2023
My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on top of a JSON file with multiple array columns or superset columns, those column values create some difficulty in Oracle.
DV
Nov 3, 2021
The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora.
reviewer1501608 - PeerSpot reviewer
Feb 22, 2021
The initial setup was pretty complex. It was not easy.
SH
May 15, 2020
One of the major problem is creating custom tablespace. The ADB serverless option doesn't support custom tablespace creation, which could cause issues during on-premise database migration that requires specifically named tablespace. There should be an option to create customized tablespace.
Abhik Ray - PeerSpot reviewer
Jul 18, 2022
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.
KopanoRamaphoi - PeerSpot reviewer
Mar 16, 2021
It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment.
DV
May 16, 2019
I would like to see Application Express and Oracle R Enterprise fully supported, and I would like to see Oracle Data Mining supported as a front end.