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 most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"The simplicity of the solution is great. The solution also offers excellent integration."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The product's deployment phase is easy."
"The setup was easy. All Microsoft products are easy to set up."
"The solution is easy to use and developer friendly."
"SSIS' most valuable feature is its reporting services."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"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."
"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."
"The product's initial setup phase was very easy."
"Zapier luckily has a wide range of integrations, I would say."
"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 product's most valuable feature is automation."
"Webhooks are the most valuable feature of Zapier."
"The connection between Facebook lead forms and MailChimp integrations is the most valuable feature."
"We'd like them to develop data exploration more."
"The performance of SSIS could improve when comparing it to Oracle Database."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"I would like to see better integration with Power BI."
"Tuning using this solution requires extensive expertise to improve performance."
"We'd like more integration capabilities."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"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."
"My biggest concern with Zapier would be their pricing strategy."
"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."
"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."
"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."
"It could support various languages along with Python."
"There is room for improvement in the support. They are not responsive, and they don't take much time to get resolved."
"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."
SSIS is ranked 2nd in Data Integration with 69 reviews while Zapier is ranked 9th in Cloud Data Integration with 41 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 Matillion ETL. 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.