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

Oracle Data Integrator (ODI) vs Talend Data integration 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)
Talend Data integration
Average Rating
8.6
Number of Reviews
5
Ranking in other categories
Cloud Data Integration (20th), Integration Platform as a Service (iPaaS) (15th)
 

Q&A Highlights

RS
Sep 09, 2021
 

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.
AntonioFonseca - PeerSpot reviewer
Apr 11, 2024
Easy-to-use product with the ability to generate code efficiently
Our primary use case involves integrating diverse data sources into our projects. These sources include data servers, fax files, CSV files, databases such as SQL and Postgres, and various other formats like Excel Talend's most valuable feature is its ability to generate code and packages…

Quotes from Members

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

Pros

"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."
"​The installation of the client ODI Studio is easy.​"
"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."
"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."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"The most valuable feature is Data movement."
"The scalability is great. It's one of the reasons we chose the solution."
"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's integration with PostgreSQL and Jira has been helpful for us. Its performance is good. However, we do not use it for large data sets."
"We have multiple use cases for this solution. We integrate with Salesforce, SAP and Oracle databases to build business logic and provide reporting."
"Talend Data integration has a wide library of connectors."
"Talend's most valuable feature is its ability to generate code and packages efficiently."
"I'm very passionate about this solution because if you look at any other tool that costs around $200 - $300,000, like Delphix which costs you a million dollars, Talend is very cheap and is almost is at par with what others can do. There is one thing which Delphix does which Talend cannot do, but overall, I would say apart from that, if you're looking for a solution, you should give it a try."
 

Cons

"Oracle support services are not up to the mark."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"If you have something like Cisco on top of it, you will have endless problems."
"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."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"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."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"The Oracle Data Integrator interface is extremely slow, especially when using remote desktop connections."
"The tool's technical support needs to be better. It doesn't have a local data center but pushes everything to the cloud. They need to check in with customers to see if they're happy and how well the solutions work. They need to assign a customer success manager for the accounts they sell."
"The product's setup process could be simpler."
"Sometimes there are bugs which are unidentified and we have to follow-up with the Talend team to resolve them. In a critical situation, it takes time for them to update patches."
"Due to using the open-source version of Talend Data Integration, which lacks a scheduler, our current approach involves developing jobs in Talend, exporting them as Java packages, and utilizing an external scheduler, such as Windows Scheduler, to manage the scheduling process."
"There are no concurrent licenses, they only have seat licenses on cloud. That's the whole challenge. For example, if in any project your headcount increases or decreases, you do not have that concurrence and you have a seat license, you run into challenges because you have to procure a few more licenses for getting the job done."
 

Pricing and Cost Advice

"I have yet to determine the exact figure for Oracle Data Integrator (ODI) pricing, but it has lower pricing than Informatica."
"There is a standard license to use the solution but there are other costs in addition, such as hardware and operating system."
"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."
"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."
"We found that the cost compared to other integration tools is a little high, but the solution works great."
"ODI comes included when buying the cloud version of the Oracle database license."
"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 solution is expensive because of the model they use. The cost is for the license and for support."
"I have been using the open-source version."
"The product pricing is considered very good, especially compared to other data integration tools in the market."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
814,763 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…
 

Answers from the Community

RS
Sep 9, 2021
Sep 9, 2021
There are two products I know about * TimeXtender : Microsoft based, Transformation logic is quiet good and can easily be extended with T-SQL , Has a semantic layer that generates metat data for cubes . price approx 40K$, works with tables . Attunity (Bought by Qlik) : technology agnostic , nice web interface , expensive > 100K€. Works with transaction logs There are many other pure ETL ...
2 out of 12 answers
SS
Apr 6, 2020
We usually use Talend. Look here: https://community.talend.com/t5/Design-and-Development/The-way-from-OLTP-to-OLAP/td-p/116719
RS
Apr 7, 2020
Thanks Stefan !!! May I know if Talend is opensource /free ? It is available in all 3 editions - basic , standard end enterprise? it is capable to read data from all heterogeneous system like various types of data bases and files etc..?
 

Top Industries

By visitors reading reviews
Financial Services Firm
16%
Computer Software Company
14%
Government
9%
Manufacturing Company
8%
Computer Software Company
16%
Manufacturing Company
11%
Financial Services Firm
10%
Retailer
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

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 Talend Data integration?
The product's integration with PostgreSQL and Jira has been helpful for us. Its performance is good. However, we do not use it for large data sets.
What is your experience regarding pricing and costs for Talend Data integration?
The product pricing is considered very good, especially compared to other data integration tools in the market.
What needs improvement with Talend Data integration?
The product's setup process could be simpler.
 

Also Known As

ODI
Talend Cloud Integration, Talend Integration Cloud, Talend Cloud Remote Engine for AWS
 

Learn More

 

Overview

 

Sample Customers

Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
ACCOR, ADR, L'OREAL, AstraZeneca
Find out what your peers are saying about Oracle Data Integrator (ODI) vs. Talend Data integration and other solutions. Updated: October 2024.
814,763 professionals have used our research since 2012.