Try our new research platform with insights from 80,000+ expert users

SSIS vs Workato comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
7.3
SSIS provides cost-effective data management efficiency, delivering ROI without extra costs apart from the SQL Server license.
Sentiment score
7.9
Workato simplifies app integration, boosting productivity and cost savings, with visible results often seen within a week.
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
By replacing multiple legacy systems and teams with a single automated platform, organizations see significant cost savings and improved business operations.
In my experience, we have seen a return on investment, with results visible within a week.
 

Customer Service

Sentiment score
6.0
Many users prefer online resources over Microsoft's good but occasionally slow and expensive technical support for critical issues.
Sentiment score
7.8
Workato's customer service earns praise for responsiveness, real-time support, and community engagement, despite limited availability and product challenges.
Whenever we faced issues with data volume, the support team helped us by suggesting solutions like breaking the data into chunks.
I reach out to the professional services team or customer success team for technical support, and they provide immediate responses.
Workato's support is robust, featuring first and second-level support.
 

Scalability Issues

Sentiment score
6.8
SSIS is moderately scalable, better for batch processing, with varied performance depending on infrastructure and implementation challenges.
Sentiment score
6.9
Workato offers scalable and elastic operations, supporting multi-region use but may face issues with higher data volumes.
There are scalability limitations with Workato.
Allows dynamic connection switching at runtime.
Even when clients overutilize the product, Workato allows them to continue without interruption, charging accordingly rather than limiting usage.
 

Stability Issues

Sentiment score
7.4
SSIS is a reliable, mature tool with minor performance concerns, praised for stability in diverse projects despite occasional issues.
Sentiment score
7.6
Workato is highly rated for stability and reliability, though occasional high-load issues require extra maintenance efforts.
It processes large volumes of data quickly.
Once deployed, solutions do not break, making it more reliable than other solutions like Microsoft Power Automate that often disconnect.
During the initial data loads with large volumes, Workato was unable to handle the data effectively, which indicates stability issues under high loads.
To handle more than 50,000 records, I use scripting actions like Python or JavaScript to process large data in chunks.
 

Room For Improvement

SSIS requires enhancements in error logging, real-time processing, and scalability while depending on external tools increases costs.
Workato needs improvements in collaboration, scalability, API management, licensing clarity, security, and more community recipes and connectors.
SSIS has a difficult learning curve when dealing with complex transformations.
Workato struggles with scalability when handling high volumes of data, such as terabytes, requiring chunking for initial data loads.
One area for improvement is the CI/CD pipeline, which lacks a version control system similar to GitHub for easier deployment.
Currently, there's no way to set breakpoints to stop the process and debug an error as you can in other tools like webMethods.
 

Setup Cost

SSIS is cost-effective for enterprises, bundled with SQL Server, but add-ons can increase costs; overall valued for integration.
Workato offers competitive enterprise pricing, benefiting users with bundled connectors and flexible, consumption-based models without hidden fees.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
While the upfront cost is high due to task-based pricing, the cost is relatively low in terms of development because Workato provides necessary connectors for integration use cases.
Compared to other iPaaS solutions like Boomi, Workato’s pricing model charges per connection step, which increases the cost.
Workato's pay-as-you-use model is competitive when compared with other iPaaS providers, making it cost-effective for organizations looking to integrate multiple functionalities under one platform.
 

Valuable Features

SSIS offers user-friendly, cost-effective ETL solutions with C# scripting, cloud deployment, and extensive support, enhancing data integration and automation.
Workato simplifies app integration with drag-and-drop UI, enabling efficient automation for non-technical users across industries.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
It allows app-to-app and real-time integrations, which significantly enhance process efficiency.
It comes with pre-built connectors, eliminating the need to write APIs.
The platform's ease of use for connecting to different integrations, like Salesforce and NetSuite, is very beneficial because development isn't necessary, and everything is readily available.
 

Categories and Ranking

SSIS
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
73
Ranking in other categories
Data Integration (4th)
Workato
Average Rating
8.4
Reviews Sentiment
7.1
Number of Reviews
17
Ranking in other categories
Integration Platform as a Service (iPaaS) (8th)
 

Mindshare comparison

SSIS and Workato aren’t in the same category and serve different purposes. SSIS is designed for Data Integration and holds a mindshare of 7.9%, up 7.9% compared to last year.
Workato, on the other hand, focuses on Integration Platform as a Service (iPaaS), holds 4.3% mindshare, up 4.2% since last year.
Data Integration
Integration Platform as a Service (iPaaS)
 

Featured Reviews

BobAmy - PeerSpot reviewer
Robust and does a good job of handling overload conditions
We purchase an add-on called task factory primarily to allow bulk delete, update, and upsert capability. I'd like to see this be part of the standard package. I believe there are ways to build a model and set variables so that it can be a generic process. In my next system, I would like to have a generic process that would handle all the logging and processing in a model that can be modified and enhanced as the need for a better process, or different statistics to be logged is discovered. I'd want this in a way that the model can be changed and all the processes, with their unique parameters, could all be changed with the model upgraded. I believe they should add some features that help to create the code using a model. This would allow for continuous improvement of the model uses and easy replication of all the different programs that use the model.
Rohit Sircar - PeerSpot reviewer
Great automation and strong workflows useful for integration
The initial setup is quite straightforward. When connecting Workato with your on-premises system, you have to install the Workato agent on your network. It was not complex but a long process to configure and settle. Workato has not gone live for us yet, so only the developers are currently using it. But in terms of users, we will have close to 250 and maybe 30 additional direct users. We are seeing a lot of different use cases where we can add new recipes because we started small, and there are many different areas where we can implement Workato for automation.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
849,963 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Computer Software Company
12%
Government
8%
Healthcare Company
6%
Educational Organization
32%
Financial Services Firm
10%
Computer Software Company
9%
Manufacturing Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
What do you like most about SSIS?
The product's deployment phase is easy.
What is your experience regarding pricing and costs for SSIS?
Utilizing SSIS involves no extra charges beyond the SQL Server license. It's an economical choice for my clients.
What do you like most about Workato?
Workato is low code, intuitive, and easy to use.
What needs improvement with Workato?
One area for improvement is the CI/CD pipeline, which lacks a version control system similar to GitHub ( /products/github-reviews ) for easier deployment. Though it has a recipe life cycle manageme...
What is your primary use case for Workato?
I am using Workato ( /products/workato-reviews ) for integrating and automating solutions for finance, HR, and IT. Specific use cases include onboarding and offboarding for HR, handling invoices fo...
 

Comparisons

 

Also Known As

SQL Server Integration Services
No data available
 

Overview

 

Sample Customers

1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
Panera Bread, Berkshire Hathaway, Salesforce, Box, Splunk, ComScore, IBM, Complex Media, Microsoft, Home Depot, Cisco, News Corp, Braille Institute
Find out what your peers are saying about SSIS vs. Workato and other solutions. Updated: May 2023.
849,963 professionals have used our research since 2012.