ADF is a cloud data integration service, to compose data storage, movement, and processing services into automated data pipelines. Very easy to set up and manage data pipelines, and how to move and transform data for analysis.

Review collected by and hosted on G2.com.

The UI might have been a bit more intuitive. Easier option of setting error notifications should be introduced Review collected by and hosted on G2.com.

Ability to scaling the work pipeline workload, Web interface and introduce data flows Review collected by and hosted on G2.com.

The costing is hard to understand. Lack of flexibility in the pipelines Review collected by and hosted on G2.com.

its design as well as its high compatibility with Azure products and how easy is to make those connections through MSI or Azure key Vault Review collected by and hosted on G2.com.

Some features don't work, the options are there but they do nothing. Creating the right script for automating the pipelines through C# was a pain due to outdated documentation. There are some errors on the UI with firefox, the debugger is not real and the errors sometimes are not very descriptive Review collected by and hosted on G2.com.

The ability to visualize and establish connection to various data sources from API, SFTP server, data lake, sql server... etc. Visualising and setting up pipelines of data flow is made easy and seamless. The tool allows you to create your own structure and data convention. The integration with devops is amazing ! Review collected by and hosted on G2.com.

The fact that it lets you build you own structure, pre existing template for the structure would be perfect! Review collected by and hosted on G2.com.

Using a runbook, you can schedule your Integration Runtime to only run when necessary (saving HUGE dollars). Ours runs for an hour during the night and we schedule our SSIS packages accordingly. Review collected by and hosted on G2.com.

Like much of the Microsoft Platform, the solution can be a bit cumbersome to learn. Help articles leave much to be desired. Review collected by and hosted on G2.com.

It is mainly used to retrieve bulk data from various systems and integrate with different systems. Like the idea of using having pipelines and triggers. we use various types of triggers like blob and schedule triggers to make the pipeline run at predefined times Review collected by and hosted on G2.com.

The thing which we don't like about is the error description is not very descriptive and the way to run manually is not very useful. after debugging the information is not stored anywhere. Review collected by and hosted on G2.com.

Easy to use and manage the linked services over the network. Data sets defination is pretty simple to define and great thing i can map the same with file based data as well just definig a path for it. Its connectivity with different data stores is amazing. Easy to review and monitoring of the logged data. Creating new pipleline is pretty simple and can schedule these as per the need. Review collected by and hosted on G2.com.

As i noticed azure data factory can not pull the data directly from virtual machine, this can be only done with linked services. Review collected by and hosted on G2.com.

Everything is pretty much straightforward, given that you have some database knowledge. The DBMS allows you to easily create several things entirely in design (tables, views, etc) - which is a big plus when you don't know the entire syntax. Mainly, the ability to extract the precise data is the best part for me.

THe reasons made me use this product were :

Create internal/operational efficiencies

Drive revenue growth

Enhance decision making

Improve business process agility

Improve business process outcomes Review collected by and hosted on G2.com.

Scalability is great but not the best like other new databases there in the market. CPU memory consumption is always more than normal on production. Difficult to setup permissions and roles. On that point i want to suggest that SQL server has always fulfilled the new requirements and has great features to utilize. This will always exceed your expectation for sure. If your environment is window and you want a full secure fast native database SQL server is the product you are looking for. Review collected by and hosted on G2.com.

Data factory has been a great tool move data from the data lake through SQL into PowerBI. The best part is the ability to create and automate pipelines with preloading scripts Review collected by and hosted on G2.com.

It is not very intuitive. When I first started using df there was a lot to learn and figure out. Once you get the hang of it though there is a lot of opportunity Review collected by and hosted on G2.com.

Azure Data Factory is very easy to use with drag and drop functions. It's secured, scalable and supports code in Python, .NET o ARM. Review collected by and hosted on G2.com.

Azure Data Factory is really brilliant but I had problems with the installing and configurations as same as other products of Microsoft Azure Review collected by and hosted on G2.com.