How can we improve Microsoft Azure Data Factory?

WYSIWIG UI

The JSON editor is OK but is still a barrier to entry. A WYSIWIG UI based on SSIS/Machine Learning Studio would really make this easier to use.

358 votes
Vote
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
You have left! (?) (thinking…)
Rob Henwood shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
started  ·  Azure Data Factory Team on UserVoice responded  · 

Thanks for your feedback. We are working towards an authoring experience that will be very easy and intuitive for you. We will be sharing more details in the coming months.

10 comments

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...
  • Alejandro Leguizamo commented  ·   ·  Flag as inappropriate

    It is amazing how teams are not talking and learning from each other... This is something that the SSIS team solved more than 10 years ago. The experience with control of the flow , ability to restart a full segment of the pipeline, monitor what is happening, and let alone Develop, feel like a 100 steps back from the elegance of SSIS that is available today. As the product is today, there are no significant gains in developer productivity

  • Sherin commented  ·   ·  Flag as inappropriate

    we are using ADF to Data movement and transformation. However there is not user interface for Transformation activity. Grouping and parallel execution of similar pipelines will be much easier if there was grouping or container option. I think it will benefit a lot from inheriting SSIS features such as Control flow links and container

  • Phil Slater commented  ·   ·  Flag as inappropriate

    There is also a separate "Data Factory needs a GUI" vote which looks like the same thing.

  • offbeatmammal commented  ·   ·  Flag as inappropriate

    Creating an ADF job should not require a cut'n'paste exercise where you have to track a bunch of notepad items for the source and destination. If the resources are available on the logged in users account then they should be available as dropdowns, and transforms and cleaning should be a cleaner process

  • Teodoro commented  ·   ·  Flag as inappropriate

    it could be great to transform xml and xls to SQL Tables graphically (without using JSON files)

Feedback and Knowledge Base