Most Helpful Review
Besides loading data, we do most of our transformations in it. However, the stability of the software could be improved.
Find out what your peers are saying about Oracle Data Integrator (ODI) vs. Talend Open Studio and other solutions. Updated: September 2019.
372,374 professionals have used our research since 2012.
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
The most valuable feature that we use is the Knowledge Modules.
It's completely user-friendly.
All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.
It has the ability to easily load slowly changing dimensions.
The installation of the client ODI Studio is easy.
Besides loading data, we do most of our transformations in ODI.
In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way.
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.
This solution has improved our overall time to value for data ingestion.
You can use Talend as a stand-alone application without customization to collect data and generate reports over dashboards. It's got great functionality.
The initial setup was quite straightforward. The deployment took between two and three days.
We have contacted their technical support. They are great. They offer very professional help. If I need some technical answer, they are very professional. They are quick, professional, and very accurate.
A helpful feature for us is the integration with NoSQL databases.
The Talend Studio connected to the Talend MDM (Master Data Management) is the most valuable feature. Talend Studio is used to create a job stream that connects to multiple data sources, matches, compares or creates a golden record for overall identification. It also has a good catalogue of objects that can be dragged and dropped for building models.
The performance of the user interface is in need of improvement.
Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts.
It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons
It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses.
The stability of the software could be improved. Sometimes, the software just crashes.
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.
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.
Technical Support could be better.
Inter-version compatibility is a problem, and migration projects between versions are required.
There used to be many Youtube channels that offered Talend training, but now there don't seem to be any. The solution should offer more online training resources.
The profiling perspective needs improvement. Instead of using it in the studio, we are using a different tool which is also provided by Talend. It's redundant.
If I compare Open Studion to other solutions, their interface is robust but not so fancy looking. This is an area that could use improvement. I would like to see an updated interface.
The price for Talend Data Integration should be less expensive.
It needs better installation configuration for other databases. Although the installation allows you to select another database, this doesn't mean that all connection points in the application point to the database selected. You actually need to do a search through the entire install to locate the configuration settings and change them.
In version 6.2 we did encounter issues with the job servers and specifically with ESB. Version 6.3 is better but large jobs can cause the MDM server to fall over, requiring a reboot.
Pricing and Cost Advice
We found that the cost compared to other integration tools is a little high, but the solution works great.
Talend is free and you can download it.
Pricing and licensing are fairly straightforward. It is reasonably priced and managed.
out of 84 in Data Integration Tools
Average Words per Review
out of 84 in Data Integration Tools
Average Words per Review
Compared 25% of the time.
Compared 17% of the time.
Compared 11% of the time.
Compared 14% of the time.
Compared 13% of the time.
Compared 12% of the time.
Also Known As
Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services. Oracle Data Integrator (ODI) 12c, the latest version of Oracle’s strategic Data Integration offering, provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate.
ODI12c further builds on its flexible and high-performance architecture with comprehensive big data support and added parallelism when executing data integration processes. It includes interoperability with Oracle Warehouse Builder (OWB) for a quick and simple migration for OWB customers to ODI12c. Additionally, ODI can be monitored from a single solution along with other Oracle technologies and applications through the integration with Oracle Enterprise Manager 12c.
|Talend's open source products and open architecture create unmatched flexibility so you can solve integration challenges your way. Talend reduces the learning curve and lowers the barrier to adoption for data integration, data profiling, big data, application integration, and more.|
Learn more about Oracle Data Integrator (ODI)
Learn more about Talend Open Studio
|Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University||Almerys, BF&M, Findus|
Financial Services Firm30%
Software R&D Company33%
Financial Services Firm11%
Comms Service Provider10%
Software R&D Company30%
Financial Services Firm13%
Comms Service Provider7%