We performed a comparison between Azure Data Factory and Microsoft Parallel 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."For me, it was that there are dedicated connectors for different targets or sources, different data sources. For example, there is direct connector to Salesforce, Oracle Service Cloud, etcetera, and that was really helpful."
"The most valuable aspect is the copy capability."
"I can do everything I want with SSIS and Azure Data Factory."
"The user interface is very good. It makes me feel very comfortable when I am using the tool."
"I enjoy the ease of use for the backend JSON generator, the deployment solution, and the template management."
"The solution has a good interface and the integration with GitHub is very useful."
"It is a complete ETL Solution."
"Data Factory's best features are simplicity and flexibility."
"Data collection and reporting are valuable features of the solution."
"The most valuable features are the performance and usability."
"The most valuable feature for me is querying."
"We have complete control over our data."
"The data transmissions between the data models is the most valuable feature."
"The solution's integration is good."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"One of the most important features is the ease of using MS SQL."
"The solution needs to integrate more with other providers and should have a closer integration with Oracle BI."
"Lacks a decent UI that would give us a view of the kinds of requests that come in."
"There is always room to improve. There should be good examples of use that, of course, customers aren't always willing to share. It is Catch-22. It would help the user base if everybody had really good examples of deployments that worked, but when you ask people to put out their good deployments, which also includes me, you usually got, "No, I'm not going to do that." They don't have enough good examples. Microsoft probably just needs to pay one of their partners to build 20 or 30 examples of functional Data Factories and then share them as a user base."
"It's a good idea to take a Microsoft course. Because they are really helpful when you start from your journey with Data Factory."
"The product's technical support has certain shortcomings, making it an area where improvements are required."
"Azure Data Factory can improve by having support in the drivers for change data capture."
"It would be better if it had machine learning capabilities."
"Azure Data Factory's pricing in terms of utilization could be improved."
"The query is slow if we don't optimize it."
"I would like to see better visualization features."
"If the database is large with a lot of columns then it is difficult to clean the data."
"It could offer more development across the solution."
"Some compatibility issues occur during deployment, so we need to build the product from scratch for some features."
"The reporting for certain types of data needs to be improved."
"The product does not have all of the features that the native products have."
"We find the cost of the solution to be a little high."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →
Azure Data Factory is ranked 3rd in Cloud Data Warehouse with 81 reviews while Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 32 reviews. Azure Data Factory is rated 8.0, while Microsoft Parallel Data Warehouse is rated 7.6. The top reviewer of Azure Data Factory writes "The data factory agent is quite good but pricing needs to be more transparent". On the other hand, 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". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and Microsoft Azure Synapse Analytics, whereas Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA, VMware Tanzu Greenplum and Snowflake. See our Azure Data Factory vs. Microsoft Parallel 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.