Azure Data Factory vs. Microsoft Power Automate

In a data pipeline, you will be able to add different kinds of activities for example connect from your on-premise SFTP and move CSV files to storage accounts. As well data factory has its own data flow if you are an ETL developer who experimented with maybe you have worked with SSIS, thus, you will start quickly with this new feature of the data factory.

Incentivized

We replaced all the classic SharePoint and Nintex-based workflows with Power Automate. This saved extra licensing costs and getaways from managing legacy workflows. Power Automate Designer is very user-friendly and requires no additional learning curve. We also use it to replace RPA solutions created with other platforms using the Power Automate Desktop application.

Incentivized

• Creating ETL and ELT workflows as well as orchestrating and monitoring pipelines without writing any code.
• Hybrid data integration is easily and agilely possible through this software.
• It has lot of various useful components

Incentivized

• Sending confirmation email to clients and user once the flow is triggered.
• Fetching or Dumping files from one location to another if the flow is triggered.
• Schedule flow helps to send alerts and triggers the flow at a specific interval of time to carry out the required task.
• Power Automate also be used to convert any file format to a specific file format and save it to the required location

Incentivized

• Learning curve for pipeline creation interface.
• Alerting isn't necessarily built in. Had to work around this to meet team needs.
• With GIT enabled, some features can only be done via git, while some need to be done via the portal.

Incentivized

• No activity disable feature in the workflow, this would have saved lot of time
• Allow turn off feature to not trigger any pending runs in the queue or add new feature to just run pending runs when the workflow is turned off
• Allow easy copy and paste activities from UI

Incentivized

Power Automate is a great product that has a vast array of options on how to use it. Your imagination is the only hurdle with using Power Automate as there is no limit to what can be done with the system. It has brought a lot of value to our business through the use of custom systems, connectors, and streamlining processes.

Incentivized

So far product has performed as expected. We were noticing some performance issues, but they were largely Synapse related. This has led to a shift from Synapse to Databricks. Overall this has delayed our analytic platform. Once databricks becomes fully operational, Azure Data Factory will be critical to our environment and future success.

Incentivized

For most tasks WinAutomation is great and easy to use. You just set up tasks on a step by step basis and you can even tell the program what to do when there is an error (such as continue with job). Sometimes with complicated web extraction jobs it would be good to be able to easily extract data from the web page source.

Incentivized

We have not had need to engage with Microsoft much on Azure Data Factory, but they have been responsive and helpful when needed. This being said, we have not had a major emergency or outage requiring their intervention. The score of seven is a representation that they have done well for now, but have not proved out their support for a significant issue

Incentivized

both Community support and Microsoft official support typically respond to (and resolve) reported issues in a VERY expedient manner, usually going above and beyond for education and bugfixing. I have been thoroughly impressed with the level of support I had been provided in the past.

Incentivized

after reviewing the main features of Power Automate, the Microsoft trainer focused on some of our real life use cases implementation, from simple to more advanced.

Incentivized

although it was productive, it is more difficult to stay focused and in a 7 hours a day online training (including screen share issues and the fact that the trainer just can't precisely show the exact location of your mistake)

Incentivized

I had to migrate from Robocorp to Power Automate. The automation was using API and sharepoint. So it was better to use Power Automate instead of Robocorp so we did the migration. in some areas the migration was easy but creating flows and making it smaller codes was difficult. Debugging the code was tough so we took lots of time.

Incentivized

Azure Data Factory fits well into our overall systems architecture where we already utilize largely Azure services and also Microsoft based products in the on-premises environment. I think cost structure is also very competitive with Azure Data Factory. Most services provide a visual interface for designing ETL workflows, but our team found Azure Data Factory's interface more intuitive.

Incentivized

Power Automate can do many things that most platforms can't do as a 'citizen-developer' with no access to coding tools and deployment. It allows you to develop and deploy low/no-cost automation flows quickly. The blocks in Powert Automate do the API work for you, where you only need to connect the key data points and actions taken.

Incentivized

• Limiting the amount of data moving up and down from the cloud for cloud-native applications.
• Overall simple to use interface which is actually easier for a first time ETL developer than SSIS.

Incentivized

• Automating emails for finance and payroll has not only saved hours of work for those departments but lowers the risk of human error.
• Creating workflows and approvals for our goals and bonus system has saved everyone in the organization hours of manual work and MATH!

Incentivized