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
8.5
Workato streamlines integration, boosts productivity, enhances database management, allows developer focus, and yields significant ROI 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.
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
8.6
Workato's support is highly rated for responsiveness and effectiveness, though users want availability during Singapore working hours.
I reach out to the professional services team or customer success team for technical support, and they provide immediate responses.
Whenever we faced issues with data volume, the support team helped us by suggesting solutions like breaking the data into chunks.
 

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.1
Workato's cloud-based scalability and licensing flexibility generally meet user expectations, despite some limitations with high data volumes.
There are scalability limitations with Workato.
 

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
6.5
Workato is stable and reliable, but faces deployment issues and performance challenges under high data volumes.
It processes large volumes of data quickly.
During the initial data loads with large volumes, Workato was unable to handle the data effectively, which indicates stability issues under high loads.
 

Room For Improvement

SSIS requires enhancements in error logging, real-time processing, and scalability while depending on external tools increases costs.
Workato needs enhancements in team collaboration, feature discoverability, global cloud presence, scalability, and transparency in licensing.
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.
 

Setup Cost

SSIS is cost-effective for enterprises, bundled with SQL Server, but add-ons can increase costs; overall valued for integration.
Workato offers flexible pricing with options like subscriptions and recipe-based plans, tailored to enterprise needs and usage levels.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
 

Valuable Features

SSIS offers user-friendly, cost-effective ETL solutions with C# scripting, cloud deployment, and extensive support, enhancing data integration and automation.
Workato offers an intuitive no-code platform for quick app integration, saving time with drag-and-drop and pre-built connectors.
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.
Workato reduces total development time as it generates code seamlessly and integrates with SQL databases or APIs through configuration.
 

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.0
Number of Reviews
11
Ranking in other categories
Integration Platform as a Service (iPaaS) (11th)
 

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 8.0%, up 8.0% compared to last year.
Workato, on the other hand, focuses on Integration Platform as a Service (iPaaS), holds 4.0% mindshare, down 4.3% since last year.
Data Integration
Integration Platform as a Service (iPaaS)
 

Featured Reviews

Sakiru Dosumu - PeerSpot reviewer
Its ability to transform and transport data is extremely valuable
he ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs.
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.
842,466 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
38%
Computer Software Company
10%
Financial Services Firm
9%
Manufacturing Company
6%
 

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?
The Electronic Data Interchange (EDI ( /categories/edi )) capabilities could be improved.
What is your primary use case for Workato?
I use Workato ( /products/workato-reviews ) as middleware for cloud integration within my organization. It is employed to integrate systems such as ERP ( /categories/erp ) and customer planning sys...
 

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.
842,466 professionals have used our research since 2012.