SAS Data Integration Server vs StreamSets comparison

SAS and IBM are both solutions in the Data Integration category. SAS is ranked #36 with an average rating of 7.5, while IBM is ranked #15 with an average rating of 8.4. SAS holds a 0.5% mindshare in DI, compared to IBM’s 1.6% mindshare. Additionally, 83% of SAS users are willing to recommend the solution, compared to 100% of IBM users who would recommend it.

SAS Data Integration Server

Read 4 SAS Data Integration Server reviews

629 Views
538 Comparison Views

83% willing to recommend

StreamSets

Read 21 StreamSets reviews

2,378 Views
1,645 Comparison Views

100% willing to recommend

SAS Data Integration Server

StreamSets

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 19, 2024

SAS Data Integration Server and StreamSets are competitors in the data integration domain. Users indicate higher satisfaction with StreamSets due to its adaptability and advanced data processing capabilities, giving it an edge over SAS's more traditional approach.

Features: SAS Data Integration Server offers robust ETL capabilities, integration with other SAS products, and provides a comprehensive suite for data management. StreamSets features real-time data pipeline architecture, an intuitive design, and simplifies complex data flows.

Ease of Deployment and Customer Service: SAS Data Integration Server has a well-documented but complex setup process that can be time-consuming, while StreamSets is known for straightforward deployment and proactive customer support, leading to faster implementation and troubleshooting.

Pricing and ROI: SAS Data Integration Server may involve significant costs due to its licensing model and initial implementation expenses, yet offers ROI through integration in SAS environments. StreamSets provides a cost-effective initial setup with scalable pricing, potentially leading to higher ROI for those prioritizing real-time data processing.

To learn more, read our detailed SAS Data Integration Server vs. StreamSets Report (Updated: April 2025).

Buyer's Guide

SAS Data Integration Server vs. StreamSets

April 2025

Download the complete report

Helped 847,772 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

SAS Data Integration Server

Ranking in Data Integration

36th

Average Rating

7.2

Reviews Sentiment

6.5

Number of Reviews

Ranking in other categories

No ranking in other categories

StreamSets

Ranking in Data Integration

15th

Average Rating

8.4

Reviews Sentiment

7.0

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of April 2025, in the Data Integration category, the mindshare of SAS Data Integration Server is 0.5%, up from 0.5% compared to the previous year. The mindshare of StreamSets is 1.6%, up from 1.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration

Featured Reviews

reviewer2937544

Works at a financial services firm with 5,001-10,000 employees

Offloads processes on the server side but needs better installation syntax

One area for improvement is the installation process. Another point could be the syntax, as it sometimes involves using syntax names that are not intuitive. For example, to calculate the difference between two dates, the general syntax in SAS is called the data difference or data net function. However, another name is used, such as NF and INK. Without knowledge of SAS programming, it becomes unclear what these functions mean. It is not good to define function names this way.

Read full review

Karthik Rajamani

Principal Engineer at Tata Consultancy Services

Integrates with different enterprise systems and enables us to easily build data pipelines without knowing how to code

There are a few things that can be better. 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. There are certain features that are only available at certain stages. For example, HTTP Client has some great features when it is used as a processor, but those features are not available in HTTP Client as a destination. There could be some improvements on the group side. Currently, if I want to know which users are a part of certain groups, it is not straightforward to see. You have to go to each and every user and check the groups he or she is a part of. They could improve it in that direction. Currently, we have to put in a manual effort. In case something goes wrong, we have to go to each and every user account to check whether he or she is a part of a certain group or not.

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

"A key feature allows us to enhance job performance by offloading processing to the server side, rather than processing on the server itself."

"The solution offers very good data manipulation and loading."

"The most valuable feature of the solution is its amazing capabilities in regard to data handling."

"The solution is very stable."

"A key feature allows us to enhance job performance by offloading processing to the server side, rather than processing on the server itself."

"StreamSets is the leader in the market."

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

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

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

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

"StreamSets’ data drift resilience has reduced the time it takes us to fix data drift breakages. For example, in our previous Hadoop scenario, when we were creating the Sqoop-based processes to move data from source to destinations, we were getting the job done. That took approximately an hour to an hour and a half when we did it with Hadoop. However, with the StreamSets, since it works on a data collector-based mechanism, it completes the same process in 15 minutes of time. Therefore, it has saved us around 45 minutes per data pipeline or table that we migrate. Thus, it reduced the data transfer, including the drift part, by 45 minutes."

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

"In StreamSets, everything is in one place."

More StreamSets pros

Cons

"One area for improvement is the installation process."

"The transform tool has limited access. They should make it more flexible."

"So I would like to see improved integration with other software."

"The initial setup had issues, and even after using it for about one year, it was still not fixed."

"The initial setup of SAS Data Integration Server was complex."

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

"One issue I observed with StreamSets is that the memory runs out quickly when processing large volumes of data. Because of this memory issue, we have to upgrade our EC2 boxes in the Amazon AWS infrastructure."

"StreamSet works great for batch processing but we are looking for something that is more real-time. We need latency in numbers below milliseconds."

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

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

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

"The design experience is the bane of our existence because their documentation is not the best. Even when they update their software, they don't publish the best information on how to update and change your pipeline configuration to make it conform to current best practices. We don't pay for the added support. We use the "freeware version." The user community, as well as the documentation they provide for the standard user, are difficult, at best."

"The execution engine could be improved. When I was at their session, they were using some obscure platform to run. There is a controller, which controls what happens on that, but you should be able to easily do this at any of the cloud services, such as Google Cloud. You shouldn't have any issues in terms of how to run it with their online development platform or design platform, basically their execution engine. There are issues with that."

More StreamSets cons

Pricing and Cost Advice

"It is an expensive program."

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

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

"The overall cost is very flexible so it is not a burden for our organization... However, the cost should be improved. For small and mid-size organizations it might be a challenge."

"I believe the pricing is not equitable."

"The pricing is affordable for any business."

"StreamSets is an expensive solution."

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

"There are two editions, Professional and Enterprise, and there is a free trial. We're using the Professional edition and it is competitively priced."

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

847,772 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

26%

Computer Software Company

13%

Government

12%

Insurance Company

Financial Services Firm

14%

Computer Software Company

11%

Manufacturing Company

Insurance Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

What do you like most about SAS Data Integration Server?

The most valuable feature of the solution is its amazing capabilities in regard to data handling.

See all answers

What is your experience regarding pricing and costs for SAS Data Integration Server?

I don't handle the cost and budget part. From the tool's perspective, I can say that it is an amazing product.

See all answers

What needs improvement with SAS Data Integration Server?

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

SSIS vs SAS Data Integration Server

Compared 28% of the time

Azure Data Factory vs SAS Data Integration Server

Compared 26% of the time

Oracle Data Integrator (ODI) vs SAS Data Integration Server

Compared 19% of the time

Palantir Foundry vs SAS Data Integration Server

Compared 14% of the time

AWS Glue vs SAS Data Integration Server

Compared 12% of the time

More SAS Data Integration Server Competitors

Informatica PowerCenter vs StreamSets

Compared 14% of the time

IBM InfoSphere DataStage vs StreamSets

Compared 12% of the time

webMethods.io vs StreamSets

Compared 9% of the time

Fivetran vs StreamSets

Compared 8% of the time

Azure Data Factory vs StreamSets

Compared 7% of the time

More StreamSets Competitors

Product Reports

Buyer's Guide

Data Integration

March 2025

Download SAS Data Integration Server product report

Buyer's Guide

StreamSets

March 2025

Download StreamSets product report

Also Known As

SAS Enterprise Data Integration Server, Enterprise Data Integration Server

No data available

Overview

SAS Data Integration Server is a powerful, configurable and comprehensive solution that can meet a wide variety of data integration requirements, from small tactical projects to strategic business initiatives. It can access virtually all data sources, support data warehousing, migration, synchronization, federation and provisioning initiatives. It can support both batch-oriented and real-time master data management solutions. It can create reusable data integration services in support of service-oriented architectures and data governance and extract, cleanse, transform, conform, aggregate, load and manage data.

SAS

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.

IBM

Sample Customers

Credit Guarantee Corporation, Cr_dito y Cauci‹n, Delaware State Police, Deutsche Lufthansa, Directorate of Economics and Statistics, DSM, Livzon Pharmaceutical Group, Los Angeles County, Miami Herald Media Company, Netherlands Enterprise Agency, New Zealand Ministry of Health, Nippon Paper, West Midlands Police, XS Inc., Zenith Insurance

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

Buyer's Guide

SAS Data Integration Server vs. StreamSets

April 2025

Free Report: SAS Data Integration Server vs. StreamSets

Find out what your peers are saying about SAS Data Integration Server vs. StreamSets and other solutions. Updated: April 2025.

DOWNLOAD NOW

847,772 professionals have used our research since 2012.

See our SAS Data Integration Server 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.