Azure Data Factory Reviews & Product Details

1. Easy to use (Gives access to read data from multiple sources and data of multiple format)

2. Linked services gives lots of connection with other platform almost making it cross platform

3. Excellent ETL tool with lots of inbuilt activities.

4. Connection with Databricks notebook and it's integration is top class.(In case of complex ETL works we can use Databricks and call it directly to ADF pipeline)

5. Data Flow are easy to implement and very minimal code is required. Review collected by and hosted on G2.com.

Fails to perform complex transformation.

Limitation of not able to perform more operations than Int32. Review collected by and hosted on G2.com.

What I like best about Azure Data Factory is its robust and versatile data integration capabilities. It offers a wide range of connectors and tools to efficiently manage and transform data from various sources. Its user-friendly interface, combined with the flexibility to handle complex workflows, makes it an excellent choice for orchestrating data pipelines. The seamless integration with other Azure services also enhances its functionality, making it a powerful tool for data engineering tasks. Review collected by and hosted on G2.com.

The one aspect that could be improved is the cost management, if not carefully monitored, the expenses can add up quickly, particularly when dealing with large volumes of data or frequent pipeline runs. Review collected by and hosted on G2.com.

The best thing I like is its very easy to integrate with various Database and very easy to use the linked servies and also very affordable Review collected by and hosted on G2.com.

The ADF is very limited logging of pileine and monitoring the pipeline Review collected by and hosted on G2.com.

The easiness and the UI is the best among all other of it's competition. The UI is very easy and you create data pipeline in a a few click of buttons. The workflow allows you to perform data transformation which is again a drag-drop feature which allows new users to easily use it. Review collected by and hosted on G2.com.

I only thing which I think is missing is an easier way to integrate with power bi. I wish they could have provide more feature or easier way to refresh and load power bi semantic models. Review collected by and hosted on G2.com.

Azure data factory is great to use for data transformation. you can easily extract ,transform, load data using azure data factory. it has integration with clod and non cloud services and database. you can easily migrate your data of onprem to cloud using azure data factory. it has data flows , process which is very easy to use . Integration with any popular database is very easy. you can process files stored in any storage type and put the transformed data in any databse. Azure data factory has many inbuilt function which can be used for your data processing. you can easily process excel and CSV files data and perform operation like SQL very easy. Azure adoption is worldwise now. this can be used by any small and big organization easily. Customer support is also great. Review collected by and hosted on G2.com.

I am happy to use ADF. ADF just need to add more connectors with other third party data providors. Also logging can be improved further. Review collected by and hosted on G2.com.

One of the best and easy to use ETL tool by microsoft.

It provide lots of feature like large number of source data connector,basic and advanced transformation option for better data integration,management and ingestion.

It offer automated and manual method for executing or debugging pipeline which futher require less coding skills.

Simple and interactive graphical user interface with high customer support.

It is more benifical for small business as it is less expensive and offer more scalability option. Review collected by and hosted on G2.com.

As till now, I did not found any feature or option that I do not like about azure data factory ,everything is up to the need. Review collected by and hosted on G2.com.

It is a simple,easy to use ETL tool with high customer support.

For data ingestion ,it can connect to multiple source like big data services files etc.

Can also integrate with other azure services(like databricks,azure devops) with ease.

It offer user friendly inteface to run or bebug pileline activities.

It's has quite rich drag and drop features which futher require less coding skills . Review collected by and hosted on G2.com.

Sometime pileline execuition tooks more time as compare to the expected time due to some internal pipeline failure that are not easy to debug in ADF.

Difficult to write complex transformation logic in ADF. Review collected by and hosted on G2.com.

Most impressive feature of data factory is to impliment with multiple data source and multiple processing technique, Mostly the data looping part , where ican process data before migrating to new system, also visualizing the solution and drag drop option of feature makes it ultimate in this domain, Review collected by and hosted on G2.com.

One part i found little disappointing that inspite of having so many type of data connection . it is still not supporting to upload data to google bucket ,also trouble shooting pf problem should be more clear Review collected by and hosted on G2.com.

First thing that I like about ADF is, it can connect to many data source like it may be big data services,azure data services,files ,warehouse etc. to ingest data to destination.

Drag and drop features of ADF are very usefull and required less coding .

Debugging and testing of pipeline activity is easy in ADF.

Like the GUI of ADF platform . Review collected by and hosted on G2.com.

Proper Documentation of Azure Data Factory must be maintained by microsoft so that new user get basic idea about it.

Due to less code feature,it is difficult to write complex transformation scripts.

Sometime pipeline execution take more time as compared to required.

To move user from dev to prod required understanding about CI/CD pipeline which is very complex. Review collected by and hosted on G2.com.

ADF is cloud based Data integration tool on azure cloud. Its the fastest and best ETL tool out there comapred to onpremise and other cloud based ETL tool like Informatica, IICS, Talend, IBM datastage etc. It support so many connectors and lot of file formats. you can do so mant data integration transformation using ADF with ease and drag and drop features. Also you can view your data activities and its transformed data in real time instead of navigating each time to database and files like Azure sql server, oracle, JSON etc. it has awsome integration with big data tools like databricks, synapse analytics and blob storage. Review collected by and hosted on G2.com.

Microsoft done a great job to create this tool and there are nothing much but if the can provide more support to other different vendor connectors, databases for its transfromation activities as most of it only support to azure related storage. I mean there are few crucial activites like get metadata, until, stored procedure etc, although they are keep adding and supporting to new connectors in each update. Review collected by and hosted on G2.com.