SSIS vs Zapier comparison

Read 41 Zapier reviews

1,104 Views
573 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: October 2024).

SSIS vs. Zapier

Download the complete report

Helped 814,649 peers since 2012

Categories and Ranking

SSIS

Average Rating

7.8

Number of Reviews

Ranking in other categories

Data Integration (4th)

Zapier

Average Rating

8.6

Number of Reviews

Ranking in other categories

Cloud Data Integration (9th)

Featured Reviews

Sakiru Dosumu

Head, Development Chapter (DevOps) at First Bank of Nigeria Ltd.

Mar 1, 2024

Its ability to transform and transport data is extremely valuable

We use SSIS for data extraction, transformation, and loading processes. This includes extracting data from various sources like Oracle and SQL Server, and then transforming it for use in reporting tools like Power BI dashboards. While we haven't directly migrated data between databases using SSIS…

Read full review

Dimitris Goudis

Airtable developer - Tableau analyst at Freelance

May 16, 2023

A tool for automation purposes requiring an easy initial setup while offering a very helpful technical support team

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. So, it's not about the automation process but the triggers that trigger an automation to start running. Sometimes if you set up an automation trigger on a specific application, we wouldn't know if Zapier received data to start running. So we cannot understand whether the problem is in Zapier or the steps before. Branching scenarios is something I want to add to the solution to make my life easier. We want to apply a logical workflow with a yes or no condition. On Zapier, you can have a condition, but you can build the actions after one value on this condition. So, the question can be responded to with a yes-no option or not answered. In your scenario, you have only the actions after yes get chosen. A second scenario is needed for the answer, no, and a third one for not answered. While in Make, we create a diagram, according to which if the response is yes, then do follow this path, and if it's no, then follow another path.

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 technical support is very good."

"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."

"The script component is very powerful, things that you cannot normally do, is feasible through C#."

"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."

"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."

"SSIS is easy to use."

"The data reader is the most valuable feature."

"The interface is very user-friendly."

More SSIS pros

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

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

"The most valuable feature of Zapier is it saves me time doing repetitive tasks."

"What's most valuable in Zapier is its simplicity, seamlessness, and smooth plug-in, so you won't need to build code for every action. I'm not a developer, but I can use Zapier."

"There are a few valuable features, like the stability that it comes with and also the number of features that it offers. I've used other services like Pabbly, but they don't offer similar numbers of applications that Zapier has or allows to integrate with – it's maximum."

"The ability to connect web applications to trigger actions in another app after having enriched, formatted, delayed, grouped, and filtered is really valuable for many businesses."

"The initial setup is pretty easy to do."

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

More Zapier pros

Cons

"Performance could be better."

"SSIS has room for improvement, mainly because the overall package can be buggy. It often locks up, requiring a restart, which is annoying. However, since it's free, we tolerate these performance issues. I'd like to see better debugging tools in future releases and improvements in API calls; It would be helpful if SSIS had a built-in API engine so we wouldn't have to rely solely on database connections."

"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."

"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."

"Generic processes should be used instead of custom code for each table."

"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."

"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."

"I would like to see more features in terms of the integration with Azure Data Factory."

More SSIS cons

"At the moment, they allow a limited number of apps. I look forward to getting more apps for each package."

"Zapier could be a little faster, but that might not be possible. I would encourage Zapier to make more API endpoints for each application"

"I would like to see them improve the Quickbase integration. Currently, it only allows triggering actions when records are added, but it would be more useful if we could also trigger actions when records are modified or deleted."

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

"Some recent changes to the solution have made it bulky and not as intuitive to use as it previously was."

"Being able to share Zaps and organize them with teammates would allow sharing and refining scenarios and even combining steps that require different people's credentials."

"The solution does not work properly when we apply filters and we get errors."

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

More Zapier cons

Pricing and Cost Advice

"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."

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

"It would be beneficial if the solution had a less costly cloud offering."

"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."

"Our license with SSIS is annual."

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

"People have to opt for a perpetual-based licensing model."

More SSIS pricing and cost advice

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

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

"It's very affordable."

"Zapier's price is good."

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

"The price of Zapier is approximately $75 monthly."

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

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

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

814,649 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

17%

Computer Software Company

12%

Government

Manufacturing Company

Computer Software Company

22%

University

Comms Service Provider

Financial Services Firm

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?

The solution comes free of cost.

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 24% of the time

Talend Open Studio vs SSIS

Compared 13% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 7% of the time

AWS Glue vs SSIS

Compared 5% of the time

More SSIS Competitors

Coefficient vs Zapier

Compared 24% of the time

AWS Glue vs Zapier

Compared 20% of the time

Alteryx Designer vs Zapier

Compared 14% of the time

MuleSoft Composer vs Zapier

Compared 11% of the time

Tray.io vs Zapier

Compared 6% 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

Learn More

Microsoft

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.

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