SSIS vs StreamSets comparison

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

SSIS

Read 72 SSIS reviews

14,200 Views
11,375 Comparison Views

79% willing to recommend

StreamSets

Read 22 StreamSets reviews

2,905 Views
1,916 Comparison Views

100% willing to recommend

SSIS

StreamSets

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 19, 2024

SSIS and StreamSets are leading competitors in the data integration and pipeline automation category. StreamSets has the advantage due to its comprehensive feature set and adaptability, outweighing SSIS's competitive pricing and support offerings.

Features:SSIS offers robust ETL capabilities, seamless integration within Microsoft environments, and exceptional support for SQL Server. StreamSets is distinguished by real-time streaming data processing, adaptive pipelines, and simplified management for complex data workflows.

Room for Improvement:SSIS could enhance its real-time data streaming and improve adaptability in dynamic environments. Integration with non-Microsoft services could use improvement. StreamSets might benefit from a reduction in its initial setup complexity, extended support for non-cloud deployments, and enhancements to its user interface for beginners.

Ease of Deployment and Customer Service:SSIS enjoys a straightforward deployment process within Windows environments and reliable Microsoft-related support. StreamSets offers impressive flexibility with its cloud-native deployment model and proficient customer service, notably for data streaming issues, offering a more comprehensive experience in cloud and hybrid systems.

Pricing and ROI:SSIS generally offers lower initial setup costs for businesses within the Microsoft ecosystem, enabling a quicker ROI. StreamSets requires higher upfront investment, potentially offering significant long-term value through advanced features and scalability, justifying the cost for enterprises needing flexible and real-time data processing.

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 824,067 peers since 2012

Categories and Ranking

SSIS

Ranking in Data Integration

4th

Average Rating

7.6

Reviews Sentiment

6.7

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

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of December 2024, in the Data Integration category, the mindshare of SSIS is 8.8%, down from 9.5% compared to the previous year. The mindshare of StreamSets is 1.8%, up from 1.4% 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

"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."

"SSIS' best feature is SFTP connectivity."

"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."

"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 features of SSIS are that it works with the query language and it can import data from different sources."

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

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

"The setup was easy. All Microsoft products are easy to set up."

More SSIS pros

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

"Also, the intuitive canvas for designing all the streams in the pipeline, along with the simplicity of the entire product are very big pluses for me. The software is very simple and straightforward. That is something that is needed right now."

"What I love the most is that StreamSets is very light. It's a containerized application. It's easy to use with Docker. If you are a large organization, it's very easy to use Kubernetes."

"The best feature that I really like is the integration."

"The Ease of configuration for pipes is amazing. It has a lot of connectors. Mainly, we can do everything with the data in the pipe. I really like the graphical interface too"

"The entire user interface is very simple and the simplicity of creating pipelines is something that I like very much about it. The design experience is very smooth."

"The ETL capabilities are very useful for us. We extract and transform data from multiple data sources, into a single, consistent data store, and then we put it in our systems. We typically use it to connect our Apache Kafka with data lakes. That process is smooth and saves us a lot of time in our production systems."

"It's very easy to integrate. It integrates with Snowflake, AWS, Google Cloud, and Azure. It's very helpful for DevOps, DataOps, and data engineering because it provides a comprehensive solution, and it's not complicated."

More StreamSets pros

Cons

"It would be nice if you could run SSIS on other environments besides Windows."

"The performance of this solution is not as good as other tools in the market."

"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."

"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."

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

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

"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."

"The performance of SSIS could improve when comparing it to Oracle Database."

More SSIS cons

"The data collector in StreamSets has to be designed properly. For example, a simple database configuration with MySQL DB requires the MySQL Connector to be installed."

"The documentation is inadequate and has room for improvement because the technical support does not regularly update their documentation or the knowledge base."

"The monitoring visualization is not that user-friendly. It should include other features to visualize things, like how many records were streamed from a source to a destination on a particular date."

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

"StreamSets should provide a mechanism to be able to perform data quality assessment when the data is being moved from one source to the target."

"I would like to see it integrate with other kinds of platforms, other than Java. We're going to have a lot of applications using .NET and other languages or frameworks. StreamSets is very helpful for the old Java platform but it's hard to integrate with the other platforms and frameworks."

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

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

More StreamSets cons

Pricing and Cost Advice

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

"Our license with SSIS is annual."

"All of my clients have this product included as part of their Microsoft license."

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

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

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

"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."

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

More SSIS pricing and cost advice

"We use the free version. It's great for a public, free release. Our stance is that the paid support model is too expensive to get into. They should honestly reevaluate that."

"The pricing is affordable for any business."

"StreamSets is an expensive solution."

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

"There are different versions of the product. One is the corporate license version, and the other one is the open-source or free version. I have been using the corporate license version, but they have recently launched a new open-source version so that anybody can create an account and use it. The licensing cost varies from customer to customer. I don't have a lot of input on that. It is taken care of by PMO, and they seem fine with its pricing model. It is being used enterprise-wide. They seem to have got a good deal for StreamSets."

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

"It's not so favorable for small companies."

"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

824,067 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

18%

Computer Software Company

12%

Government

Manufacturing Company

Financial Services Firm

17%

Computer Software Company

10%

Manufacturing Company

10%

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 23% of the time

Talend Open Studio vs SSIS

Compared 13% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 8% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

AWS Glue vs SSIS

Compared 4% of the time

More SSIS Competitors

Informatica PowerCenter vs StreamSets

Compared 13% of the time

IBM InfoSphere DataStage vs StreamSets

Compared 10% of the time

Fivetran vs StreamSets

Compared 10% of the time

webMethods.io vs StreamSets

Compared 8% of the time

Talend Open Studio vs StreamSets

Compared 5% of the time

More StreamSets Competitors

Product Reports

Buyer's Guide

SSIS

November 2024

Download SSIS product report

Buyer's Guide

StreamSets

November 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

824,067 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.