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
 

Categories and Ranking

Oracle Data Integrator (ODI)
Average Rating
8.2
Number of Reviews
70
Ranking in other categories
Data Integration (6th)
Zapier
Average Rating
8.6
Number of Reviews
41
Ranking in other categories
Cloud Data Integration (9th)
 

Featured Reviews

Jagadish Sau - PeerSpot reviewer
Oct 31, 2022
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.
Dimitris Goudis - PeerSpot reviewer
May 16, 2023
A tool for automation purposes requiring an easy initial setup while offering a very helpful technical support team
Zapier is not able to set up different modules. When automation doesn't work, it's not that easy to find why it didn't work. So, it's not about the automation process but the triggers that trigger an automation to start running. Sometimes if you set up an automation trigger on a specific application, we wouldn't know if Zapier received data to start running. So we cannot understand whether the problem is in Zapier or the steps before. Branching scenarios is something I want to add to the solution to make my life easier. We want to apply a logical workflow with a yes or no condition. On Zapier, you can have a condition, but you can build the actions after one value on this condition. So, the question can be responded to with a yes-no option or not answered. In your scenario, you have only the actions after yes get chosen. A second scenario is needed for the answer, no, and a third one for not answered. While in Make, we create a diagram, according to which if the response is yes, then do follow this path, and if it's no, then follow another path.

Quotes from Members

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

Pros

"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"The product has an ELT approach."
"It uses the power of the database system efficiently."
"Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast."
"​The installation of the client ODI Studio is easy.​"
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"It's scalable."
"The ability to connect web applications to trigger actions in another app after having enriched, formatted, delayed, grouped, and filtered is really valuable for many businesses."
"Zapier handles everything under the sun that you would think you need in automation. It is the most mature integration platform and service on the market."
"The product's initial setup phase was very easy."
"The initial setup is pretty easy to do."
"The most valuable feature of Zapier is it saves me time doing repetitive tasks."
"We can connect Zapier with Zoho CRM for lead generation. I like the tool's drag and drop feature."
"We find it effortless to set up. We really don't have to do anything other than finding the application in the Zapier catalog. And as long as the application has been re-integrated into Zapier, they're able to then just provide the connection details and hook it up."
"What's most valuable in Zapier is its simplicity, seamlessness, and smooth plug-in, so you won't need to build code for every action. I'm not a developer, but I can use Zapier."
 

Cons

"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"We used a third party to do the implementation of ODI."
"There could be better compatibility with other ETL tools and cloud platforms."
"The price needs to be lowered. It's too expensive."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"After mapping them out, and they'd worked for a while, I've had Zapier fail."
"The pricing could be a little cheaper."
"It could support various languages along with Python."
"With Zapier, improvements are required in the areas of concerns like bugs, ease of use, and documentation."
"The user interface for Zapier could be improved. It also takes some time to sync the data between different environments."
"Zapier needs more YouTube or video tutorials or more training for people. That would help a lot. In particular, Zapier should have documentation for every connector. Its documentation needs to be more detailed and visual."
"Some apps are not available yet. For instance, a connection with Joomla! would be great. In general, all the most-used apps are available, but I bumped into Joomla! with a client."
"Zapier could be a little faster, but that might not be possible. I would encourage Zapier to make more API endpoints for each application"
 

Pricing and Cost Advice

"We found that the cost compared to other integration tools is a little high, but the solution works great."
"There is a standard license to use the solution but there are other costs in addition, such as hardware and operating system."
"I rate the platform pricing as five out of ten."
"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."
"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."
"The solution is very expensive."
"I have yet to determine the exact figure for Oracle Data Integrator (ODI) pricing, but it has lower pricing than Informatica."
"ODI comes included when buying the cloud version of the Oracle database license."
"There is a free plan that is, of course, limited. However, it allows you to understand and check true scenarios for a while."
"Per task, there is a monthly plan involving 15 euros...Also, in different forms, they just give you the ability to use different features. They charge 18.58 euros for the first standard plan, which includes 750 tasks. So, it is about 25 cents per task."
"It's very straightforward licensing. There's only one cost you have to pay, and if you want a relevant pricing plan, I think you have two or three different models or packages which include the number of notifications or Zaps, as they call it, that you can program."
"Think your Zaps through to make sure you don't use more Zaps than you need."
"The price of Zapier is approximately $75 monthly."
"Zapier's price is good."
"It's very affordable."
"Zapier is a paid service. Its license renews monthly, and Zapier will downgrade your subscription to the free version when your credit card doesn't have funds. That significantly impacts your service because everything halts completely. Zapier doesn't have any hidden costs."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
814,649 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
16%
Computer Software Company
14%
Government
9%
Manufacturing Company
8%
Computer Software Company
22%
University
8%
Comms Service Provider
8%
Financial Services Firm
8%
 

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)?
ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases.
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?
The pricing could be a little cheaper.
 

Also Known As

ODI
No data available
 

Learn More

 

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: October 2024.
814,649 professionals have used our research since 2012.