SSIS vs SnapLogic comparison

SnapLogic

Read 22 SnapLogic reviews

3,280 Views
2,102 Comparison Views

86% willing to recommend

SSIS

Read 69 SSIS reviews

18,509 Views
15,010 Comparison Views

79% willing to recommend

SnapLogic

SSIS

Comparison Buyer's Guide

Download the report

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: May 2024).

Buyer's Guide

SSIS vs. SnapLogic

May 2024

Download the complete report

Helped 787,061 peers since 2012

Categories and Ranking

SnapLogic

Ranking in Data Integration

14th

Average Rating

7.8

Number of Reviews

Ranking in other categories

Process Automation (10th), Cloud Data Integration (7th), Integration Platform as a Service (iPaaS) (6th)

SSIS

Ranking in Data Integration

2nd

Average Rating

7.6

Number of Reviews

Ranking in other categories

No ranking in other categories

Market share comparison

As of June 2024, in the Data Integration category, the market share of SnapLogic is 1.6% and it increased by 28.4% compared to the previous year. The market share of SSIS is 9.8% and it decreased by 9.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration

Unique Categories:

Process Automation

0.2%

Cloud Data Integration

5.0%

No other categories found

Q&A Highlights

it_user698982

Works

Jul 16, 2017

Which ETL or Data Integration tool goes the best with Amazon Redshift?

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.

See all answers

Featured Reviews

Mithila JT

IT Engineer at a computer software company with 1-10 employees

Jan 30, 2023

Scalable, and stable, but lacks an inbuilt protocol mechanism

I was utilizing Azure Data Lake block storage as a data lake, and I was performing numerous source extractions from various sources and transferring them to the data lake The client has seen great benefits from this particular project and its use of the SnapLogic tool, which they plan to continue…

Read full review

Shubham-Agarwal

Manager - Projects at Cognizant

Mar 17, 2023

Maintaining the solution and contacting its support team is easy

We have a consolidated data warehouse. We use an SSIS tool as a pipeline to fetch the data from multiple sources such as Excel, CSV, Oracle database, or APIs. Further, we put the data into the SSIS database. We are using the solution for ETL purposes Previously, it took a lot of work to connect…

Read full review

Quotes from Members

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

Pros

"The vendor handles the maintenance of the solution"

"The solutions ability to connect "snaps" or components to the graphic user interface is very intuitive, prevents errors, and makes implementations easy."

"They are very good at building out new aspects according to customer requirements."

"The initial setup is very straightforward."

"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."

"It's more developer-friendly, and development can be done at a faster phase."

"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."

"It is a stable solution."

More SnapLogic pros

"The solution is stable."

"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."

"The most valuable feature of SSIS is that it can handle real complex transformations."

"The solution is easy to use and developer friendly."

"We can connect with multiple data sources easily using an external connector in SSIS."

"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."

"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."

"SSIS integrates well with SQL servers and Microsoft products."

More SSIS pros

Cons

"The solution isn't ideal for complex processing or logic. We use another solution for that."

"Connecting to data behind enterprise firewalls has been tricky."

"There is room for improvement with APM management and how task execution looks."

"SnapLogic doesn't provide any on-premises software, so users have only cloud-based software to use."

"The problem is that SnapLogic doesn't offer a wide variety of connectors. For example, integrating with Salesforce is not that easy."

"I am looking for more scheduling options. When it comes to scheduling, there are different tools in the market."

"The biggest issue we have faced in our company with SnapLogic is regarding the EDI format"

"I don't think the support has better knowledge about technologies and tool support. There were lots of times when we had an issue, and it took me quite a long time to explain the problem. I feel like some of the support staff don't know their product well."

More SnapLogic cons

"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."

"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."

"I would like to see better technical documentation because many times information is missing."

"This solution needs full support for real-time processing."

"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."

"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."

"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."

"We have a stability problem because when something works, it works one time. The next time, it doesn't work."

More SSIS cons

Pricing and Cost Advice

"When comparing it with solutions like Apigee or MuleSoft, it still offers better value."

"SnapLogic's price is high compared to the other tools available in the market."

"They have pricing/usage tiers that are easy to move up or down."

"It is a higher initial cost than other easy-to-use integration apps."

"I used the free trial."

"From the ROI perspective, the price is extremely high"

"The cost with SnapLogic is an annual license and better than Informatica."

"The pricing is okay."

More SnapLogic pricing and cost advice

"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."

"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."

"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."

"This solution is included with the MSSQL server package."

"It would be beneficial if the solution had a less costly cloud offering."

"We purchased the standard edition of SQL Server and SSIS came with it free of charge."

"We have an enterprise license for this solution."

"SSIS' licensing is a little high, but it gives good value for money."

More SSIS pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

787,061 professionals have used our research since 2012.

Comparison Review

it_user90069

BI Expert at a healthcare company with 1,001-5,000 employees

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…

Read full review

Answers from the Community

it_user698982

Works

Jul 16, 2017

Which ETL or Data Integration tool goes the best with Amazon Redshift?

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

Consultant at a tech services company with 1,001-5,000 employees

Jul 13, 2017

Matillion or SAP BODS can be used as etl.

Read full answer

it_user524709

Works

Jul 13, 2017

Informatica is good to go with Redshit, however any open source ETL is good enough. Thanks

Read full answer

See all 14 answers

Top Industries

By visitors reading reviews

Financial Services Firm

21%

Manufacturing Company

11%

Computer Software Company

11%

Retailer

Financial Services Firm

18%

Computer Software Company

12%

Government

Healthcare Company

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.

See all answers

What needs improvement with SnapLogic?

The problem is that SnapLogic doesn't offer a wide variety of connectors. For example, integrating with Salesforce is not that easy, unlike with MuleSoft, which is much easier and also provides a d...

See all answers

What is your primary use case for SnapLogic?

I work as a solution architect, mainly focusing on integrating new software entities. Due to a client's needs to evaluate products, SnapLogic was considered, and we conducted some Proof of Concepts...

See all answers

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...

See all answers

What do you like most about SSIS?

The product's deployment phase is easy.

See all answers

What is your experience regarding pricing and costs for SSIS?

If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive.

See all answers

Comparisons

IBM InfoSphere DataStage vs SnapLogic

Compared 13% of the time

AWS Glue vs SnapLogic

Compared 12% of the time

Azure Data Factory vs SnapLogic

Compared 11% of the time

Informatica Cloud Data Integration vs SnapLogic

Compared 7% of the time

Alteryx Designer vs SnapLogic

Compared 5% of the time

More SnapLogic Competitors

Informatica PowerCenter vs SSIS

Compared 23% of the time

Talend Open Studio vs SSIS

Compared 11% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 8% of the time

Qlik Replicate vs SSIS

Compared 2% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

SnapLogic

May 2024

Download SnapLogic product report

Buyer's Guide

SSIS

May 2024

Download SSIS product report

Also Known As

DataFlow

SQL Server Integration Services

Learn More

SnapLogic

Microsoft

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

Buyer's Guide

SSIS vs. SnapLogic

May 2024

Free Report: SSIS vs. SnapLogic

Find out what your peers are saying about SSIS vs. SnapLogic and other solutions. Updated: May 2024.

DOWNLOAD NOW

787,061 professionals have used our research since 2012.

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.