SSIS vs Zapier comparison

Read 41 Zapier reviews

658 Views
462 Comparison Views

95% willing to recommend

SSIS

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between SSIS and Zapier based on real PeerSpot user reviews.

Find out in this report how the two Cloud 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. Zapier Report (Updated: April 2025).

SSIS vs. Zapier

Download the complete report

Helped 850,076 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:

Categories and Ranking

SSIS

Average Rating

7.6

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

Data Integration (4th)

Zapier

Average Rating

8.6

Reviews Sentiment

7.1

Number of Reviews

Ranking in other categories

Cloud Data Integration (10th)

Featured Reviews

BobAmy

Sr. Architect - Data warehousing & BI at Molina Healthcare, Inc.

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.

Read full review

FrankHo

Analyst at MSXI

Though the tool offers a visually appealing UI, it needs to improve its documentation

With Zapier, improvements are required in the areas of concerns like bugs, ease of use, and documentation. The product has many bugs, so users have to wait for a period ranging from five minutes to an hour to see where the Zap went. In Zapier, Zaps aren't very understandable owing to the way they work. As a user, you would think that in Zapier, a Zap works in a particular way once you set it up, but it won't happen. At times, some Zaps can interfere with each other, because of which there might be infinite loops that may occur, owing to which multiple Zaps continue to run or break down in general, after which nothing would run in your environment. You would not be notified about the breakdown of Zaps. The bugs in the product may be considered to understand or get an explanation of how Zaps works between software systems, so for something between Gmail and HubSpot, Zapier would explain through better documentation what would work and what wouldn't work. Maybe if Zapier had better functionality with Python or any other coding language in general, it would make the product a lot better.

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 most valuable feature of SSIS is that it can handle real complex transformations."

"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."

"SSIS' best feature is SFTP connectivity."

"SSIS integrates well with SQL servers and Microsoft products."

"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."

"It is easy to set up. The deployment is also very quick."

"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."

"The technical support is very good."

More SSIS pros

"Zapier luckily has a wide range of integrations, I would say."

"Zapier handles everything under the sun that you would think you need in automation. It is the most mature integration platform and service on the market."

"Zapier is user friendly and makes it easy to integrate different tools. It has a drag and drop functionality which makes it easy to connect environments."

"The connection between Facebook lead forms and MailChimp integrations is the most valuable feature."

"Zapier is a really good tool for connecting multiple different platforms and data sources. For example, with Quickbase, I can easily integrate data from other sources like AWS or task-tracking platforms such as ClickUp or Asana."

"The solution is a SaaS and does not require a complex setup."

"Zapier’s most valuable feature is its ability to interconnect applications or devices."

"The most valuable aspect of this solution is that it is very intuitive and has a very flat learning curve."

More Zapier pros

Cons

"We'd like more integration capabilities."

"We have a stability problem because when something works, it works one time. The next time, it doesn't work."

"This solution needs full support for real-time processing."

"There were some issues when we tried to connect it to data storage. It was a connection issue."

"The security could be improved, as it is more important in our context."

"We have issues with SSIS connectors while extracting data from Excel sources."

"Improvement as per customer requirements."

"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."

More SSIS cons

"There is room for improvement in the support. They are not responsive, and they don't take much time to get resolved."

"The pricing of the solution is quite expensive."

"It is not worth the money if you have a little bit of a technical mind...Zapier is not able to set up different modules. When automation doesn't work, it's not that easy to find why it didn't work."

"The user interface for Zapier could be improved. It also takes some time to sync the data between different environments."

"System-to-system is fine, but when it comes to system-to-user, where Zapier is helping to communicate to a user, that's a one-way communication. If that user has to perform some action on that notification, the action isn't handled by Zapier. So there's no way to orchestrate that and it's very cumbersome."

"Zapier needs more YouTube or video tutorials or more training for people. That would help a lot. In particular, Zapier should have documentation for every connector. Its documentation needs to be more detailed and visual."

"Zapier needs to improve in the same way most RPA solutions should, such as Robocorp, Make, or UiPath. They are not good at helping you find the connections that you need for the problem that you have. For example, if need something on Instagram. I'm going to have to do research for hours to be able to find the components or the app, which is going to do what I need it to do. It makes it difficult to use the system when you don't know what to use."

"My biggest concern with Zapier would be their pricing strategy."

More Zapier cons

Pricing and Cost Advice

"We purchased the standard edition of SQL Server and SSIS came with it free of charge."

"All of my clients have this product included as part of their Microsoft license."

"The solution is available at a lesser price than that of Informatica."

"This solution is included with the MSSQL server package."

"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."

"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."

"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."

"The solution comes free of cost."

More SSIS pricing and cost advice

"Zapier's price is good."

"The product is reasonably priced."

"The least expensive plan is $24 a month, and you can go all the way to $800 a month if you're a huge company using many tasks."

"It's very straightforward licensing. There's only one cost you have to pay, and if you want a relevant pricing plan, I think you have two or three different models or packages which include the number of notifications or Zaps, as they call it, that you can program."

"Per task, there is a monthly plan involving 15 euros...Also, in different forms, they just give you the ability to use different features. They charge 18.58 euros for the first standard plan, which includes 750 tasks. So, it is about 25 cents per task."

"Zapier is a paid service. Its license renews monthly, and Zapier will downgrade your subscription to the free version when your credit card doesn't have funds. That significantly impacts your service because everything halts completely. Zapier doesn't have any hidden costs."

"There is a free plan that is, of course, limited. However, it allows you to understand and check true scenarios for a while."

"Think your Zaps through to make sure you don't use more Zaps than you need."

More Zapier pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.

See recommendations

850,076 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

19%

Computer Software Company

12%

Government

Manufacturing Company

Computer Software Company

15%

Financial Services Firm

10%

University

Educational Organization

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 Zapier?

The product's most valuable feature is automation.

What is your experience regarding pricing and costs for Zapier?

The pricing is suitable. It's not cheap, but not expensive.

What needs improvement with Zapier?

The pricing could be a little cheaper.

Informatica PowerCenter vs SSIS

Comparisons

Compared 19% of the time

Talend Open Studio vs SSIS

Compared 12% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 7% of the time

dbt vs SSIS

Compared 6% of the time

More SSIS Competitors

Coefficient vs Zapier

Compared 22% of the time

Fivetran vs Zapier

Compared 14% of the time

SnapLogic vs Zapier

Compared 10% of the time

AWS Glue vs Zapier

Compared 10% of the time

Coupler.io vs Zapier

Compared 9% of the time

More Zapier Competitors

Product Reports

SSIS

Download SSIS product report

Download Zapier product report

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

Zapier is a tool for primarily non-technical users to connect together web apps.

An integration between two apps is called a Zap. A Zap is made up of a Trigger and one or more Actions or Searches.

Whenever the trigger happens in one app, Zapier will automatically perform the actions or searches in another app in order.

Zaps are very lightweight and easy to set up. Zaps do not import or export old data (they only operate on new items created after the Zap is enabled). Zaps are also not kept in sync ("two way syncing") after the Zap is triggered.

Zaps are deceivingly simple if you're used to dealing with complex and difficult integrations. Their simplicity is what enables anyone to create them.

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

BuzzFeed, Groupon, Spotify, Columbia University, FOX

SSIS vs. Zapier