Actian Pervasive Data Integrator [EOL] vs StreamSets comparison

Why PeerSpot?

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,501 Views
3,466 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, Palantir, Microsoft and others in Data Integration.

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

Buyer's Guide

Data Integration

September 2026

Download the complete report

Helped 913,683 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

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

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

"Web based interface."

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

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

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

"StreamSets is the leader in the market."

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

"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 best feature that I really like is the integration."

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

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

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

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

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

"If you use JDBC Lookup, for example, it generally takes a long time to process data."

"The logging mechanism could be improved. If I am working on a pipeline, then create a job out of it and it is running, it will generate constant logs. So, the logging mechanism could be simplified. Now, it is a bit difficult to understand and filter the logs. It takes some time."

"In terms of the product, I don't think there is any room for improvement because it is very good. One small area of improvement that is very much needed is on the knowledge base side. Sometimes, it is not very clear how to set up a certain process or a certain node for a person who's using the platform for the first time."

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

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

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

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

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

More StreamSets cons

Pricing and Cost Advice

Information not available

"Its pricing is pretty much up to the mark. For smaller enterprises, it could be a big price to pay at the initial stage of operations, but the moment you have the Seed B or Seed C funding and you want to scale up your operations and aren't much worried about the funds, at that point in time, you would need a solution that could be scaled."

"I believe the pricing is not equitable."

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

"We are running the community version right now, which can be used free of charge."

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

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

"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

913,683 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

No data available

Financial Services Firm

11%

Outsourcing Company

Comms Service Provider

Healthcare 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 13% of the time

Informatica PowerCenter vs Actian Pervasive Data Integrator [EOL]

Compared 10% of the time

SSIS vs Actian Pervasive Data Integrator [EOL]

Compared 9% 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 9% of the time

Informatica PowerCenter vs StreamSets

Compared 6% of the time

SSIS vs StreamSets

Compared 6% of the time

Spring Cloud Data Flow vs StreamSets

Compared 5% of the time

Confluent vs StreamSets

Compared 4% of the time

More StreamSets Competitors

Product Reports

Buyer's Guide

Data Integration

September 2026

Actian Pervasive Data Integrator [EOL] report

Download Actian Pervasive Data Integrator [EOL] product report

Buyer's Guide

StreamSets

August 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, Palantir, Microsoft and others in Data Integration. Updated: September 2026.

DOWNLOAD NOW

913,683 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.