Microsoft's Azure Data Factory is a service built for all data integration needs and skill levels. It is designed to allow the user to easily construct ETL and ELT processes code-free within the intuitive visual environment, or write one's own code. Visually integrate data sources using more than 80 natively built and maintenance-free connectors at no added cost. Focus on data—the serverless integration service does the rest.
N/A
Redwood RunMyJobs
Score 9.4 out of 10
N/A
Redwood Business Process Automation is a workload automation and job scheduling solution designed for and
delivered via Software-as-a-Service (SaaS). It transforms the digital
enterprise with scalability and integration with all
technologies in the modern enterprise. Redwood unifies workflows across
on-premises, private, hybrid and public cloud environments. It bridges gaps in
complex processes that function between mainframe, distributed, virtual and
cloud resources. Clients use Redwood to…
Well-suited Scenarios for Azure Data Factory (ADF): When an organization has data sources spread across on-premises databases and cloud storage solutions, I think Azure Data Factory is excellent for integrating these sources. Azure Data Factory's integration with Azure Databricks allows it to handle large-scale data transformations effectively, leveraging the power of distributed processing. For regular ETL or ELT processes that need to run at specific intervals (daily, weekly, etc.), I think Azure Data Factory's scheduling capabilities are very handy. Less Appropriate Scenarios for Azure Data Factory: Real-time Data Streaming - Azure Data Factory is primarily batch-oriented. Simple Data Copy Tasks - For straightforward data copy tasks without the need for transformation or complex workflows, in my opinion, using Azure Data Factory might be overkill; simpler tools or scripts could suffice. Advanced Data Science Workflows: While Azure Data Factory can handle data prep and transformation, in my experience, it's not designed for in-depth data science tasks. I think for advanced analytics, machine learning, or statistical modeling, integration with specialized tools would be necessary.
The automation of batch processing operations like file transfers, data backups, and report production is a good fit for Redwood Workload Automation. Organizations' IT operations can be streamlined and made more efficient because to its capacity to automate and schedule these procedures across a variety of platforms. Redwood Workload Automation is highly suited for automating complicated business operations within SAP settings and has a close interaction with SAP systems. Organizations may automate and streamline their SAP processes with the help of its ability to handle SAP tasks, spools, and workflows. Redwood Workload Automation excels at automating workloads on a variety of operating systems, including Windows, Linux, Unix, and other cloud environments. This makes it a viable option for businesses that need automation across numerous systems and have complex IT infrastructures. For large businesses with complicated IT environments, Redwood Workload Automation was created. It is the perfect option for enterprises with high-volume transaction processing requirements due to its scalability and capacity for handling large-scale workloads.
It allows copying data from various types of data sources like on-premise files, Azure Database, Excel, JSON, Azure Synapse, API, etc. to the desired destination.
We can use linked service in multiple pipeline/data load.
It also allows the running of SSIS & SSMS packages which makes it an easy-to-use ETL & ELT tool.
SAP Batch Scheduling - This is THE BEST tool for triggering SAP jobs, bar none.
User management- Other scheduling tools make it much more difficult to manage user access. Redwood user access management is a breeze and take less than half the time it take in other products.
Scheduling Flexibility- The ease with which you can make custom time windows with Redwood is one of my favorite pluses. You can build as simple or as complex of a time window as you need to with Redwood.
Support- The support that you get from Redwood is in my opinion the best in the world. I have dealt with all the big name players in IT and they all pale in comparison to Redwood. You will never feel like you are in it alone with the best support in the world right at your fingertips.
A dashboard for checking the overall health of the tool
Direct excel export option is unavailable to transport the jobs.
Mobile notification is also helpful for those user who worked in 24*7 shift. if this option will available it is very useful for those user who needs to check system again and again
Being in the cloud is a big help, with less hardware to maintain, the patches and updates are fast and easily done, we have built a good working relationship with Redwood.
The Redwood user interface is straightforward. The script can be used to renew the Redwood license by just copying the text from the. txt file from start to finish of license. The current page and the status of the work can both be refreshed automatically by setting a timer in Redwood. Redwood software's eye-catching features include online help through documentation and help support, which may be accessed by clicking the "I" button in the top right corner.
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
It seems many pressing issues have to be escalated to their dev team, which I believe is mostly overseas. The response time isn't always the greatest. I go back to the documentation as well, if that was better there would be less need of support from myself. There are also times when they figure out the resolution, it has to be included with a fix in which you have to wait for the next release, however long that may be. Update - the support response time and quality of answers has greatly increased in the past 6 months or more.
The easy integration with other Microsoft software as well as high processing speed, very flexible cost, and high level of security of Microsoft Azure products and services stack up against other similar products.
Hi, We use redwood workload automation for scheduling jobs and for automatic alerts generation in case of long running and failed jobs. It provides easy access of managing jobs and controlling the flow of automation. Alerts generated keeps us up to date of the long running jobs as well as failed jobs. Configuring the jobs is easy and scheduling them through redwood makes it very effective for 24hours monitoring. The Redwood Support team is very helpful and gives prompt response and faster resolution when needed.
Simple to install Redwood Workload Automation agent servers on every server side and trigger the necessary jobs in keeping with business needs.
Allows for the interdependent scheduling of groups of Windows scripts and shell scripts.
Many problems have been fixed, such as the ability to gather data on the number of activities that are executed each day, receive email notifications when a job expires, and connect system agents to monitors.
capable of adhering to SLAs for complicated order flows
