SSIS vs Workato comparison

Read 28 Workato reviews

3,092 Views
1,732 Comparison Views

100% willing to recommend

SSIS

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.

To learn more, read our detailed SSIS vs. Workato Report (Updated: May 2023).

Download the complete report

SSIS vs. Workato

May 2023

Helped 881,707 peers since 2012

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

6.5

SSIS is cost-effective, enhancing data management efficiency and integration with SQL Server, providing significant operational and financial benefits.

Sentiment score

3.9

Workato offers quick integration, enhances productivity, consolidates systems, reduces manual tasks, optimizes costs, and ensures faster ROI.

The tool has made us tremendously more efficient and saved us a significant amount of money.

Manager, Data Operations at a manufacturing company with 5,001-10,000 employees

Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.

For more quotes and insights, download the SSIS report

Managing Partner at Dynamis Informatica

By replacing multiple legacy systems and teams with a single automated platform, organizations see significant cost savings and improved business operations.

Kiran Vishwanath

Director at Infoteck Solutions

For main recipes, there are charges, so by focusing on creating as many callable recipes as possible based on requirements, we can improve cost efficiency for the business.

reviewer2723727

Integration Engineer

In my experience, we have seen a return on investment, with results visible within a week.

Pradeep Nunna

Integration and Solution Architect/AI Engineer (Boomi and Workday) at Tech Bridger

For more quotes and insights, download the Workato report

Customer Service

Sentiment score

6.0

Users find Microsoft support adequate for critical issues but often use online resources and community support for minor ones.

Sentiment score

5.9

Workato's customer service is praised for responsiveness, though complex issues may face delays due to product and time zone constraints.

The first line of support needs to be more knowledgeable.

For more quotes and insights, download the SSIS report

Manager, Data Operations at a manufacturing company with 5,001-10,000 employees

Whenever we faced issues with data volume, the support team helped us by suggesting solutions like breaking the data into chunks.

CTO at Atulya Abhinav Tech Private Limited

I reach out to the professional services team or customer success team for technical support, and they provide immediate responses.

Pradeep Nunna

Integration and Solution Architect/AI Engineer (Boomi and Workday) at Tech Bridger

Workato's support is robust, featuring first and second-level support.

For more quotes and insights, download the Workato report

Senior Software Engineer at a tech vendor with 5,001-10,000 employees

Scalability Issues

Sentiment score

6.7

SSIS is effective for small to medium enterprises but may face challenges with scalability and performance for large datasets.

Sentiment score

6.0

Workato is praised for its scalability, efficiently managing applications and cloud operations, though large datasets may impact performance.

I would rate the scalability of SSIS at a 7 because we are able to use various third-party items with it, allowing for functionality with a number of different things.

reviewer2318280

Tech Lead at a consultancy with 11-50 employees

For more quotes and insights, download the SSIS report

There are scalability limitations with Workato.

For more quotes and insights, download the Workato report

CTO at Atulya Abhinav Tech Private Limited

Allows dynamic connection switching at runtime.

Sowmya Nagaraja

Technical Consultant at Intercede Solutions

Even when clients overutilize the product, Workato allows them to continue without interruption, charging accordingly rather than limiting usage.

Kiran Vishwanath

Director at Infoteck Solutions

Stability Issues

Sentiment score

7.4

SSIS is highly rated for stability and performance, though minor issues and cloud discrepancies are occasionally noted by users.

Sentiment score

6.7

Workato is praised for stability and reliability, with minor issues occasionally reported, and generally receives high user ratings.

It processes large volumes of data quickly.

For more quotes and insights, download the SSIS report

Managing Partner at Dynamis Informatica

Once deployed, solutions do not break, making it more reliable than other solutions like Microsoft Power Automate that often disconnect.

Martin Rubens

Practice Manager at a consultancy with 201-500 employees

During the initial data loads with large volumes, Workato was unable to handle the data effectively, which indicates stability issues under high loads.

CTO at Atulya Abhinav Tech Private Limited

To handle more than 50,000 records, I use scripting actions like Python or JavaScript to process large data in chunks.

For more quotes and insights, download the Workato report

Senior Software Engineer at a tech vendor with 5,001-10,000 employees

Room For Improvement

SSIS needs enhanced error logging, diverse data integration, user management, ease of use, scalability, and better documentation support.

Workato requires improvements in user features, licensing clarity, complex integration, scalability, security, and AI for better functionality.

Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.

Sean Achim

Managing Director at Knights Innovation Support Centre

SSIS has a difficult learning curve when dealing with complex transformations.

Managing Partner at Dynamis Informatica

The logging capabilities could be improved, particularly for error logging.

For more quotes and insights, download the SSIS report

Manager, Data Operations at a manufacturing company with 5,001-10,000 employees

The team is actively working on customizing the platform per client requirements and is rapidly releasing features to address these limitations.

AshishPatil1

Technical Consultant at IST Technology

Workato struggles with scalability when handling high volumes of data, such as terabytes, requiring chunking for initial data loads.

CTO at Atulya Abhinav Tech Private Limited

One area for improvement is the CI/CD pipeline, which lacks a version control system similar to GitHub for easier deployment.

For more quotes and insights, download the Workato report

Senior Software Engineer at a tech vendor with 5,001-10,000 employees

Setup Cost

SSIS is economical with SQL Server licenses, offering favorable pricing and integration, though add-ons may increase costs.

Workato's enterprise pricing is based on usage with possible costs up to $130K annually, viewed as high but efficient.

Utilizing SSIS involves no extra charges beyond the SQL Server license.

Managing Partner at Dynamis Informatica

It was included in our licensing for SQL server, and our licensing for SQL server was extremely cheap, making it a very good price point for us.

For more quotes and insights, download the SSIS report

Manager, Data Operations at a manufacturing company with 5,001-10,000 employees

However, it could be a bit cheaper.

reviewer2318280

Tech Lead at a consultancy with 11-50 employees

Higher volume is less expensive, but in general, it is kind of pricey.

Amy Jorde

Principal Consultant at Grail Automation

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.

For more quotes and insights, download the Workato report

Senior Software Engineer at a tech vendor with 5,001-10,000 employees

Compared to other iPaaS solutions like Boomi, Workato’s pricing model charges per connection step, which increases the cost.

Sowmya Nagaraja

Technical Consultant at Intercede Solutions

Valuable Features

SSIS offers efficient, scalable ETL with seamless Microsoft integration, user-friendly interface, flexibility, and cost-effectiveness, enhancing data processes.

Workato offers user-friendly, no-code integration and automation, boosting business efficiency with pre-built connectors and flexible application connections.

I would rate it at a 10 as it is highly reliable; we have never had any problems with it.

Manager, Data Operations at a manufacturing company with 5,001-10,000 employees

One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.

For more quotes and insights, download the SSIS report

Managing Partner at Dynamis Informatica

SSAS is included in the base installation of SQL Server.

Sean Achim

Managing Director at Knights Innovation Support Centre

It allows app-to-app and real-time integrations, which significantly enhance process efficiency.

Pradeep Nunna

Integration and Solution Architect/AI Engineer (Boomi and Workday) at Tech Bridger

It comes with pre-built connectors, eliminating the need to write APIs.

For more quotes and insights, download the Workato report

Senior Software Engineer at a tech vendor with 5,001-10,000 employees

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.

Sowmya Nagaraja

Technical Consultant at Intercede Solutions

Categories and Ranking

SSIS

Average Rating

7.6

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

Data Integration (1st)

Workato

Average Rating

8.2

Reviews Sentiment

5.9

Number of Reviews

Ranking in other categories

Integration Platform as a Service (iPaaS) (5th)

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

Data Integration Market Share Distribution
Product	Market Share (%)
SSIS	3.7%
Informatica Intelligent Data Management Cloud (IDMC)	3.5%
Informatica PowerCenter	3.4%
Other	89.4%

Data Integration

Integration Platform as a Service (iPaaS) Market Share Distribution
Product	Market Share (%)
Workato	4.8%
Boomi iPaaS	8.3%
MuleSoft Anypoint Platform	6.8%
Other	80.1%

Integration Platform as a Service (iPaaS)

Featured Reviews

User-friendly interface facilitates efficient data migration and reduces operational overhead

Manager, Data Operations at a manufacturing company with 5,001-10,000 employees

Its usability and ease of use are standout features. It is really easy to use - almost too easy at times. Users don't have to be experts to use their tool set and utilize the clicking mechanisms, drop down boxes, and other features to build a package and run it. The configuration is very easy and the system is very stable. I would rate it at a 10 as it is highly reliable; we have never had any problems with it. Very little maintenance is required on my side. While you need to keep the product up to date, the maintenance requirements are minimal. SSIS integrates with all Microsoft tools seamlessly. We have used it against Oracle, DB2 and SQL. It integrates and can move data around from any data platforms, making it very diverse in that standpoint. It is a very robust tool that can work with many data sources, and its main strength is that it is extremely easy to use.

Read full review

Shubhra Shrivastava

API Integration Architect, Sr Manager at Beauty Tech Retail Domain

Intuitive automation streamlines workflows with room for more deployment options

The best features I appreciate about Workato are how intuitive it is, its low-code, no-code feature, and its true cloud-native environment where we don't need to worry about infrastructure settings and fine-tuning. Though I find the task-based usage in Workato challenging, requiring careful workflow design. The benefits from using Workato include automating workflows using the low-code approach, demonstrating while creating workflows, and making changes on the go. These capabilities enable faster delivery compared to our earlier work environments when using hybrid integration platform or MuleSoft. The delivery time has drastically improved using Workato because of its low-code feature and pre-built connectors which are very easy to use compared to MuleSoft. The ease of deployment is a distinct feature when compared to Tipco, MuleSoft, or any other integration tool. The delivery time is drastically reduced, allowing changes to be made immediately and demonstrated.

Read full review

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

881,707 professionals have used our research since 2012.

Comparison Review

it_user90069

BI Expert at a healthcare company with 1,001-5,000 employees

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

16%

Computer Software Company

Government

Manufacturing Company

Computer Software Company

12%

Financial Services Firm

10%

Retailer

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	27
Midsize Enterprise	19
Large Enterprise	57

By reviewers
Company Size	Count
Small Business	7
Midsize Enterprise	6
Large Enterprise	7

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?

Pricing is pretty reasonable, so I would rate it at a 5. However, it could be a bit cheaper.

What needs improvement with Workato?

In Workato, there are some limitations regarding very high transactional data in file formats. For instance, we have a 90-minute job timeout, and queues larger than 10,000 size will be purged. Addi...

What is your primary use case for Workato?

The usual use cases for Workato include real-time data processing from either SFTP or SAS, and we have implemented multiple use cases for our clients in the past 3.5 years. For example, the employe...

What advice do you have for others considering Workato?

I have been working with clients for Workato implementation, focusing on consulting and implementing solutions for their business needs. We automate basic workflows and handle various complexities ...

Informatica PowerCenter vs SSIS

Comparisons

Compared 7% of the time

dbt vs SSIS

Compared 6% of the time

Skyvia vs SSIS

Compared 6% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 4% of the time

AWS Glue vs SSIS

Compared 4% of the time

More SSIS Competitors

Microsoft Azure Logic Apps vs Workato

Compared 10% of the time

Boomi iPaaS vs Workato

Compared 9% of the time

UnifyApps vs Workato

Compared 8% of the time

MuleSoft Anypoint Platform vs Workato

Compared 5% of the time

Zapier vs Workato

Compared 5% of the time

More Workato Competitors

Product Reports

Download SSIS product report

SSIS

January 2026

Download Workato product report

January 2026

Also Known As

SQL Server Integration Services

No data available

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.

Microsoft

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