Azure Data Factory vs. CA Workload Automation

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

If batch jobs are heavily used then this product is highly recommended since it maintains dependencies between jobs, notifies if there are any failures, and puts the next batches on hold if previous dependent jobs fails.

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

• Workload can be scheduled across different Platforms.
• Support for Hadoop. Integration with Informatica Dataware house application.
• The latest version has a web interface which is very impressive.
• Low overheads from administration standpoint.

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

• Even though the CA Workload Automation GUI is simple and easy to use, it looks outdated and has limited features such as customizing dashboards and saving particular user settings.
• CA Workload Automation lacks performance and is often slow to edit jobs or to refresh screens and sometimes requires admin to restart service agents for background processes.
• I would like to see CA Workload Automation in one screen with all the information the user wants to see and have this customized and saved for every user. Rather than having to build a view and search criteria for every new job that is added.
• I would like a feature or configuration that you can setup different types of notifications for job failures such as text message with different levels of severity.

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

Very happy!

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

It would be great if customer chat experience is also readily available.

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

CA Workload Automation stacks up very well compared to Cisco/Tidal, BMC and is far superior to crontab. CA Workload Automation has easy initial setup, efficient job management and scheduling, supports multiple applications and environments and improves business critical needs including SLA, increasing productivity while decreasing processing workload times and failures. CA Workload Automation also integrates well with Automation Change Control Expert or ACCE which is a nice migration tool to have if you're managing jobs in the thousands.

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

• Positively affected in resolving issues through alerts during peak traffic.
• Monitoring directly help during Thanksgiving and Black Friday traffic.
• Reporting helped in explanation of issues to higher management.

Incentivized