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…
N/A
SSIS
Score8 out of 10
N/A
Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.
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.
As I mentioned earlier SQL Server Integration Services is suitable if you want to manage data from different applications. It really helps in fetching the data and generating reports. Its automation make it very easy and time efficient. It works well with large database as well. But it doesn't work well with real time data, it will take some time to gather the real time data. I would not recommend using it in a real time/fast-paced environment.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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 de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Connection managers for online data sources can be tricky to configure.
Performance tuning is an art form and trialing different data flow task options can be cumbersome. SSIS can do a better job of providing performance data including historical for monitoring.
Mapping destination using OLE DB command is difficult as destination columns are unnamed.
Excel or flat file connections are limited by version and type.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
Some features should be revised or improved, some tools (using it with Visual Studio) of the toolbox should be less schematic and somewhat more flexible. Using for example, the CSV data import is still very old-fashioned and if the data format changes it requires a bit of manual labor to accept the new data structure
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
SSIS is a great tool for most ETL needs. It has the 90% (or more) use cases covered and even in many of the use cases where it is not ideal SSIS can be extended via a .NET language to do the job well in a supportable way for almost any performance workload.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
SQL Server Integration Services performance is dependent directly upon the resources provided to the system. In our environment, we allocated 6 nodes of 4 CPUs, 64GB each, running in parallel. Unfortunately, we had to ramp-up to such a robust environment to get the performance to where we needed it. Most of the reports are completed in a reasonable timeframe. However, in the case of slow running reports, it is often difficult if not impossible to cancel the report without killing the report instance or stopping the service.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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 support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
I think SQL Server Integration Services is better suited for on-premises data movement and ADF is more suited for the cloud. Though ADF has more connectors, SQL Server Integration Services is more robust and has better functionality just because it has been around much longer
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Without this, we would have to manually update a spreadsheet of our SQL Server inventory
We would also have poor alerting; if an instance was down we wouldn't know until it was reported by a user
We only have one other person who uses SQL Server Integration Services , he's the expert. It would fall to me without him and I would not enjoy being responsible for it.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
