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

Oracle Data Integrator (ODI) vs Zapier comparison

 

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:
 

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
6.5
Users experience benefits from Zapier's automation and cost savings, though calculating specific ROI can be challenging.
In a scenario where employing three resources for three months might cost approximately $18,000 to $20,000, Zapier provides substantial cost savings.
 

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
7.2
Mixed experiences with Zapier support: praised for responsiveness and knowledge, yet some note delays and lack of chat.
I can get solutions quickly, and any tickets I submit to Oracle are responded to and resolved rapidly.
Their technical support is good; they respond promptly and are very helpful.
This can help if you need assistance, as you can communicate with the community and support system, and most issues are already resolved by AI.
Sometimes, in my early days, when I was stuck with something, they helped me solve these issues, and even helped me solve some of my automations.
 

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.6
Zapier is ideal for small businesses prioritizing simple tasks, though costs and stability may concern larger organizations.
Zapier is suitable for small or simpler automation but not for complex ones.
Scaling it gets quite expensive, and while I cannot evaluate it purely from a technology perspective, compared to Workato, I would give Zapier a seven for scalability.
 

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
6.9
Users find Zapier reliable, with minor issues often linked to third-party tools, and rate stability highly for varied needs.
In my current company, we had significant challenges with Zapier regarding maintenance, as Zaps were often broken, not necessarily due to Zapier, but due to changes in the input variables.
 

Room For Improvement

ODI users seek improved performance, usability, integration, and cost-efficiency, with better error handling, authentication, and automation features.
Zapier users face issues with Google Sheets, insufficient integrations, complex workflows, high costs, and limited customization and support.
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.
The error message options in the dashboard should be improved. It should be user-friendly so that beginners or non-technical users can figure out the problems and solutions on their own.
You can build similar or dependent automations in one Zap, which helps with understanding the process without switching between different records.
I would appreciate if there would be a feature where we can use actions right after loops. Currently, you cannot use any other action after the loop. Everything needs to be within the loop.
 

Setup Cost

Oracle Data Integrator has complex, costly pricing with various licensing options; discounts and packages can reduce expenses for enterprises.
Enterprise buyers find Zapier cost-effective for its integrations, despite some viewing it as pricier than alternatives.
ODI is cheaper compared to Informatica PowerCenter and IBM DataStage.
The pricing is in accordance with market standards and even lower in some cases.
The pricing of Zapier is slightly higher compared to other market automation tools such as Pabbly, Make.com, and N8N, which have good features but are priced lower than Zapier.
 

Valuable Features

Oracle Data Integrator features flexible, customizable integration with diverse technologies, enhancing performance and efficiency in data integration tasks.
Zapier offers over 20,000 integrations, automating workflows without coding, enhancing productivity with user-friendly, drag-and-drop functionality.
Oracle Data Integrator (ODI) is powerful and strong if my system uses Oracle components for environments like OLTP, enterprise data warehouse, or data marts.
They have approximately 7,000 connections.
Even a person with no technical knowledge can use Zapier to create automations.
The automation capabilities are impressive.
 

Categories and Ranking

Oracle Data Integrator (ODI)
Average Rating
8.2
Reviews Sentiment
6.8
Number of Reviews
71
Ranking in other categories
Data Integration (7th)
Zapier
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
49
Ranking in other categories
Cloud Data Integration (13th)
 

Featured Reviews

Jozsef Gazsik - PeerSpot reviewer
Offers a very good development environment and supports the use of multiple programming languages
We are using a graphical tool called PowerDesigner to create logical and physical models. From that, we create code that can be run by Oracle Data Integrator, which then maps the data based on these models and sends it to its destination. It is currently very integrated with Oracle The Oracle…
Awais Mehmood - PeerSpot reviewer
Error message clarity needs improvement but third-party integrations facilitate automation
I would to improve the integration between Zapier and Notion since Notion did not allow it previously. One issue I experienced was that when Zapier did not automate or threw an error, the error was not user-friendly. I searched extensively in browsers and the Zapier community to find solutions. The error page or the Zapier error message should be user-friendly, and the error message should relate to the user so they can easily understand the error and solve that specific problem. The error message options in the dashboard should be improved. It should be user-friendly so that beginners or non-technical users can figure out the problems and solutions on their own.
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
859,129 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
18%
Computer Software Company
11%
Government
10%
Manufacturing Company
7%
Computer Software Company
12%
Financial Services Firm
10%
University
9%
Educational Organization
6%
 

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)?
If I use the whole Oracle system, it can be cost-effective. ODI is cheaper compared to Informatica PowerCenter ( /products/informatica-powercenter-reviews ) and IBM DataStage. However, for tools li...
What do you like most about Zapier?
The product's most valuable feature is automation.
What is your experience regarding pricing and costs for Zapier?
The pricing is suitable. It's not cheap, but not expensive.
What needs improvement with Zapier?
You can build similar or dependent automations in one Zap, which helps with understanding the process without switching between different records. I would appreciate quicker response times and more...
 

Also Known As

ODI
No data available
 

Overview

 

Sample Customers

Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
BuzzFeed, Groupon, Spotify, Columbia University, FOX
Find out what your peers are saying about Oracle Data Integrator (ODI) vs. Zapier and other solutions. Updated: June 2025.
859,129 professionals have used our research since 2012.