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

5,056 Views
3,893 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: October 2026).

Buyer's Guide

Data Integration

October 2026

Download the complete report

Helped 921,523 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 (30th)

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

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

"Web based interface."

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

"In StreamSets, everything is in one place."

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

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

"StreamSets' reusable assets have helped to reduce workload by 32% to 40%."

"The ability to have a good bifurcation rate and fewer mistakes is valuable."

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

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

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

More StreamSets pros

Cons

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

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

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

"They need to improve their customer care services. Sometimes it has taken more than 48 hours to resolve an issue. That should be reduced. They are aware of small or generic issues, but not the more technical or deep issues. For those, they require some time, generally 48 to 72 hours to respond. That should be improved."

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

"Sometimes, it is not clear at first how to set up nodes. A site with an explanation of how each node works would be very helpful."

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

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

"There are a few things that can be better."

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

More StreamSets cons

Pricing and Cost Advice

Information not available

"StreamSets is an expensive solution."

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

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

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

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

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

921,523 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

No data available

Financial Services Firm

10%

Outsourcing Company

Comms Service Provider

Manufacturing 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

Informatica PowerCenter vs Actian Pervasive Data Integrator [EOL]

Compared 10% of the time

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

Compared 10% of the time

SSIS vs Actian Pervasive Data Integrator [EOL]

Compared 10% of the time

MuleSoft Anypoint Platform vs Actian Pervasive Data Integrator [EOL]

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

Oracle Data Integrator (ODI) vs StreamSets

Compared 4% of the time

More StreamSets Competitors

Product Reports

Buyer's Guide

Data Integration

October 2026

Actian Pervasive Data Integrator [EOL] report

Download Actian Pervasive Data Integrator [EOL] product report

Buyer's Guide

StreamSets

October 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: October 2026.

DOWNLOAD NOW

921,523 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.