G2

Shyam s.

Data Engineer

Mid-Market (51-1000 emp.)

5/4/2026

"Low-Code Drag-and-Drop That Makes Development Easy for Developers and Business Users"

4.5/5

What do you like best about Azure Data Factory?

The best part is its low-code/no-code (drag-and-drop) functionality. It makes development easier for developers and also makes the process more understandable for business users. Review collected by and hosted on G2.com.

What do you dislike about Azure Data Factory?

Sometimes it’s hard to debug. I need to check why a record is not populated before the sink. Since all my tables have a lot of data, once I join them it becomes even more, and then it’s difficult to verify why a specific record isn’t coming through. To figure it out, I have to go back and change the source table, filter down to that record, and then see which join or filter isn’t working. That’s hard and time-consuming. The parameterization syntax is also an issue and can be difficult to work with. It would help if we had AI integration for this. Review collected by and hosted on G2.com.

What problems is Azure Data Factory solving and how is that benefiting you?

We use it for ETL to migrate all source data to SQLMI. We also use it as an orchestration tool: we call the SQLMI procedures from there, and since our company is an enterprise, we have certain SSIS packages that are all orchestrated here as well. Overall, it’s a tool that helps us properly populate data in our warehouse. and from there we have outbound system salesforce and power bi where we have reports that helps for the daily discission in business Review collected by and hosted on G2.com.