No more typing reviews! Try our Samantha, our new voice AI agent.

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

Why PeerSpot?
 

Comparison Buyer's Guide

Executive Summary

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
6
Ranking in other categories
No ranking in other categories
Oracle Data Integrator (ODI)
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
73
Ranking in other categories
Data Integration (12th)
 

Featured Reviews

BB
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…
Hafiz Mannan - PeerSpot reviewer
Head of Data Services – Services Partner at 3 As Technologies
Facilitates complex data integration with ease and flexibility
It would be great if ODI could link the designer, mapping, and workflows in a more simplified manner, maybe in one combined interface. It would be excellent not to have to go into different areas to perform different activities but rather have a user-defined interface where we can configure a job, run it, monitor it, link packages, and link subprocesses all in one frame instead of having the designer separately, mapping separately, and monitoring and session management separately. With respect to data quality challenges, it would be great to give an option to fix data quality issues based on AI. Integrating AI with ODI that provides recommendations on how to fix those data quality issues after analyzing and profiling business data would be excellent. One of the main disadvantages of the Oracle Data Integrator (ODI) is that it sometimes takes a lot of resources when handling multiple jobs. The scalability and the ability to handle multiple workloads of several parallel ETL jobs could use improvement, and certain parallel threads should be added along with the ability to configure multiple jobs from the same data directory structure.

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."
"It is a clever integration tool to extract data from every possible source, and it can transform the source data to a format the targets can handle."
"The main benefits that Oracle Data Integrator (ODI) brings to the table include data quality, data completeness functionality, metadata management, and the reverse engineering feature, which allows integrating the metadata of diversified data sources with a single click."
"It has streamlined and automated data loads, and exports from our ERP system to our finance data warehouse and to Hyperion Essbase."
"The ability to extract from multiple sources, the flexibility of using the Knowledge module, and the ergonomics of the GUI are the features I've found most valuable."
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"Oracle Data Integrator (ODI)'s ELT architecture has helped optimize my data movement and transformation significantly."
"It's scalable."
 

Cons

"At the moment, we can't even use it for 1, since it keeps failing in our QA testing."
"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."
"There could be better compatibility with other ETL tools and cloud platforms."
"First, it needs better error handling (i.e. messages, debugging). Second, it also needs the ability to perform more complex interfaces (i.e. multiple sources to targets)."
"It is still not as stable as the old BI Apps and ELT tools were, but it's getting there."
"I think Oracle should add more functions to improve optimization."
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration."
"There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."
"The user interface is a little slow."
"The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects."
 

Pricing and Cost Advice

Information not available
"The solution is expensive because of the model they use. The cost is for the license and for support."
"I rate the platform pricing as five out of ten."
"Being an ODI developer, I never had to pay for this product. I know that the pricing/licensing is not really low, but the product is really good."
"Per user, it is $900 USD per year, though they will give some discount. However, even a 60% to 70% of discount for each won't help us much. On top of that, there is the perpetual license you must pay at the outset."
"There is a standard license to use the solution but there are other costs in addition, such as hardware and operating system."
"ODI comes included when buying the cloud version of the Oracle database license."
"The solution is very expensive."
"The Oracle Data Integrator (ODI) pricing isn't expensive, but it's not cheap, so it's in the middle. I'd rate the pricing as three out of five."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
914,109 professionals have used our research since 2012.
 

Comparison Review

it_user99375 - PeerSpot reviewer
Database Administrator at a tech services company with 51-200 employees
Mar 31, 2014
Oracle GoldenGate vs. Oracle Active Dataguard
As an Oracle DBA, while working upon high availability of your database you may stumble upon various Oracle strategic capabilities that fall into categories of Oracle Replication. Oracle provides various technologies for replication like GoldenGate, streams, and Active Dataguard. Replication…
 

Top Industries

By visitors reading reviews
No data available
Financial Services Firm
13%
Outsourcing Company
9%
Government
8%
Comms Service Provider
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business3
Large Enterprise4
By reviewers
Company SizeCount
Small Business26
Midsize Enterprise12
Large Enterprise44
 

Questions from the Community

Ask a question
Earn 20 points
What's the difference between Oracle Integration Cloud Service and Oracle Data Integrator (ODI)?
Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for those who might find the setup to be challenging. There are complications that c...
What do you like most about Oracle Data Integrator (ODI)?
In comparison with other products of the same range, licensing mode is really attractive, no need to license according technology/topology to be used and an incredible Versatility to build any Data...
 

Also Known As

Pervasive Data Integrator, PDI
ODI
 

Overview

 

Sample Customers

Pediatrix Medical Group
Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Find out what your peers are saying about Informatica, Palantir, Microsoft and others in Data Integration. Updated: September 2026.
914,109 professionals have used our research since 2012.