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

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

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

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

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

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

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

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

"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 customize it to do what you need. Many other tools have started to use features similar to those introduced by StreamSets, like automated workflows that are easy to set up."

More StreamSets pros

Cons

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

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

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

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

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

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

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

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

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

"The monitoring visualization is not that user-friendly. It should include other features to visualize things, like how many records were streamed from a source to a destination on a particular date."

More StreamSets cons

Pricing and Cost Advice

Information not available

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

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

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

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

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

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

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.