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."The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"The UI is very user-friendly."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"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."
"The initial setup was easy."
"It has good data integration and good processes."
"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."
"With the previous CRM we were using – the Google Ads landing pages we had – we were collecting leads manually. That process was not efficient and took a sales team a lot of time to insert these leads manually. Currently, the process is smooth and we use Zapier to collect the leads for us."
"The product's most valuable feature is automation."
"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."
"We find it effortless to set up. We really don't have to do anything other than finding the application in the Zapier catalog. And as long as the application has been re-integrated into Zapier, they're able to then just provide the connection details and hook it up."
"The most valuable aspect of this solution is that it is very intuitive and has a very flat learning curve."
"The most valuable feature of Zapier is it saves me time doing repetitive tasks."
"We can connect Zapier with Zoho CRM for lead generation. I like the tool's drag and drop feature."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"This solution needs full support for real-time processing."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"I would like to see better integration with Power BI."
"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."
"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."
"It could support various languages along with Python."
"At the moment, they allow a limited number of apps. I look forward to getting more apps for each package."
"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."
"The solution does not work properly when we apply filters and we get errors."
"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."
"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."
SSIS is ranked 2nd in Data Integration with 69 reviews while Zapier is ranked 10th in Cloud Data Integration with 40 reviews. SSIS is rated 7.6, while Zapier is rated 8.6. The top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". On the other hand, the top reviewer of Zapier writes "A tool for automation purposes requiring an easy initial setup while offering a very helpful technical support team ". SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue, whereas Zapier is most compared with AWS Glue, Alteryx Designer, Tray.io, MuleSoft Composer and Workato. See our SSIS vs. Zapier report.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud 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.