We performed a comparison between Azure Data Factory and erwin Data Catalog by Quest based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."On the tool itself, we've never experienced any bugs or glitches. There haven't been crashes. Stability has been good."
"We have found the bulk load feature very valuable."
"The two most valuable features of Azure Data Factory are that it's very scalable and that it's also highly reliable."
"Microsoft supported us when we planned to provision Azure Data Factory over a private link. As a result, we received excellent support from Microsoft."
"I can do everything I want with SSIS and Azure Data Factory."
"Azure Data Factory's most valuable features are the packages and the data transformation that it allows us to do, which is more drag and drop, or a visual interface. So, that eases the entire process."
"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."
"The data catalog feature is pretty good."
"When you combine it with data lineage, every time you need to make a change, it allows you to do impact analysis on any changes and then connect to the end-users or data stewards so that they can be aware that a change is coming. That's one of the main benefits we use it for."
"Integration of data lineage would be a nice feature in terms of DevOps integration. It would make implementation for a company much easier. I'm not sure if that's already available or not. However, that would be a great feature to add if it isn't already there."
"There should be a way that it can do switches, so if at any point in time I want to do some hybrid mode of making any data collections or ingestions, I can just click on a button."
"The solution should offer better integration with Azure machine learning. We should be able to embed the cognitive services from Microsoft, for example as a web API. It should allow us to embed Azure machine learning in a more user-friendly way."
"When the record fails, it's tough to identify and log."
"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."
"The user interface could use improvement. It's not a major issue but it's something that can be improved."
"Lacks in-built streaming data processing."
"There is room for improvement with respect to the connector and how to connect to the structured and unstructured database."
"There are always ways to improve things. For example, we can use AI to be able to find out something. When we are typing something, if we don't know the exact term, Artificial Intelligence would be useful to find terms that are phonetically or syntactically similar. Instead of having to type in the exact name, they can provide those in the list. So, they can provide AI support for the search because when you have thousands and thousands of terms, it is hard to remember all the names."
Azure Data Factory is ranked 1st in Data Integration with 81 reviews while erwin Data Catalog by Quest is ranked 12th in Metadata Management with 2 reviews. Azure Data Factory is rated 8.0, while erwin Data Catalog by Quest 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 erwin Data Catalog by Quest writes "Helps with metadata management, saves time, and allows us to do impact analysis on any changes". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and Microsoft Azure Synapse Analytics, whereas erwin Data Catalog by Quest is most compared with Informatica Enterprise Data Catalog, Talend Open Studio, Oracle Data Integrator (ODI) and Alation Data Catalog.
We monitor all Data Integration 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.
