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 valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"SSIS' most valuable feature is its reporting services."
"It's saved time using visualization descriptions."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"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."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"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."
"We can connect Zapier with Zoho CRM for lead generation. I like the tool's drag and drop feature."
"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 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 product's initial setup phase was very easy."
"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."
"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."
"The solution is a SaaS and does not require a complex setup."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"The high prices attached to the product can be an area of concern where improvements are required."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"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."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"It could support various languages along with Python."
"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."
"There is room for improvement in the support. They are not responsive, and they don't take much time to get resolved."
"I think that this solution should have more apps connected to it."
"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."
"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."
"At the moment, they allow a limited number of apps. I look forward to getting more apps for each package."
SSIS is ranked 2nd in Data Integration with 69 reviews while Zapier is ranked 10th 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 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.