Compare Microsoft Parallel Data Warehouse vs. Oracle Autonomous Data Warehouse

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Snowflake Computing, Oracle, Apache and others in Data Warehouse. Updated: June 2021.
511,607 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
"I am very satisfied with the customer service/technical support.""The most valuable features are the performance and usability.""The most valuable feature for me is querying.""One of the most important features is the ease of using MS SQL.""The most valuable feature of this solution is performance.""The data transmissions between the data models is the most valuable feature.""The most valuable feature is the business intelligence (BI) part of it.""We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."

More Microsoft Parallel Data Warehouse Pros »

"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system.""The analytics have been very good. We've found them to be quite useful.""It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues.""Self-patching and runs machine-learning across its logs all the time""The solution integrates well with Power BI.""The performance and scalability are awesome."

More Oracle Autonomous Data Warehouse Pros »

Cons
"In the future I would love to see a slightly better automation engine, just for the data integration layer, to make it slightly easier for end-users or junior developers to get involved in incremental updating.""More tools to help designers should be included.""I would like to see better visualization features.""I think that the error messages need to be made more specific.""The reporting for certain types of data needs to be improved.""This solution would be improved with an option for in-memory data analysis.""If the database is large with a lot of columns then it is difficult to clean the data.""I would like the tool to support different operating systems."

More Microsoft Parallel Data Warehouse Cons »

"I would like to see an on-premise solution in the future.""Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable.""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.""Ease of connectivity could be improved.""The initial setup was pretty complex. It was not easy.""It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."

More Oracle Autonomous Data Warehouse Cons »

Pricing and Cost Advice
"I think the program is well-priced compared to the other offerings that are out in the market.""Microsoft has an agreement with the government in our country, so our customers get their licensing costs from the Ministry. Whenever we work with any government, company, or government institute, which is mainly what we are doing, that license comes directly from the Ministry of Technology and Information.""All the features that we use do not require any additional subscription or yearly fees."

More Microsoft Parallel Data Warehouse Pricing and Cost Advice »

"ROI is high.""You pay as you go, and you don't pay for services that you don't use."

More Oracle Autonomous Data Warehouse Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
511,607 professionals have used our research since 2012.
Questions from the Community
Top Answer: I'd like to connect something like ES that I can use on objects on our SQL Server. We'd like to be able to understand how to export data to something like Semantic Technologies or like Graph DB. Some… more »
Top Answer: The performance and scalability are awesome.
Top Answer: You pay as you go, and you don't pay for services that you don't use. If you feel that you need additional resources then you can increase them and pay only for them. There is no need to worry about… more »
Top Answer: 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… more »
Ranking
6th
out of 30 in Data Warehouse
Views
2,570
Comparisons
1,902
Reviews
11
Average Words per Review
486
Rating
7.6
5th
Views
4,845
Comparisons
3,492
Reviews
6
Average Words per Review
538
Rating
8.3
Popular Comparisons
Also Known As
Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse, MS Parallel Data Warehouse, MS Parallel Data Warehouse
Learn More
Overview

The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.

Autonomous Data Warehouse is market-leading Oracle Database software running on proven Oracle Exadata infrastructure that is optimized to deliver unbeatable performance for data warehouse workloads. Built-in adaptive machine learning eliminates manual labor for administrative management. With Oracle, business and enterprise users can now build their own data warehouse, data mart, or sandbox in a few minutes.

Offer
Learn more about Microsoft Parallel Data Warehouse
Learn more about Oracle Autonomous Data Warehouse
Sample Customers
Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe
Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank
Top Industries
REVIEWERS
Computer Software Company27%
Pharma/Biotech Company18%
Comms Service Provider9%
Hospitality Company9%
VISITORS READING REVIEWS
Computer Software Company24%
Comms Service Provider15%
Financial Services Firm10%
Insurance Company7%
VISITORS READING REVIEWS
Computer Software Company52%
Comms Service Provider12%
Financial Services Firm4%
Energy/Utilities Company3%
Company Size
REVIEWERS
Small Business32%
Midsize Enterprise18%
Large Enterprise50%
REVIEWERS
Small Business44%
Large Enterprise56%
Find out what your peers are saying about Snowflake Computing, Oracle, Apache and others in Data Warehouse. Updated: June 2021.
511,607 professionals have used our research since 2012.

Microsoft Parallel Data Warehouse is ranked 6th in Data Warehouse with 11 reviews while Oracle Autonomous Data Warehouse is ranked 5th in Cloud Data Warehouse with 6 reviews. Microsoft Parallel Data Warehouse is rated 7.6, while Oracle Autonomous Data Warehouse is rated 8.4. The top reviewer of Microsoft Parallel Data Warehouse writes "Collects data through SSIS packages from different sources and puts them all in one data repository". On the other hand, the top reviewer of Oracle Autonomous Data Warehouse writes "Self-patching means I generally don't need a DBA; detailed analytics make it very capable". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, Snowflake, SAP BW4HANA and Teradata, whereas Oracle Autonomous Data Warehouse is most compared with Snowflake, Microsoft Azure Synapse Analytics, Amazon Redshift, Oracle Exadata and Teradata.

See our list of .

We monitor all 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.