We performed a comparison between Microsoft Parallel Data Warehouse and Oracle Autonomous Data Warehouse based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It is not a pricey product compared to other data warehouse solutions."
"Data collection and reporting are valuable features of the solution."
"Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."
"The most valuable feature is the business intelligence (BI) part of it."
"I am very satisfied with the customer service/technical support."
"We have complete control over our data."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"The solution integrates well with Power BI."
"The performance and scalability are awesome."
"Self-patching and runs machine-learning across its logs all the time"
"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."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."
"It needs more compatibility with common BI tools."
"SQL installation is pretty tricky. The scalability and customer support also should be improved."
"If the database is large with a lot of columns then it is difficult to clean the data."
"The query is slow if we don't optimize it."
"The solution is expensive and has room for improvement."
"Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution."
"Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced."
"I would like the tool to support different operating systems."
"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."
"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."
"The initial setup was pretty complex. It was not easy."
"A lot of the tools that were previously there have now been taken away."
"I would like to see an on-premise solution in the future."
"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."
"The installation process is complex. Oracle can make the installation process better."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →
More Oracle Autonomous Data Warehouse Pricing and Cost Advice →
Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 32 reviews while Oracle Autonomous Data Warehouse is ranked 10th in Cloud Data Warehouse with 16 reviews. Microsoft Parallel Data Warehouse is rated 7.6, while Oracle Autonomous Data Warehouse is rated 8.6. The top reviewer of Microsoft Parallel Data Warehouse writes "An easy to setup tool that allows its users to write stored procedure, making it a scalable product". On the other hand, the top reviewer of Oracle Autonomous Data Warehouse writes "A tool for data warehousing that offers scalability, stability, and ease of setup". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA, Snowflake and VMware Tanzu Greenplum, whereas Oracle Autonomous Data Warehouse is most compared with Oracle Exadata, Snowflake, Microsoft Azure Synapse Analytics, BigQuery and Amazon Redshift. See our Microsoft Parallel Data Warehouse vs. Oracle Autonomous Data Warehouse report.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.