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
Reviews Sentiment
7.0
Number of Reviews
25
Ranking in other categories
Data Replication (3rd), Cloud Data Integration (6th)
Oracle Data Integrator (ODI)
Ranking in Data Integration
6th
Average Rating
8.2
Reviews Sentiment
6.8
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
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
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

"SysTrack load is the best feature."
"It is easy for users to get accustomed to the tool due to its gentle learning curve and clear error transparency."
"The portal is very intuitive and easy to use."
"Fivetran is remarkably easy to use; I haven't encountered any other data integration tool that is as user-friendly."
"The ease of setting up the connectors and transformations is highly valuable."
"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 product has some seamless connectors, which are readily available."
"Fivetran's most valuable feature is replication."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value."
 

Cons

"I would like Fivetran to implement additional resource monitoring and restriction policies."
"An in-line data quality checking capability is missing"
"Fivetran would be improved by adding the ability to integrate the data from third-party APIs."
"The customization could improve because Fivetran gives more thought to people who don't want to manage analytics workflows rather than engineers who want to be able to customize pipelines more thoroughly."
"I would like for them to incorporate additional transformations. A valuable aspect of the product is that it does inflight transformations and that could be expanded."
"Some of the pain points we're looking at are trying to integrate some of the items in the Microsoft stack, so SharePoint and Excel, and then some of the newer Azure services."
"I would like to see an improvement in the support offered by Fivetran."
"It should have a few more monitoring functionalities."
"Stability could be improved because some operators have issues."
"The price needs to be lowered. It's too expensive."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"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."
"The initial setup is complex, especially if you also have to install a console."
"Reverse engineering is complicated and challenging to manage."
"Oracle support services are not up to the mark."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
 

Pricing and Cost Advice

"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."
"I've heard that the license for HVR is a bit costly compared to its competitors, but since it's reliable and efficient, I think the customer shouldn't be bothered about the cost."
"I can't give exact amounts because that's based on usage, but it's more expensive than some of its competitors."
"Fivetran is very expensive, and its database-driven pricing model is outdated."
"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 solution is affordable."
"In the first year, we were given a very good discount. It was approximately 20,000 Euros per year. In the third year, we purchased credit for two years and the price was 33,000 Euros per year."
"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."
"We found that the cost compared to other integration tools is a little high, but the solution works great."
"The solution is expensive because of the model they use. The cost is for the license and for support."
"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."
"The license can be costly, but in certain complex cases, ODI proves to be the optimal solution."
"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."
"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."
"ODI comes included when buying the cloud version of the Oracle database license."
report
Use our free recommendation engine to learn which 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
Educational Organization
28%
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.
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.
 

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: November 2024.
816,406 professionals have used our research since 2012.