2019-03-28T02:50:00Z

What needs improvement with Azure Data Factory?


Please share with the community what you think needs improvement with Azure Data Factory.

What are its weaknesses? What would you like to see changed in a future version?

Guest
1010 Answers

author avatar
Top 5Real User

The setup and configuration process could be simplified.

2020-01-12T12:03:00Z
author avatar
Top 10Real User

The user interface could use improvement. It's not a major issue but it's something that can be improved. It has the ability to create separate folders to organize objects, Data Factory objects. But any time that we created a folder we were not able to create objects. We had to drag and drop into the folder. There were no default options. It was manual work. We offered their team our feedback and they accepted my request.

2019-12-31T09:39:00Z
author avatar
Top 10Real User

The only thing that we're struggling with is increasing the competency of my team. So we think that the Microsoft documentation is too complicated. I would like to see it more connected. I know they're working on the Snowflake data warehouse connector, but more connectors would be helpful.

2019-12-23T07:05:00Z
author avatar
Top 10Real User

Because I have not really done a really deep benchmark against competitors, I may not be familiar enough with the potential of competing products and capabilities to be able able to say what is missing or should be improved definitively. From my perspective, the pricing seems like it could be more user-friendly. Of course, nothing is ever as inexpensive as you want. Perhaps one good additional feature would be incorporating more ways to import and export data. It would be nice to have the product fit our service orchestration platform better to make the transfer more fluid.

2019-12-16T08:14:00Z
author avatar
Top 5Real User

The speed and performance need to be improved. This solution should be able to connect with custom APIs.

2019-12-12T07:48:00Z
author avatar
Consultant

At this point in time, they should work on somehow integrating the big data capabilities within it. I have not explored it, but it would be good if somehow we could call a Spark job or something to do with the Spark SQL within ADS so that we wouldn't need a Spark tested outside. On the UI side, they could make it a little more intuitive in terms of how to add the radius components. Somebody who has been working with tools like Informatica or DataStage gets very used to how the UI looks and feels. In ADS, adding a new table or joining a new table and overriding that with an override SQL that I could customize would be helpful. Being able to debug from the design mode itself would be helpful.

2019-12-09T10:58:00Z
author avatar
Top 10Consultant

It would be helpful if they could adjust the data capture feature so that when there are source-side changes ADF could automatically figure it out. The solution needs to integrate more with other providers and should have a closer integration with Oracle BI.

2019-12-05T11:14:00Z
author avatar
Top 10Real User

The solution could use some merge statements. 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.

2019-11-18T07:22:00Z
author avatar
Top 20Consultant

I think more integration with existing Azure platform services would be extremely beneficial. In the next release, it's important that some sort of scheduler for running tasks is added. A built-in scheduling mechanism for running the treasury will be a very helpful improvement.

2019-07-29T10:11:00Z
author avatar
Top 20Consultant

Data Flow is in the early stages — currently public preview — and it is growing into a tool that will offer everything other ETL tools offer. There are a few features still to come. The thing we missed most was data update, but this is now available as of two weeks ago. A feature that is confirmed as coming soon is the ability to pass in a parameter and filter, etc.

2019-03-28T02:50:00Z
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
442,194 professionals have used our research since 2012.