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
Reviews Sentiment
6.8
Number of Reviews
70
Ranking in other categories
Data Integration (6th)
Zapier
Average Rating
8.6
Reviews Sentiment
7.6
Number of Reviews
41
Ranking in other categories
Cloud Data Integration (9th)
 

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.
FrankHo - PeerSpot reviewer
Though the tool offers a visually appealing UI, it needs to improve its documentation
With Zapier, improvements are required in the areas of concerns like bugs, ease of use, and documentation. The product has many bugs, so users have to wait for a period ranging from five minutes to an hour to see where the Zap went. In Zapier, Zaps aren't very understandable owing to the way they work. As a user, you would think that in Zapier, a Zap works in a particular way once you set it up, but it won't happen. At times, some Zaps can interfere with each other, because of which there might be infinite loops that may occur, owing to which multiple Zaps continue to run or break down in general, after which nothing would run in your environment. You would not be notified about the breakdown of Zaps. The bugs in the product may be considered to understand or get an explanation of how Zaps works between software systems, so for something between Gmail and HubSpot, Zapier would explain through better documentation what would work and what wouldn't work. Maybe if Zapier had better functionality with Python or any other coding language in general, it would make the product a lot better.

Quotes from Members

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

Pros

"​The installation of the client ODI Studio is easy.​"
"It effectively manages errors through its logging and exception-handling capabilities."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"It uses the power of the database system efficiently."
"The tool improved our data integration workflow primarily due to its compatibility with Oracle. Its integration makes it very convenient for analytics. Its most valuable feature is robust extended capability. The solution's debugging capabilities are good."
"There are a few valuable features, like the stability that it comes with and also the number of features that it offers. I've used other services like Pabbly, but they don't offer similar numbers of applications that Zapier has or allows to integrate with – it's maximum."
"Zapier is user friendly and makes it easy to integrate different tools. It has a drag and drop functionality which makes it easy to connect environments."
"The most valuable aspect of this solution is that it is very intuitive and has a very flat learning curve."
"The initial setup is pretty easy to do."
"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."
"The solution is a SaaS and does not require a complex setup."
"With the previous CRM we were using – the Google Ads landing pages we had – we were collecting leads manually. That process was not efficient and took a sales team a lot of time to insert these leads manually. Currently, the process is smooth and we use Zapier to collect the leads for us."
"Zapier is a really good tool for connecting multiple different platforms and data sources. For example, with Quickbase, I can easily integrate data from other sources like AWS or task-tracking platforms such as ClickUp or Asana."
 

Cons

"The solution lacks some functions and features."
"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 tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"Oracle support services are not up to the mark."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"It needs easier security."
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
"Stability could be improved because some operators have issues."
"Zapier needs to improve in the same way most RPA solutions should, such as Robocorp, Make, or UiPath. They are not good at helping you find the connections that you need for the problem that you have. For example, if need something on Instagram. I'm going to have to do research for hours to be able to find the components or the app, which is going to do what I need it to do. It makes it difficult to use the system when you don't know what to use."
"My biggest concern with Zapier would be their pricing strategy."
"System-to-system is fine, but when it comes to system-to-user, where Zapier is helping to communicate to a user, that's a one-way communication. If that user has to perform some action on that notification, the action isn't handled by Zapier. So there's no way to orchestrate that and it's very cumbersome."
"There is room for improvement in the support. They are not responsive, and they don't take much time to get resolved."
"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."
"Some recent changes to the solution have made it bulky and not as intuitive to use as it previously was."
"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."
"The user interface for Zapier could be improved. It also takes some time to sync the data between different environments."
 

Pricing and Cost Advice

"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."
"ODI comes included when buying the cloud version of the Oracle database license."
"I rate the platform pricing as five out of ten."
"There is a standard license to use the solution but there are other costs in addition, such as hardware and operating system."
"The solution is expensive because of the model they use. The cost is for the license and for support."
"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."
"We found that the cost compared to other integration tools is a little high, but the solution works great."
"The solution is very expensive."
"Zapier's price is good."
"The price of Zapier is approximately $75 monthly."
"The product is reasonably priced."
"Think your Zaps through to make sure you don't use more Zaps than you need."
"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."
"There is a free plan that is, of course, limited. However, it allows you to understand and check true scenarios for a while."
"The least expensive plan is $24 a month, and you can go all the way to $800 a month if you're a huge company using many tasks."
"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."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
816,406 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
20%
University
9%
Financial Services Firm
8%
Comms Service Provider
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 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 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.
816,406 professionals have used our research since 2012.