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."It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"The simplicity of the solution is great. The solution also offers excellent integration."
"The product's deployment phase is easy."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"The interface is very user-friendly."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"StreamSets Transformer is a good feature because it helps you when you are developing applications and when you don't want to write a lot of code. That is the best feature overall."
"The most valuable features are the option of integration with a variety of protocols, languages, and origins."
"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."
"It is really easy to set up and the interface is easy to use."
"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."
"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."
"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."
"StreamSets data drift feature gives us an alert upfront so we know that the data can be ingested. Whatever the schema or data type changes, it lands automatically into the data lake without any intervention from us, but then that information is crucial to fix for downstream pipelines, which process the data into models, like Tableau and Power BI models. This is actually very useful for us. We are already seeing benefits. Our pipelines used to break when there were data drift changes, then we needed to spend about a week fixing it. Right now, we are saving one to two weeks. Though, it depends on the complexity of the pipeline, we are definitely seeing a lot of time being saved."
"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."
"Options for scaling could be improved."
"Generic processes should be used instead of custom code for each table."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"I would like to see better technical documentation because many times information is missing."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"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."
"The software is very good overall. Areas for improvement are the error logging and the version history. I would like to see better, more detailed error logging information."
"Using ETL pipelines is a bit complicated and requires some technical aid."
"If you use JDBC Lookup, for example, it generally takes a long time to process data."
"Visualization and monitoring need to be improved and refined."
"Currently, we can only use the query to read data from SAP HANA. What we would like to see, as soon as possible, is the ability to read from multiple tables from SAP HANA. That would be a really good thing that we could use immediately. For example, if you have 100 tables in SQL Server or Oracle, then you could just point it to the schema or the 100 tables and ingestion information. However, you can't do that in SAP HANA since StreamSets currently is lacking in this. They do not have a multi-table feature for SAP HANA. Therefore, a multi-table origin for SAP HANA would be helpful."
"StreamSet works great for batch processing but we are looking for something that is more real-time. We need latency in numbers below milliseconds."
"One area for improvement could be the cloud storage server speed, as we have faced some latency issues here and there."
SSIS is ranked 2nd in Data Integration with 69 reviews while StreamSets is ranked 8th in Data Integration with 24 reviews. SSIS is rated 7.6, while StreamSets is rated 8.4. The top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". On the other hand, the top reviewer of StreamSets writes "We no longer need to hire highly skilled data engineers to create and monitor data pipelines". SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue, whereas StreamSets is most compared with Fivetran, Informatica PowerCenter, Azure Data Factory, IBM InfoSphere DataStage and webMethods.io Integration. 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.