

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.
The tool has made us tremendously more efficient and saved us a significant amount of money.
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
The first line of support needs to be more knowledgeable.
IBM technical support sometimes transfers tickets between different teams due to shift changes, which can be frustrating.
I would rate the scalability of SSIS at a 7 because we are able to use various third-party items with it, allowing for functionality with a number of different things.
It processes large volumes of data quickly.
Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.
The logging capabilities could be improved, particularly for error logging.
SSIS could be integrated with more services, such as Power BI, to make the reporting structures more user-friendly.
It would be beneficial if StreamSets addressed any potential memory leak issues to prevent unnecessary upgrades.
However, it could be a bit cheaper.
It was included in our licensing for SQL server, and our licensing for SQL server was extremely cheap, making it a very good price point for us.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
It is a very robust tool that can work with many data sources, and its main strength is that it is extremely easy to use.
The main benefits SSIS provides for my company is to streamline processes.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
It allows a hybrid installation approach, rather than being completely cloud-based or on-premises.
| Product | Mindshare (%) |
|---|---|
| SSIS | 3.7% |
| StreamSets | 1.2% |
| Other | 95.1% |

| Company Size | Count |
|---|---|
| Small Business | 27 |
| Midsize Enterprise | 19 |
| Large Enterprise | 57 |
| Company Size | Count |
|---|---|
| Small Business | 9 |
| Midsize Enterprise | 2 |
| Large Enterprise | 11 |
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 streamlines data pipeline creation, connecting data from multiple sources to destinations like cloud platforms with minimal coding. Its centralized platform and intuitive design enhance ETL and data migration processes.
StreamSets integrates seamlessly with analytics platforms, offering tools such as Data Collector and Control Hub to facilitate data ingestion, transformation, and machine learning integrations. Its user-friendly interface and ready connectors aid in configuring complex data pipelines. With built-in data drift resilience and scheduling options, users experience efficient, scalable data management, despite challenges like latency in cloud storage and interface enhancement needs. Users often employ StreamSets for batch loading, real-time data processing, and smart data pipeline management, offering comprehensive data integration solutions.
What are the key features of StreamSets?In industries like finance and technology, StreamSets supports data migration, machine learning integrations, and analytics by simplifying data transformation and enhancing decision-making capabilities through its robust pipeline management.
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.