Try our new research platform with insights from 80,000+ expert users

SSIS vs SnapLogic comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Customer Service

Sentiment score
8.5
SnapLogic's customer service is seen as responsive by some, but others report delays and insufficient support knowledge.
No sentiment score available
 

Room For Improvement

Sentiment score
6.2
SnapLogic needs improvements in complex processing, data flow transparency, API monitoring, user dashboards, support, debugging, and high-volume data handling.
No sentiment score available
 

Scalability Issues

Sentiment score
8.0
SnapLogic is praised for cloud scalability, user-friendly setup, and flexible resource allocation, though some face initial setup challenges.
No sentiment score available
 

Setup Cost

Sentiment score
6.5
SnapLogic offers reasonable, consumption-based pricing that remains affordable despite recent increases, especially compared to competitors.
No sentiment score available
 

Stability Issues

Sentiment score
7.5
SnapLogic is generally stable with minimal bugs and downtime, though some users experience availability issues and job failures with large data.
No sentiment score available
 

Valuable Features

Sentiment score
8.8
SnapLogic provides an intuitive, hybrid deployment platform with low-code development, seamless app integration, high data transfer, and extensive API management.
No sentiment score available
 

Categories and Ranking

SnapLogic
Ranking in Data Integration
24th
Average Rating
7.8
Reviews Sentiment
7.7
Number of Reviews
22
Ranking in other categories
Process Automation (16th), Cloud Data Integration (13th), Integration Platform as a Service (iPaaS) (10th)
SSIS
Ranking in Data Integration
4th
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
71
Ranking in other categories
No ranking in other categories
 

Q&A Highlights

Jul 16, 2017
 

Featured Reviews

Selva Dhoom - PeerSpot reviewer
Automates manual activities and has helpful documentation that allows users to self-study
What could be improved in SnapLogic is that it was not capable in terms of processing a large number of datasets, but at that point, SnapLogic was evolving. It didn't give a lot of Snaps. I heard recently there are a lot of Snaps getting added and the solution was being enhanced, particularly to connect different data sources. When I was working with SnapLogic six months to one year back, I faced the issue of it not being capable of handling a huge volume of datasets or didn't have much of Snaps, and that was the drawback. If there is any large number of data sets, that's based on or depends on your configuration. If it is a huge volume of data, other traditional ETL tools such as Informatica and Talend can process millions and billions of records, while in SnapLogic, the Snaplex fails or it returns an error in terms of processing that huge volume of data. Informatica, Talend, or any other ETL tool can run for hours in terms of jobs, while SnapLogic jobs fail when the threshold is reached. SnapLogic isn't able to withstand processing, but I don't know if that's still an issue at present, because the solution is getting enhanced and it's been more than six months to one year since I last worked with SnapLogic. There are now a lot of Snaps getting added to the solution, and if it can overcome the limitations I mentioned, SnapLogic could be the go-to tool because currently, it's not being used as much in organizations. It's being used comparatively less compared to other retail tools.
Sakiru Dosumu - PeerSpot reviewer
Its ability to transform and transport data is extremely valuable
he ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Answers from the Community

Jul 16, 2017
Jul 16, 2017
S3 copy is the best solution to load data into Redshift. I have used Informatica to move data from On premise to S3 and used S3 Copy to load Redshift.
2 out of 14 answers
it_user130794 - PeerSpot reviewer
Jul 13, 2017
Matillion or SAP BODS can be used as etl.
Jul 13, 2017
Informatica is good to go with Redshit, however any open source ETL is good enough. Thanks
 

Top Industries

By visitors reading reviews
Financial Services Firm
25%
Manufacturing Company
11%
Computer Software Company
9%
Real Estate/Law Firm
5%
Financial Services Firm
17%
Computer Software Company
12%
Government
8%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about SnapLogic?
Despite having no prior experience in SnapLogic, we managed to build, test, and prepare it for release in just three hours, handling heavy data efficiently.
What needs improvement with SnapLogic?
The biggest issue we have faced in our company with SnapLogic is regarding the EDI format. For instance, suppose if 20 EDIs are shortlisted then SnapLogic will convert and provide only those specif...
What is your primary use case for SnapLogic?
In our company, we used the solution to build a SnapLogic pipeline in a non-production environment. Presently, our company is releasing it to the production environment. We have used SnapLogic in o...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
What do you like most about SSIS?
The product's deployment phase is easy.
 

Comparisons

 

Also Known As

DataFlow
SQL Server Integration Services
 

Overview

 

Sample Customers

Adobe, ADP, BlackBerry, Bonobos, Box, Capital One, Dannon, Eero, Endo, Gensler, HCL, HP, Grovo, HIS, iRobot, Leica, Merck, Sans, Target, Verizon, Vodafone, Yelp, Yahoo!
1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
Find out what your peers are saying about SSIS vs. SnapLogic and other solutions. Updated: November 2024.
816,406 professionals have used our research since 2012.