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 initial setup of this solution is very straightforward."
"The solution is easy to use and developer friendly."
"The data reader is the most valuable feature."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"It's already very user-friendly and has a good dashboard."
"SSIS integrates well with SQL servers and Microsoft products."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"SSIS' best feature is SFTP connectivity."
"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."
"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."
"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."
"Webhooks are the most valuable feature of Zapier."
"The solution is a SaaS and does not require a complex setup."
"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."
"Zapier luckily has a wide range of integrations, I would say."
"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."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"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."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"The high prices attached to the product can be an area of concern where improvements are required."
"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."
"I think that this solution should have more apps connected to it."
"After mapping them out, and they'd worked for a while, I've had Zapier fail."
"Some recent changes to the solution have made it bulky and not as intuitive to use as it previously was."
"Some apps are not available yet. For instance, a connection with Joomla! would be great. In general, all the most-used apps are available, but I bumped into Joomla! with a client."
"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."
"The pricing of the solution is quite expensive."
"At the moment, they allow a limited number of apps. I look forward to getting more apps for each package."
"The solution does not work properly when we apply filters and we get errors."
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, Coefficient 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.