SSIS vs SnapLogic comparison

Cancel
You must select at least 2 products to compare!
SnapLogic Logo
views| comparisons
Microsoft Logo
Read 66 SSIS reviews
19,950 views|16,201 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between SnapLogic and SSIS based on real PeerSpot user reviews.

Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed SSIS vs. SnapLogic Report (Updated: March 2024).
763,955 professionals have used our research since 2012.
Q&A Highlights
Question: Which ETL or Data Integration tool goes the best with Amazon Redshift?
Answer: 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.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"They are very good at building out new aspects according to customer requirements.""An important tool for building prototypes and MVPs than can seamlessly turn into production jobs""What I found most valuable in SnapLogic is the ETL feature, particularly the Transform Snap Pack, for example, any kind of reading or writing on Transform Snaps. Other than that, all the third-party connectivity tools such as the SAP Snap Pack, Salesforce Snap Pack, Workday Snap Pack, even the ServiceNow Snap Pack, I find all those are pretty useful in SnapLogic.""The solutions ability to connect "snaps" or components to the graphic user interface is very intuitive, prevents errors, and makes implementations easy.""I found SnapLogic valuable and what I found most valuable about it was its ETL feature. I also found its automation feature valuable. It can be used for automating manual activities. It can be used as a middleware for certain transactional data processing and minimal datasets and ETL activities.""The API architecture makes it easy for orchestration.""SnapLogic is a great platform for establishing integrations among various systems or patterns by using any kind of interface. If something is not supported by predefined snaps – snaps are connectors in SnapLogic – you can create them (custom snaps) or write a script.""The feature I found most valuable in SnapLogic is low-code development. Low-code development has been very useful for simple processes, which is required for business users such as extracting details from a file or getting things reported by calling your web service. Calling your web service also becomes easier with SnapLogic because of the snaps available, so if you have the documentation, you can call an API. You don't have to write all those clients to call an API, so that is another feature I found very easy in SnapLogic. Configuring and managing all the file systems also become very handy with the solution."

More SnapLogic Pros →

"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications.""The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline.""Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows.""SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together.""The interface is very user-friendly.""The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work.""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.""It is easy to set up the solution."

More SSIS Pros →

Cons
"SnapLogic should have some inbuilt protocol mechanism in order to speed up.""One area for improvement in SnapLogic is the transparency in the flow of data. It needs to have more transparency. Right now, users only have a preview option at the end of any job flow, so at the end of any Snap Pack, there is a data preview option that lets you review the data and see how it's moving. What would make the solution better is more debugging and more access to change data from the preview panel or more functionality in terms of the preview option.""They should expand in terms of features for SaaS-based market requirements in different sectors.""The support is the most important improvement they could make.""There is room for improvement with APM management and how task execution looks.""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.""It needs some more snaps. I would like to see some of the features be changed in some of the snaps.""I would like to see more performance-related dashboards, ones that display the cost of a pipeline, for instance. Also, it would be helpful to have management dashboards for overseeing pipelines and connections."

More SnapLogic Cons →

"Improving the login procedure would make our reporting easier on monitoring our ETL processes.""A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened.""There were some issues when we tried to connect it to data storage. It was a connection issue.""We've had issues in terms of the amount of data that is transferred when we are scheduling.""It needs more integration tools, so you can connect to different sources.""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.""SSIS sometimes hangs, and there are some problems with servers going down after they've been patched.""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."

More SSIS Cons →

Pricing and Cost Advice
  • "It is a higher initial cost than other easy-to-use integration apps."
  • "They have pricing/usage tiers that are easy to move up or down."
  • "SnapLogic is not expensive. It's reasonably priced."
  • "The cost with SnapLogic is an annual license and better than Informatica."
  • "By scaling the solution incrementally the cost is controlled and more beneficial to the client."
  • "The license model is based on consumption."
  • "I used the free trial."
  • "SnapLogic's price is high compared to the other tools available in the market."
  • More SnapLogic Pricing and Cost Advice →

  • "This solution has provided an inexpensive tool, and it is easy to find experienced developers."
  • "My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."
  • "This solution is included with the MSSQL server package."
  • "It would be beneficial if the solution had a less costly cloud offering."
  • "Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."
  • "We have an enterprise license for this solution."
  • "It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
  • "All of my clients have this product included as part of their Microsoft license."
  • More SSIS Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
    763,955 professionals have used our research since 2012.
    Answers from the Community
    Anonymous User
    it_user102573 - PeerSpot reviewerit_user102573 (Database Expert at a healthcare company)
    Vendor

    I've found Matillion to be very intuitive and easy to use...

    it_user603990 - PeerSpot reviewerit_user603990 (Works at a tech company with 51-200 employees)
    Vendor

    I wish I could answer that question, but my expertise is limited to SSIS only.

    As far as I know 'talend' could be a better choice compare to the other tools.

    it_user626979 - PeerSpot reviewerit_user626979 (Marketing and Business Development Manager at a tech services company with 51-200 employees)
    Consultant

    you can address your question to our SAP department solutions@jet-bi.com

    it_user414306 - PeerSpot reviewerit_user414306 (Cloud Architect at a tech company with 10,001+ employees)
    Vendor

    Informatica is the way forward

    it_user592836 - PeerSpot reviewerit_user592836 (Works at a tech services company with 10,001+ employees)
    Consultant

    it depends on the infrastructure you are using and what's the total cost of ownership being authorized for the implementation. You can see the "Data Integration" partners within AWS-Redshift in the below link-
    https://aws.amazon.com/redshift/partners/

    Informatica undoubtedly is one of the best in the list. It's a great ETL tool but surely expensive in License.

    Microsoft's SSIS is a light weight tool but not as robust as Informatica. Certain other software's like Talend and Matillion are also good. Talend has an open source option where developers can build their own APIs and then productionize those APIs and that's cost effective as well.

    it_user524709 - PeerSpot reviewerit_user524709 (Works)
    Vendor

    Traditionally SQL is a plus, automation is only by a ETL is smarter.

    it_user702450 - PeerSpot reviewerit_user702450 (Manager BI Development at a comms service provider with 1,001-5,000 employees)
    Real User

    Any ETL tool that moves data to it's own server for processing will add overhead and will not use Redshift's power ( more specifically parallelism). It is recommended to use standard SQL for data processing.

    Questions from the Community
    Top Answer:My company has a licensed version of SnapLogic, so we have to pay for the product when we use it in our organization. Pentaho and Talend are ETL tools that allow my company to migrate the data within… more »
    Top Answer:SnapLogic and Pentaho are tools I use collaboratively for data integration. I have good experience with Pentaho and SnapLogic for data migration from one database to another database. The main use… more »
    Top Answer: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… more »
    Top Answer:I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows.
    Top Answer:The pricing of SSIS is generally considered reasonable in comparison to other data integration tools in the market. In terms of licensing, I find Microsoft's pricing policy generally favorable… more »
    Ranking
    Unranked
    In Data Integration
    2nd
    out of 94 in Data Integration
    Views
    19,950
    Comparisons
    16,201
    Reviews
    33
    Average Words per Review
    471
    Rating
    7.7
    Comparisons
    Also Known As
    DataFlow
    SQL Server Integration Services
    Learn More
    Overview

    The SnapLogic Intelligent Integration Platform uses AI-powered workflows to automate all stages of IT integration projects – design, development, deployment, and maintenance – whether on-premises, in the cloud, or in hybrid environments. The platform’s easy-to-use, self-service interface enables both expert and citizen integrators to manage all application integration, data integration, API management, B2B integration, and data engineering projects on a single, scalable platform. With SnapLogic, organizations can connect all of their enterprise systems quickly and easily to automate business processes, accelerate analytics, and drive transformation.

    SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.

    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
    Top Industries
    REVIEWERS
    Retailer22%
    Transportation Company22%
    Manufacturing Company11%
    Pharma/Biotech Company11%
    VISITORS READING REVIEWS
    Financial Services Firm20%
    Computer Software Company12%
    Manufacturing Company11%
    Retailer5%
    REVIEWERS
    Financial Services Firm23%
    Healthcare Company8%
    Computer Software Company8%
    Manufacturing Company8%
    VISITORS READING REVIEWS
    Financial Services Firm17%
    Computer Software Company12%
    Government7%
    Healthcare Company6%
    Company Size
    REVIEWERS
    Small Business48%
    Midsize Enterprise14%
    Large Enterprise38%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise11%
    Large Enterprise75%
    REVIEWERS
    Small Business27%
    Midsize Enterprise18%
    Large Enterprise55%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    Buyer's Guide
    SSIS vs. SnapLogic
    March 2024
    Find out what your peers are saying about SSIS vs. SnapLogic and other solutions. Updated: March 2024.
    763,955 professionals have used our research since 2012.

    SnapLogic doesn't meet the minimum requirements to be ranked in Data Integration with 13 reviews while SSIS is ranked 2nd in Data Integration with 33 reviews. SnapLogic is rated 8.2, while SSIS is rated 7.6. The top reviewer of SnapLogic writes "Automates manual activities and has helpful documentation that allows users to self-study". On the other hand, the top reviewer of SSIS writes "SSIS 2016 - The good, the bad, and the ugly". SnapLogic is most compared with Azure Data Factory, IBM InfoSphere DataStage, AWS Glue, Informatica Cloud Data Integration and Matillion ETL, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, Oracle Data Integrator (ODI), IBM InfoSphere DataStage and Boomi AtomSphere Integration. See our SSIS vs. SnapLogic report.

    See our list of best Data Integration vendors and best Cloud Data Integration vendors.

    We monitor all 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.