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

SSIS vs Workato comparison

The compared Microsoft and Workato solutions aren't in the same category. Microsoft is ranked #4 in DI , with an average rating of 7.7, and holds a 8.8% mindshare in the category. Workato is ranked #9 in PaaS , with an average rating of 8.0, and holds a 3.8% mindshare. Additionally, 79% of Microsoft users are willing to recommend the solution, compared to 100% of Workato users who would recommend it.
SSIS
Read 72 SSIS reviews
  • 14,200 Views
  • 11,375 Comparison Views
79% willing to recommend
Workato
Read 9 Workato reviews
  • 1,318 Views
  • 763 Comparison Views
100% willing to recommend
 

Comparison Buyer's Guide

Download the report
Executive Summary
We performed a comparison between SSIS and Workato based on real PeerSpot user reviews.

Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

DOWNLOAD THE COMPLETE REPORT
To learn more, read our detailed SSIS vs. Workato Report (Updated: May 2023).
Buyer's Guide
SSIS vs. Workato
May 2023
Download the complete report
Helped 824,067 peers since 2012
 

Categories and Ranking

SSIS
Average Rating
7.6
Reviews Sentiment
6.7
Number of Reviews
72
Ranking in other categories
Data Integration (4th)
Workato
Average Rating
8.4
Reviews Sentiment
7.0
Number of Reviews
9
Ranking in other categories
Integration Platform as a Service (iPaaS) (9th)
 

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.8%, down 9.5% compared to last year.
Workato, on the other hand, focuses on Integration Platform as a Service (iPaaS), holds 3.8% mindshare, down 4.8% 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.
Read full review
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.
Read full review

Quotes from Members

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

Pros

"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"The data reader is the most valuable feature."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The solution is easy to use and developer friendly."
"SSIS is easy to use."
"The setup is straightforward. It's very easy to install."
More SSIS pros
"Stability-wise, I rate the solution a ten out of ten."
"The most valuable features are easy integration, quick tab to develop, quick tab to market, and interactive integration platform."
"It is very easy to use. It takes complex workloads away, and it provides very smooth integration. It has got a lot of out-of-the-box connectors. It has got a lot of out-of-the-box APIs, which makes it really easy to integrate with applications for different use cases, whether it is in finance, HR, or customer operations. It is by far our favorite integration product."
"Workato is low code, intuitive, and easy to use."
"It's easy to understand, makes flows and is efficient."
"It is easier to use than other technical open-source technologies."
"Their automation and workflows are very strong, and you can build the workflows very easily and quickly."
 

Cons

"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"Future releases should improve the data lineage, as it currently is not good."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"Options for scaling could be improved."
"The security could be improved, as it is more important in our context."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"The performance of this solution is not as good as other tools in the market."
More SSIS cons
"A limitation is that their cloud presence is only in North America and Europe."
"From the deployment point of view, our customers encounter platform downtime where it does not serve the actual request on the systems."
"Workato's Extract, transform, and load (ETL) and extract, load, and transform (ELT) are not very strong and could be improved for very complex transformations."
"The management dashboard in the solution is an area with shortcomings that needs improvement."
"I would like to see the dashboarding and reporting processes improved."
"It is tedious to make a tailor-fit function."
"The only minor drawback would be if there was a UI at the front of it, for apps and for a portal as well, it would make it really easy. It would be really useful if there were more apps capabilities."
 

Pricing and Cost Advice

"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."
"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
"SSIS is a cheaper option compared to the cost of other ETL tools."
"Our license with SSIS is annual."
"This solution has provided an inexpensive tool, and it is easy to find experienced developers."
"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."
"The solution is available at a lesser price than that of Informatica."
"SSIS' licensing is a little high, but it gives good value for money."
More SSIS pricing and cost advice
"Workato is an expensive solution."
"On a scale of one to ten, the pricing is around a six. We have a consumption model and the pricing is higher. If you are using any kind of ML-based approach, machine learning, or some advanced analytics, you may have to pay more."
"Speaking about price, I would say that it's market-related. Also, there are costs in addition to the standard license fees since different add-ons depend on what you require."
report
See which vendors are best for you
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
See recommendations
824,067 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…
Read full review
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Computer Software Company
12%
Government
8%
Manufacturing Company
6%
Educational Organization
42%
Computer Software Company
8%
Financial Services Firm
8%
Manufacturing Company
5%
 

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...
See all answers
What do you like most about SSIS?
The product's deployment phase is easy.
See all answers
What is your experience regarding pricing and costs for SSIS?
The solution comes free of cost.
See all answers
What do you like most about Workato?
Workato is low code, intuitive, and easy to use.
See all answers
What needs improvement with Workato?
Workato's Extract, transform, and load (ETL) and extract, load, and transform (ELT) are not very strong and could be improved for very complex transformations. Workato's licensing model is a bit co...
See all answers
What is your primary use case for Workato?
We use Workato for iPaaS, which is like a middleware enterprise service bus. We use it for transformation, quick data migrations from one platform to another, and building connectivity. It's got ov...
See all answers
 

Comparisons

Informatica PowerCenter vs SSIS Logo
Informatica PowerCenter vs SSIS
Compared 23% of the time
Talend Open Studio vs SSIS Logo
Talend Open Studio vs SSIS
Compared 13% of the time
Oracle Data Integrator (ODI) vs SSIS Logo
Oracle Data Integrator (ODI) vs SSIS
Compared 8% of the time
IBM InfoSphere DataStage vs SSIS Logo
IBM InfoSphere DataStage vs SSIS
Compared 8% of the time
AWS Glue vs SSIS Logo
AWS Glue vs SSIS
Compared 4% of the time
More SSIS Competitors
Microsoft Azure Logic Apps vs Workato Logo
Microsoft Azure Logic Apps vs Workato
Compared 25% of the time
Azure Data Factory vs Workato Logo
Azure Data Factory vs Workato
Compared 16% of the time
SAP Process Orchestration vs Workato Logo
SAP Process Orchestration vs Workato
Compared 8% of the time
Oracle Integration Cloud Service vs Workato Logo
Oracle Integration Cloud Service vs Workato
Compared 8% of the time
Informatica PowerCenter vs Workato Logo
Informatica PowerCenter vs Workato
Compared 4% of the time
More Workato Competitors
 

Product Reports

Buyer's Guide
SSIS
November 2024
SSIS reportDownload SSIS product report
Buyer's Guide
Workato
November 2024
Workato reportDownload Workato product report
 

Also Known As

SQL Server Integration Services
No data available
 

Learn More

Microsoft
Workato
 

Overview

SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.

Named a Leader in iPaaS for Dynamic Integrations by Forrester, Workato is a modern automation and integration platform. With its enterprise-grade capabilities, you can seamlessly integrate and orchestrate workflow automation across cloud and on-premise applications, files and databases without coding.

The Workato team comes from a deep background in building integration products and will continue to expand and change the automation and integration space.

Start your 30-day free trial here.

 

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
Buyer's Guide
SSIS vs. Workato
May 2023
Free Report: SSIS vs. Workato
Find out what your peers are saying about SSIS vs. Workato and other solutions. Updated: May 2023.
DOWNLOAD NOW
824,067 professionals have used our research since 2012.
See our SSIS vs. Workato report.

We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.