Try our new research platform with insights from 80,000+ expert users

Oracle Data Integrator (ODI) vs Qlik Replicate comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
7.6
Oracle Data Integrator provides high ROI, reducing custom ETL efforts and costs, with Cloud version enhancing implementation and efficiency.
Sentiment score
8.0
Qlik Replicate automates reporting, saves time, reduces database usage, minimizes costs, and improves efficiency compared to AWS services.
I conducted a cost comparison with the AWS service provider, and this option is much cheaper than the Kinesis service offered by AWS.
 

Customer Service

Sentiment score
5.9
ODI support gets mixed reviews; quick solo responses but struggles in multi-product setups, often leading users to forums.
Sentiment score
5.7
Users find Qlik Replicate support slow and inefficient, preferring quicker resolutions and direct contact with representatives, especially for AutoML issues.
I can get solutions quickly, and any tickets I submit to Oracle are responded to and resolved rapidly.
Even priority tickets, which should be resolved in minutes, can take days.
 

Scalability Issues

Sentiment score
7.6
Oracle Data Integrator scales well, integrating with WebLogic, while configuration and setup impact its performance in various environments.
Sentiment score
7.1
Qlik Replicate is scalable and adaptable, especially in cloud environments, but may require memory adjustments for optimal performance.
 

Stability Issues

Sentiment score
7.3
Oracle Data Integrator is stable and efficient, with minor configuration challenges resolved in newer versions like 12.1.3 and 12cR2.
Sentiment score
8.5
Qlik Replicate is highly stable and reliable, efficiently handling large volumes, with seamless recovery despite minor API concerns.
 

Room For Improvement

ODI users seek improved performance, usability, integration, and cost-efficiency, with better error handling, authentication, and automation features.
Qlik Replicate needs better UI, error clarity, support, integration, pricing transparency, performance, and marketing to compete effectively.
If I use a source system like Oracle and a target system like Teradata, ODI will still run, but it struggles a bit with different infrastructures.
It is a core-based licensing, which, especially in the banking industry, results in the system capacity being utilized up to a maximum of 60%.
 

Setup Cost

Oracle Data Integrator has complex, costly pricing with various licensing options; discounts and packages can reduce expenses for enterprises.
Qlik Replicate's pricing is high and less flexible than competitors, suiting larger companies with extensive replication needs.
ODI is cheaper compared to Informatica PowerCenter and IBM DataStage.
Licensing is calculated based on the machine's total capacity rather than actual usage.
 

Valuable Features

Oracle Data Integrator features flexible, customizable integration with diverse technologies, enhancing performance and efficiency in data integration tasks.
Qlik Replicate offers real-time data capture, easy replication, and seamless integration for efficient data management and real-time analytics.
Oracle Data Integrator (ODI) is powerful and strong if my system uses Oracle components for environments like OLTP, enterprise data warehouse, or data marts.
Data retrieved from the system can be pushed to multiple places, supporting various divisions such as marketing, loans, and others.
 

Categories and Ranking

Oracle Data Integrator (ODI)
Ranking in Data Integration
7th
Average Rating
8.2
Reviews Sentiment
6.8
Number of Reviews
71
Ranking in other categories
No ranking in other categories
Qlik Replicate
Ranking in Data Integration
13th
Average Rating
8.2
Reviews Sentiment
6.9
Number of Reviews
17
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of March 2025, in the Data Integration category, the mindshare of Oracle Data Integrator (ODI) is 4.6%, up from 4.4% compared to the previous year. The mindshare of Qlik Replicate is 3.1%, up from 2.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Jagadish Sau - PeerSpot reviewer
Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved
My company has around ten users of Oracle Data Integrator (ODI). A team of two to five people handles the deployment and maintenance of the solution. The current client of my company has this plan of moving to the cloud, with the possibility of replacing the ETL tool altogether, which could mean that more data is coming up, so there may be a plan to increase the usage of Oracle Data Integrator (ODI). My advice to others looking into implementing Oracle Data Integrator (ODI) is that if your database is on Oracle or SQL server, then Oracle Data Integrator (ODI) is a good tool to use. My rating for Oracle Data Integrator (ODI) is seven out of ten.
KrishnaBaddam - PeerSpot reviewer
Lightweight tool, ensures that data is replicated across different systems and simplify complex tasks such as defining relationships
Qlik Compose is something that will automate user's overall data modernization. Here data modernization includes data modeling, ETL jobs, etc. But the advantage is users can automate the overall process of data engineering and data modeling through Qlik Compose. I think that's useful when users are able to manage 60% of the workload automated. That will be very useful. That's fantastic. Replicate does not have a great AI capability. AI capabilities are present in Qlik Sense. Qlik Replicate is a very light tool. It is only meant to capture data from the log files, get the data, and transfer it, read that table structure, create the table structure, and transfer the data whenever there is a change. So, it basically integrates with the kernel of the operating system. The way it works is that these replicate tools will integrate with the kernel of the operating system, and they will access the redo log files of the database. The redo log should have access to all the files of the structure of the schema, too. So, using that technique, they redo all the data structures, create a similar structure, and replicate the structure in the target schema, table, and database. After that is done, it will start tracing the instances that are happening. For example, if data is inserted into the table, then an insert is fired on the statement on the table. So, that particular insert is captured. And based on that insert statement, it will pull the SQL query and say, "Okay, there is an insert. I need to get that data." It will get the data from the redo log itself rather than going to a database. Then, it will just pass that transaction into the target system, where it will just insert the data. And this happens instantaneously, within a microsecond. So, if there is an insert, an update, or a delete, everything is transferred immediately. It is picked from the redo log because it comes to the redo log, and then the redo log sends it to Qlik Replicate and Replicate to the target system on which Replicate is installed.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
842,388 professionals have used our research since 2012.
 

Comparison Review

it_user99375 - PeerSpot reviewer
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
Financial Services Firm
17%
Computer Software Company
12%
Government
9%
Manufacturing Company
8%
Financial Services Firm
19%
Computer Software Company
11%
Insurance Company
10%
Manufacturing Company
10%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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...
What is your experience regarding pricing and costs for Oracle Data Integrator (ODI)?
The pricing of Oracle Cloud Services is not favorable as it charges daily regardless of usage, unlike competitors who charge only for days used.
What do you like most about Qlik Replicate?
The main valuable feature is its real-time change data capture (CDC) capabilities, which process data with minimal latency. There is not much delay. It also performs well with batch-wise data appli...
What needs improvement with Qlik Replicate?
There is complexity involved in the licensing part of this system. It is a core-based licensing, which, especially in the banking industry, results in the system capacity being utilized up to a max...
What is your primary use case for Qlik Replicate?
An example involving the banking project I am currently working on is for a public sector bank in India. Primarily, they are using a database, and the ultra architecture is meant to take a backup o...
 

Also Known As

ODI
Replicate, Qlik Replicate
 

Overview

 

Sample Customers

Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
American Cancer Society, Fanzz, SM Retail, Smart Modular, Tangerine Bank, Wellcare
Find out what your peers are saying about Oracle Data Integrator (ODI) vs. Qlik Replicate and other solutions. Updated: February 2025.
842,388 professionals have used our research since 2012.