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

Fivetran vs Oracle Data Integrator (ODI) comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Fivetran
Ranking in Data Integration
13th
Average Rating
8.0
Number of Reviews
24
Ranking in other categories
Data Replication (3rd), Cloud Data Integration (6th)
Oracle Data Integrator (ODI)
Ranking in Data Integration
6th
Average Rating
8.2
Number of Reviews
70
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Data Integration category, the mindshare of Fivetran is 2.2%, up from 2.0% compared to the previous year. The mindshare of Oracle Data Integrator (ODI) is 5.2%, down from 5.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Erik Jones - PeerSpot reviewer
Nov 14, 2022
Solution reduces time-to-value; high ROI
Fivetran has room for improvement in data pipeline observability. The Fivetran logs are fairly basic, compared to, for example, the insight Fivetran gives into helping users understanding the performance of data pipelines. So I think their observability into the pipeline itself could be improved. In addition, Fivetran is in the very early stages of allowing other companies to access its metadata API, but that's something that could use improvement, and I know that they're working on right now. We use a separate tool for "reverse ETL", which is the opposite of what Fivetran does; it pushes data from your data warehouse back out to business applications. If Fivetran pulls data from those same applications, they should also enable users to push it back. I would love to do both ETL and reverse ETL in the same tool. It would be nice if Fivetran offered both their regular offering plus the reverse ETL option as well.
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.

Quotes from Members

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

Pros

"The portal is very intuitive and easy to use."
"For us, Fivetran has been able to scale both in terms of the data we bring into our warehouse and the amount of data that we use as well."
"The product is very easy to use and very easy to configure."
"Fivetran is remarkably easy to use; I haven't encountered any other data integration tool that is as user-friendly."
"The product has some seamless connectors, which are readily available."
"There's the general feature of the platform where it just makes it very easy to integrate different things, but I would say a specific difference is their integration of DBT,."
"The general data ingestion is valuable. It's used for a lot of data. It provides about 90% of the data we use in our data warehouse without needing data engineering."
"The ease of usability is the most valuable feature. It's very easy and quick to set up. It also has a central hub as opposed to GoldenGate which is one direct interface. For GoldenGate I would have needed three interfaces whereas with HVR I have a central interface that manages everything."
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"The product has an ELT approach."
"It is an ETL tool, which does the extract, transform, and load."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"The most valuable feature that we use is the Knowledge Modules."
"It's scalable."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
 

Cons

"There was a random change to our contract in a unilateral manner after the first year. The overall cost of using Fivetran was then unclear and this is the reason I would not recommend this solution."
"The interface needs to be more user-friendly."
"We experience cost issues because Fivetran is charged on a usage basis. When you reach a certain level, the tool should focus on reducing the costs. The solution is expensive when you are moving gigabytes and petabytes of data. It should also focus more on REST APIs and webhooks."
"Fivetran is very expensive for data sources with a lot of rows, such as email data. I would like to see cheaper pricing for data sources like that."
"The solution is very expensive. I would like to have a better integration of the solution with Azure."
"I would like to see an improvement in the support offered by Fivetran."
"Fivetran could improve in the area of customization, especially in how they socialize their tools."
"It should have a few more monitoring functionalities."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"There could be better compatibility with other ETL tools and cloud platforms."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"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

"The solution is affordable."
"I would say they're a little bit on the expensive side, and their contract process is not particularly good, but there is a lot of potential flexibility."
"I can't give exact amounts because that's based on usage, but it's more expensive than some of its competitors."
"When you have a lot of workflows and complex use cases, pricing goes down as you use it more."
"I don't have the exact information, but I know it is high, and it is on a yearly basis. There is no additional cost for what we're doing. We're always open to doing things cheaper, so we might potentially implement a different solution."
"The licensing costs are extremely high for the usage of somebody who has one GB or two GB of usage per day for real-time traffic. There are many other players in the market which are similarly priced or competitively priced. On average per month, it used to come around 12,000-15,000 USD, which is very high."
"The pricing model is okay and mid to large companies will not have an issue with it."
"The product is reasonably 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."
"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."
"ODI comes included when buying the cloud version of the Oracle database license."
"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."
"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."
"The solution is very expensive."
"The solution is expensive because of the model they use. The cost is for the license and for support."
report
Use our free recommendation engine to learn which 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
Educational Organization
27%
Computer Software Company
12%
Financial Services Firm
10%
Manufacturing Company
8%
Financial Services Firm
16%
Computer Software Company
14%
Government
9%
Manufacturing Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What's the deal with the HVR software acquisition?
As a user of HVR Software I followed this deal closely. Fivetran is apparently trying to establish more in its sector and by buying an already established data replication software, they become som...
Does HVR Software provide reliable insights?
I honestly can't think of another data replication software that can give you better statistics and insight than HVR Software. There's the feature for topology and statistics and both of them can ...
How much traffic can HVR Software handle?
As someone who works at a company where a high volume of information is replicated and has tried several data replication softwares, I can tell you that you're looking at the right one. HVR Softwar...
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.
 

Also Known As

No data available
ODI
 

Learn More

 

Overview

 

Sample Customers

DocuSign, Oldcastle Infrastructure, Crossmedia, Talkdesk, Chubbies, Brandwatch
Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Find out what your peers are saying about Fivetran vs. Oracle Data Integrator (ODI) and other solutions. Updated: October 2024.
814,649 professionals have used our research since 2012.