We performed a comparison between Azure Data Factory and Microsoft Analytics Platform System 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."We use the solution to move data from on-premises to the cloud."
"I like how you can create your own pipeline in your space and reuse those creations. You can collaborate with other people who want to use your code."
"One of the most valuable features of Azure Data Factory is the drag-and-drop interface. This helps with workflow management because we can just drag any tables or data sources we need. Because of how easy it is to drag and drop, we can deliver things very quickly. It's more customizable through visual effect."
"Data Factory's best feature is the ease of setting up pipelines for data and cloud integrations."
"From my experience so far, the best feature is the ability to copy data to any environment. We have 100 connects and we can connect them to the system and copy the data from its respective system to any environment. That is the best feature."
"The best part of this product is the extraction, transformation, and load."
"It makes it easy to collect data from different sources."
"In terms of my personal experience, it works fine."
"I like that it's integrated with other Azure products."
"Helps our customers to discover trends, which provides useful information based on their business."
"The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics."
"Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases."
"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
"It is closely integrated with other products in the MS portfolio."
"We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services."
"This is a well-integrated solution and that integration empowers results."
"The thing we missed most was data update, but this is now available as of two weeks ago."
"The initial setup is not very straightforward."
"We are too early into the entire cycle for us to really comment on what problems we face. We're mostly using it for transformations, like ETL tasks. I think we are comfortable with the facts or the facts setting. But for other parts, it is too early to comment on."
"The pricing scheme is very complex and difficult to understand."
"When working with AWS, we have noticed that the difference between ADF and AWS is that AWS is more customer-focused. They're more responsive compared to any other company. ADF is not as good as AWS, but it should be. If AWS is ten out of ten, ADF is around eight out of ten. I think AWS is easier to understand from the GUI perspective compared to ADF."
"If the user interface was more user friendly and there was better error feedback, it would be helpful."
"The solution can be improved by decreasing the warmup time which currently can take up to five minutes."
"Areas for improvement in Azure Data Factory include connectivity and integration. When you use integration runtime, whenever there's a failure, the backup process in Azure Data Factory takes time, so this is another area for improvement."
"We need better real-time analytics capabilities. It's a bit challenging for us."
"Microsoft Analytics Platform System could have better support."
"Functionality needs to be more up-to-date with competing products."
"Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release."
"Hybrid environments are complex to manage."
"Machine learning and artificial intelligence capabilities need to be more friendly for beginning users."
"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps."
"The pricing model needs to be improved."
More Microsoft Analytics Platform System Pricing and Cost Advice →
Azure Data Factory is ranked 3rd in Cloud Data Warehouse with 81 reviews while Microsoft Analytics Platform System is ranked 16th in Data Warehouse with 9 reviews. Azure Data Factory is rated 8.0, while Microsoft Analytics Platform System is rated 6.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 Analytics Platform System writes "Offers smooth data integration between systems, but requires better real-time analytics capabilities". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and IBM InfoSphere DataStage, whereas Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics, Teradata, IBM Netezza Performance Server and Snowflake. See our Azure Data Factory vs. Microsoft Analytics Platform System 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.