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

3,842 Views
2,920 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: June 2026).

Buyer's Guide

Data Integration

June 2026

Download the complete report

Helped 900,644 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 (22nd)

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

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

"Web based interface."

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

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

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

"This product was a lot easier to use than the one we had before it, and it took us half an hour and we were set up and running it the first time."

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

"The entire user interface is very simple and the simplicity of creating pipelines is something that I like very much about it. The design experience is very smooth."

"It is really easy to set up and the interface is easy to use."

"I have used Data Collector, Transformer, and Control Hub products from StreamSets. What I really like about these products is that they're very user-friendly. People who are not from a technological or core development background find it easy to get started and build data pipelines and connect to the databases. They would be comfortable like any technical person within a couple of weeks."

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

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

More StreamSets pros

Cons

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

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

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

"We've seen a couple of cases where it appears to have a memory leak or a similar problem."

"One thing that I would like to add is the ability to manually enter data. The way the solution currently works is we don't have the option to manually change the data at any point in time. Being able to do that will allow us to do everything that we want to do with our data. Sometimes, we need to manually manipulate the data to make it more accurate in case our prior bifurcation filters are not good. If we have the option to manually enter the data or make the exact iterations on the data set, that would be a good thing."

"I would like to see it integrate with other kinds of platforms, other than Java. We're going to have a lot of applications using .NET and other languages or frameworks. StreamSets is very helpful for the old Java platform but it's hard to integrate with the other platforms and frameworks."

"Visualization and monitoring need to be improved and refined."

"StreamSets should provide a mechanism to be able to perform data quality assessment when the data is being moved from one source to the target."

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

"If the data processing in StreamSets takes a long time as compared to the previous solution, then we will reconsider why we use StreamSets."

"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

Information not available

"I believe the pricing is not equitable."

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

"StreamSets is an expensive solution."

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

"It has a CPU core-based licensing, which works for us and is quite good."

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

"StreamSets Data Collector is open source. One can utilize the StreamSets Data Collector, but the Control Hub is the main repository where all the jobs are present. Everything happens in Control Hub."

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

900,644 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

No data available

Financial Services Firm

12%

Manufacturing Company

Insurance Company

Computer Software 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 15% of the time

Informatica PowerCenter vs Actian Pervasive Data Integrator [EOL]

Compared 11% 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

IBM B2B Integrator vs Actian Pervasive Data Integrator [EOL]

Compared 5% of the time

More Actian Pervasive Data Integrator [EOL] Competitors

Pentaho Data Integration and Analytics vs StreamSets

Compared 8% of the time

Informatica PowerCenter vs StreamSets

Compared 6% of the time

SSIS vs StreamSets

Compared 6% of the time

Confluent vs StreamSets

Compared 5% of the time

Oracle Data Integrator (ODI) vs StreamSets

Compared 4% of the time

More StreamSets Competitors

Product Reports

Buyer's Guide

Data Integration

June 2026

Actian Pervasive Data Integrator [EOL] report

Download Actian Pervasive Data Integrator [EOL] product report

Buyer's Guide

StreamSets

May 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: June 2026.

DOWNLOAD NOW

900,644 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.