Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.
N/A
Striim
Score 8.3 out of 10
N/A
Striim is an enterprise-grade platform that offers continuous real-time data ingestion, high-speed in-flight stream processing, and sub-second delivery of data to cloud and on-premises endpoints.
$4,400
per month per 100 million Striim events
Pricing
SQL Server Integration Services
Striim
Editions & Modules
No answers on this topic
Striim Cloud Enterprise Platform
$4,400
per month per 100 million Striim events
Striim Platform
$20,000
per year per VCPU
Offerings
Pricing Offerings
SSIS
Striim
Free Trial
No
Yes
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
—
More Pricing Information
Community Pulse
SQL Server Integration Services
Striim
Features
SQL Server Integration Services
Striim
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
SQL Server Integration Services
6.0
54 Ratings
31% below category average
Striim
10.0
2 Ratings
20% above category average
Connect to traditional data sources
8.054 Ratings
10.02 Ratings
Connecto to Big Data and NoSQL
4.041 Ratings
10.01 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
SQL Server Integration Services
7.0
54 Ratings
14% below category average
Striim
8.9
2 Ratings
10% above category average
Simple transformations
10.054 Ratings
10.02 Ratings
Complex transformations
4.053 Ratings
7.82 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
SQL Server Integration Services
7.0
52 Ratings
11% below category average
Striim
8.5
2 Ratings
8% above category average
Data model creation
8.627 Ratings
8.42 Ratings
Metadata management
7.133 Ratings
8.42 Ratings
Business rules and workflow
5.043 Ratings
9.01 Ratings
Collaboration
8.039 Ratings
7.82 Ratings
Testing and debugging
6.049 Ratings
7.22 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Ideal if the company is already a Microsoft shop, so chances are that it is free with SQL Server. Also, good for moving data between on premise systems. Not ideal for moving data to the cloud. No functionality out of the box to work with REST APIs. Stable product but definitely not the future
Below samples are the well suited use cases; - Change data capture feature seamlessly works on popular RDMS. You can make enrichments on several data sources within the same Striim application. - You can install stand alone agents and start streaming log files to Striim servers. This is mainly useful for security operations or audit trail use cases.
Connection managers for online data sources can be tricky to configure.
Performance tuning is an art form and trialing different data flow task options can be cumbersome. SSIS can do a better job of providing performance data including historical for monitoring.
Mapping destination using OLE DB command is difficult as destination columns are unnamed.
Excel or flat file connections are limited by version and type.
Some features should be revised or improved, some tools (using it with Visual Studio) of the toolbox should be less schematic and somewhat more flexible. Using for example, the CSV data import is still very old-fashioned and if the data format changes it requires a bit of manual labor to accept the new data structure
SSIS is a great tool for most ETL needs. It has the 90% (or more) use cases covered and even in many of the use cases where it is not ideal SSIS can be extended via a .NET language to do the job well in a supportable way for almost any performance workload.
SQL Server Integration Services performance is dependent directly upon the resources provided to the system. In our environment, we allocated 6 nodes of 4 CPUs, 64GB each, running in parallel. Unfortunately, we had to ramp-up to such a robust environment to get the performance to where we needed it. Most of the reports are completed in a reasonable timeframe. However, in the case of slow running reports, it is often difficult if not impossible to cancel the report without killing the report instance or stopping the service.
The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.
The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools
I had nothing to do with the choice or install. I assume it was made because it's easy to integrate with our SQL Server environment and free. I'm not sure of any other enterprise level solution that would solve this problem, but I would likely have approached it with traditional scripting. Comparably free, but my own familiarity with trad scripts would be my final deciding factor. Perhaps with some further training on SSIS I would have a different answer.
