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 reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"It is easy to set up the solution."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"The performance and stability are good."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"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."
"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."
"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 most valuable feature of Zapier is it saves me time doing repetitive tasks."
"The product's most valuable feature is automation."
"Webhooks are the most valuable feature of Zapier."
"Zapier's interface, for me, is the solution's greatest value proposition. It is designed and developed for people who don't have a clue about what they're trying to do. It has a very user-friendly interface."
"We can connect Zapier with Zoho CRM for lead generation. I like the tool's drag and drop feature."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"Options for scaling could be improved."
"The solution could improve by having quicker release updates."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"The performance of SSIS could improve when comparing it to Oracle Database."
"The pricing of the solution is quite expensive."
"The user interface for Zapier could be improved. It also takes some time to sync the data between different environments."
"With Zapier, improvements are required in the areas of concerns like bugs, ease of use, and documentation."
"The solution does not work properly when we apply filters and we get errors."
"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."
"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."
"Some recent changes to the solution have made it bulky and not as intuitive to use as it previously was."
"Zapier could be a little faster, but that might not be possible. I would encourage Zapier to make more API endpoints for each application"
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.
