SSIS vs StreamSets comparison

Microsoft and IBM are both solutions in the Data Integration category. Microsoft is ranked #4 with an average rating of 8.0, while IBM is ranked #9 with an average rating of 8.4. Microsoft holds a 8.6% mindshare in DI, compared to IBM’s 1.7% mindshare. Additionally, 80% of Microsoft users are willing to recommend the solution, compared to 100% of IBM users who would recommend it.

SSIS

Read 71 SSIS reviews

14,990 Views
12,034 Comparison Views

80% willing to recommend

StreamSets

Read 24 StreamSets reviews

3,109 Views
1,983 Comparison Views

100% willing to recommend

SSIS

StreamSets

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between SSIS and StreamSets 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. StreamSets Report (Updated: November 2024).

Buyer's Guide

SSIS vs. StreamSets

November 2024

Download the complete report

Helped 816,406 peers since 2012

Categories and Ranking

SSIS

Ranking in Data Integration

4th

Average Rating

7.8

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

No ranking in other categories

StreamSets

Ranking in Data Integration

9th

Average Rating

8.4

Reviews Sentiment

7.5

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of November 2024, in the Data Integration category, the mindshare of SSIS is 8.6%, down from 9.6% compared to the previous year. The mindshare of StreamSets is 1.7%, up from 1.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration

Featured Reviews

Sakiru Dosumu

Head, Development Chapter (DevOps) at First Bank of Nigeria Ltd.

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.

Read full review

Reyansh Kumar

Technical Specialist at Accenture

We no longer need to hire highly skilled data engineers to create and monitor data pipelines

The things I like about StreamSets are its * overall user interface * efficiency * product features, which are all good. Also, the scheduling within the data engineering pipeline is very much appreciated, and it has a wide range of connectors for connecting to any data sources like SQL Server, AWS, Azure, etc. We have used it with Kafka, Hadoop, and Azure Data Factory Datasets. Connecting to these systems with StreamSets is very easy. You just need to configure the data sources, the paths and their configurations, and you are ready to go. It is very efficient and very easy to use for ETL pipelines. It is a GUI-based interface in which you can easily create or design your own data pipelines with just a few clicks. As for moving data into modern analytics systems, we are using it with Microsoft Power BI, AWS, and some on-premises solutions, and it is very easy to get data from StreamSets into them. No hardcore coding or special technical expertise is required. It is also a no-code platform in which you can configure your data sources and data output for easy configuration of your data pipeline. This is a very important aspect because if a tool requires code development, we need to hire software developers to get the task done. By using StreamSets, it can be done with a few clicks.

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

"We like that this solution includes a developer edition, free of charge, to allow for training."

"The setup is straightforward. It's very easy to install."

"SSIS' best feature is SFTP connectivity."

"The most important features are it works well and provides self-service BI."

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

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

"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."

"The technical support is very good."

More SSIS pros

"The most valuable would be the GUI platform that I saw. I first saw it at a special session that StreamSets provided towards the end of the summer. I saw the way you set it up and how you have different processes going on with your data. The design experience seemed to be pretty straightforward to me in terms of how you drag and drop these nodes and connect them with arrows."

"I have used Data Collector, Transformer, and Control Hub products from StreamSets. What I really like about these products is that they're very user-friendly. People who are not from a technological or core development background find it easy to get started and build data pipelines and connect to the databases. They would be comfortable like any technical person within a couple of weeks."

"The UI is user-friendly, it doesn't require any technical know-how and we can navigate to social media or use it more easily."

"In StreamSets, everything is in one place."

"For me, the most valuable features in StreamSets have to be the Data Collector and Control Hub, but especially the Data Collector. That feature is very elegant and seamlessly works with numerous source systems."

"It is really easy to set up and the interface is easy to use."

"Important features include that it comprises lots of functionality to connect data from various sources through connector availability, scheduling pipelines at any time, and integration with third-party and security solutions for encryption."

"One of the things I like is the data pipelines. They have a very good design. Implementing pipelines is very straightforward. It doesn't require any technical skill."

More StreamSets pros

Cons

"Integration and the user interface are areas with certain shortcomings that require some improvements."

"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."

"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."

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

"I would like to see better integration with Power BI."

"Generic processes should be used instead of custom code for each table."

"We'd like more integration capabilities."

"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."

More SSIS cons

"One thing that I would like to add is the ability to manually enter data. The way the solution currently works is we don't have the option to manually change the data at any point in time. Being able to do that will allow us to do everything that we want to do with our data. Sometimes, we need to manually manipulate the data to make it more accurate in case our prior bifurcation filters are not good. If we have the option to manually enter the data or make the exact iterations on the data set, that would be a good thing."

"In terms of the product, I don't think there is any room for improvement because it is very good. One small area of improvement that is very much needed is on the knowledge base side. Sometimes, it is not very clear how to set up a certain process or a certain node for a person who's using the platform for the first time."

"Using ETL pipelines is a bit complicated and requires some technical aid."

"There aren't enough hands-on labs, and debugging is also an issue because it takes a lot of time. Logs are not that clear when you are debugging, and you can only select a single source for a pipeline."

"We've seen a couple of cases where it appears to have a memory leak or a similar problem."

"We create pipelines or jobs in StreamSets Control Hub. It is a great feature, but if there is a way to have a folder structure or organize the pipelines and jobs in Control Hub, it would be great. I submitted a ticket for this some time back."

"One area for improvement could be the cloud storage server speed, as we have faced some latency issues here and there."

"I would like to see further improvement in the UI. In addition, upgrades are not automatic and they should be automated. Currently, we have to manually upgrade versions."

More StreamSets cons

Pricing and Cost Advice

"SSIS is fairly well-priced - I would rate it at four out of five."

"SSIS is a cheaper option compared to the cost of other ETL tools."

"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."

"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."

"People have to opt for a perpetual-based licensing model."

"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."

"Our license with SSIS is annual."

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

More SSIS pricing and cost advice

"The licensing is expensive, and there are other costs involved too. I know from using the software that you have to buy new features whenever there are new updates, which I don't really like. But initially, it was very good."

"It has a CPU core-based licensing, which works for us and is quite good."

"The pricing is too fixed. It should be based on how much data you need to process. Some businesses are not so big that they process a lot of data."

"It's not expensive because you pay per month, and the tasks you can perform with it are huge. It's reliable and cost-effective."

"StreamSets is an expensive solution."

"I believe the pricing is not equitable."

"Its pricing is pretty much up to the mark. For smaller enterprises, it could be a big price to pay at the initial stage of operations, but the moment you have the Seed B or Seed C funding and you want to scale up your operations and aren't much worried about the funds, at that point in time, you would need a solution that could be scaled."

"StreamSets Data Collector is open source. One can utilize the StreamSets Data Collector, but the Control Hub is the main repository where all the jobs are present. Everything happens in Control Hub."

More StreamSets 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

816,406 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

Top Industries

By visitors reading reviews

Financial Services Firm

17%

Computer Software Company

12%

Government

Healthcare Company

Financial Services Firm

17%

Computer Software Company

13%

Manufacturing Company

Insurance Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

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?

The solution comes free of cost.

See all answers

What do you like most about StreamSets?

The best thing about StreamSets is its plugins, which are very useful and work well with almost every data source. It's also easy to use, especially if you're comfortable with SQL. You can customiz...

See all answers

What needs improvement with StreamSets?

We often faced problems, especially with SAP ERP. We struggled because many columns weren't integers or primary keys, which StreamSets couldn't handle. We had to restructure our data tables, which ...

See all answers

What is your primary use case for StreamSets?

StreamSets is used for data transformation rather than ETL processes. It focuses on transforming data directly from sources without handling the extraction part of the process. The transformed data...

See all answers

Comparisons

Informatica PowerCenter vs SSIS

Compared 24% of the time

Talend Open Studio vs SSIS

Compared 13% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 7% of the time

AWS Glue vs SSIS

Compared 5% of the time

More SSIS Competitors

Informatica PowerCenter vs StreamSets

Compared 13% of the time

IBM InfoSphere DataStage vs StreamSets

Compared 12% of the time

Fivetran vs StreamSets

Compared 10% of the time

webMethods.io vs StreamSets

Compared 9% of the time

Talend Open Studio vs StreamSets

Compared 5% of the time

More StreamSets Competitors

Product Reports

Buyer's Guide

SSIS

October 2024

Download SSIS product report

Buyer's Guide

StreamSets

October 2024

Download StreamSets product report

Also Known As

SQL Server Integration Services

No data available

Learn More

Microsoft

Video not available

IBM

Overview

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.

StreamSets is a data integration platform that enables organizations to efficiently move and process data across various systems. It offers a user-friendly interface for designing, deploying, and managing data pipelines, allowing users to easily connect to various data sources and destinations. StreamSets also provides real-time monitoring and alerting capabilities, ensuring that data is flowing smoothly and any issues are quickly addressed.

Sample Customers

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

Availity, BT Group, Humana, Deluxe, GSK, RingCentral, IBM, Shell, SamTrans, State of Ohio, TalentFulfilled, TechBridge

Buyer's Guide

SSIS vs. StreamSets

November 2024

Free Report: SSIS vs. StreamSets

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

DOWNLOAD NOW

816,406 professionals have used our research since 2012.

See our SSIS vs. StreamSets report.

See our list of best 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.