Actian Pervasive Data Integrator [EOL] vs StreamSets comparison

Actian and IBM are both solutions in the Data Integration category. Additionally, 50% of Actian users are willing to recommend the solution, compared to 100% of IBM users who would recommend it.

Actian Pervasive Data Integ...

Read 6 Actian Pervasive Data Integrator [EOL] reviews

50% willing to recommend

StreamSets

Read 21 StreamSets reviews

4,142 Views
3,189 Comparison Views

100% willing to recommend

Actian Pervasive Data Integ...

StreamSets

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Actian Pervasive Data Integrator [EOL] and StreamSets based on real PeerSpot user reviews.

Find out what your peers are saying about Informatica, Microsoft, Palantir and others in Data Integration.

To learn more, read our detailed Data Integration Report (Updated: July 2026).

Buyer's Guide

Data Integration

July 2026

Download the complete report

Helped 908,800 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

Actian Pervasive Data Integ...

Average Rating

5.8

Number of Reviews

Ranking in other categories

No ranking in other categories

StreamSets

Average Rating

8.4

Reviews Sentiment

7.0

Number of Reviews

Ranking in other categories

Data Integration (24th)

Featured Reviews

BI Shnu Bhatta

Associate Manager at a tech services company with 10,001+ employees

It is stable and we did not have any issues with initial setup. I am not sure if there are various connectors available in the recent version to support the wide range of sources available.

I am not sure if there are various connectors available in the recent version of Pervasive DI to support the wide range of sources available (e.g., big data, cloud, EME) I have been using it for 6-7 months. There were no concerns with the stability. This product is very good from a stability…

Read full review

SrinivasanSankar

Enterprise Solutions Architect at a energy/utilities company with 1,001-5,000 employees

Enables effective batch loading with visual interface and enterprise support

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. I had to switch to a new EC2 box, even though the processor was not fully utilized. It would be beneficial if StreamSets addressed any potential memory leak issues to prevent unnecessary upgrades. Additionally, it would be a great enhancement if StreamSets could produce a lineage graph to visualize how the data has passed through the system.

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

"There were no concerns with the stability. This product is very good from a stability perspective."

"For data transfers and ETLs on Windows, this is a great product."

"This product is extremely useful and better than building an in-house solution."

"We have been using it for ETL, it is very robust and easy to use."

"Web based interface."

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

"It has helped us in moving into the data analytics world at a faster pace than any other tool would have done."

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

"StreamSets has definitely helped us in getting the information into our data lake very quickly, in terms of ingestion, and the most important thing is it has helped us from a resourcing point of view because you can easily upskill a BI or ETL resource without any programming knowledge to work with this, which has drastically reduced the time that we are spending on workloads by 60% to 70% as well as reducing the time spent on ingestion by 30%."

"I really appreciate the numerous ready connectors available on both the source and target sides, the support for various media file formats, and the ease of configuring and managing pipelines centrally."

"StreamSets is the leader in the market."

"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 most valuable would be the GUI platform that I saw. I first saw it at a special session that StreamSets provided towards the end of the summer. I saw the way you set it up and how you have different processes going on with your data. The design experience seemed to be pretty straightforward to me in terms of how you drag and drop these nodes and connect them with arrows."

More StreamSets pros

Cons

"The areas which I think need to be improved are the transform and load steps."

"At the moment, we can't even use it for 1, since it keeps failing in our QA testing."

"Technical support is an area which can definitely improve."

"I am not sure if there are various connectors available in the recent version of Pervasive DI to support the wide range of sources available (e.g., big data, cloud, EME)."

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

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

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

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

"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 was painful. Also, pipeline failures were common, and data drifting wasn't addressed, which made things worse. Licensing was another issue we encountered."

"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 are a few things that can be better."

More StreamSets cons

Pricing and Cost Advice

Information not available

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

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

"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 pricing is affordable for any business."

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

"I believe the pricing is not equitable."

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

"StreamSets is an expensive solution."

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

908,800 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

No data available

Financial Services Firm

12%

Comms Service Provider

Manufacturing Company

Construction Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	3
Large Enterprise	4

By reviewers
Company Size	Count
Small Business	9
Midsize Enterprise	2
Large Enterprise	11

Questions from the Community

Ask a question

Earn 20 points

What needs improvement with StreamSets?

See all answers

What is your primary use case for StreamSets?

We are using StreamSets for batch loading.

See all answers

What advice do you have for others considering StreamSets?

If asked, I definitely recommend StreamSets to other users. My overall rating for the solution is nine.

See all answers

Comparisons

Oracle Data Integrator (ODI) vs Actian Pervasive Data Integrator [EOL]

Compared 14% of the time

Informatica PowerCenter vs Actian Pervasive Data Integrator [EOL]

Compared 10% of the time

SSIS vs Actian Pervasive Data Integrator [EOL]

Compared 8% of the time

MuleSoft Anypoint Platform vs Actian Pervasive Data Integrator [EOL]

Compared 6% of the time

Ignite ETI vs Actian Pervasive Data Integrator [EOL]

Compared 2% of the time

More Actian Pervasive Data Integrator [EOL] Competitors

Pentaho Data Integration and Analytics vs StreamSets

Compared 9% of the time

Informatica PowerCenter vs StreamSets

Compared 6% of the time

SSIS vs StreamSets

Compared 5% of the time

Confluent vs StreamSets

Compared 5% of the time

Spring Cloud Data Flow vs StreamSets

Compared 5% of the time

More StreamSets Competitors

Product Reports

Buyer's Guide

Data Integration

July 2026

Actian Pervasive Data Integrator [EOL] report

Download Actian Pervasive Data Integrator [EOL] product report

Buyer's Guide

StreamSets

July 2026

Download StreamSets product report

Also Known As

Pervasive Data Integrator, PDI

No data available

Overview

Pervasive's Data Integrator platform is a robust enterprise data integration software solution that enables you to quickly build powerful and frictionless connections between any kind of data source and application.

Actian

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?

Data Collector: Enables streamlined data collection and processing.
Control Hub: Centralizes management of data pipelines.
Minimal Coding: Simplifies pipeline configuration with limited code requirement.
Data Drift Resilience: Adapts to changes in data patterns effectively.

What benefits should users look for?

Time-Saving: Efficient processes reduce manual effort.
Scalability: Easily manages large datasets.
Integration: Connects with leading analytics and cloud platforms.
Real-Time Processing: Supports continuous data delivery for timely insights.

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.

IBM

Sample Customers

Pediatrix Medical Group

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

Find out what your peers are saying about Informatica, Microsoft, Palantir and others in Data Integration. Updated: July 2026.

DOWNLOAD NOW

908,800 professionals have used our research since 2012.

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.