TrustRadius Insights for Oracle Data Integrator (ODI) are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
User-Friendly Interface: Reviewers have consistently praised the simplicity and user-friendliness of the interface, making it easy to navigate and utilize efficiently. The neat and clean design enhances the overall user experience, with users finding it particularly intuitive for extracting, transforming, and loading data.
Abundance of Transformation Options: Many users have highlighted the wide range of transformation options available, which significantly aids in completing tasks effectively and efficiently. These diverse options cater to different data handling needs, allowing users to work with large volumes of data from multiple sources seamlessly.
Scalability and Performance: The scalability and performance of the product have been commended by reviewers for handling high-volume batch load ETL processes and providing flexibility with big-data extractions. Users appreciate the top-notch scalability that enables them to tackle complex data integration tasks within one efficient tool.
Loading Reviews List....
Oracle Data Integrator (ODI) Reviews
18 Reviews
Enterprises (1,001+ employees)
Search is temporarily unavailable. Filters are still applied.
We use this Data Integrator tool to handle ETL(Extract, Transform and Load) part of large volume of data to fulfil our stakeholder requirements. This tool does a really great job to handle good amount of data from various sources and maintain the business intelligence system. This tool is being used in specific departments for now.
Pros
The User Interface is pretty neat and clean which is very easy to use.
There are a lot of transformation options available to choose from.
The scalability and performance are top notch.
Cons
The cost part is bit high as compared to its peers.
Sometimes there is a lag and it gets hanged.
Real time data Integration cannot be handled.
Likelihood to Recommend
This tool is very well suited if you are having an existing Oracle ecosystem with large volume of data present in different sources. Anyone without much knowledge of SQL can use this tool.
Currently, ODI is used within a few departments of our organization. We utilize it with other Oracle Utility Applications and Middleware (SOA) as an ETL tool. We have a number of interfaces linked with our Oracle Databases and the ODI layer is used to do transformations. We also use it as part of Oracle Utility Analytics with their extractors and it is integrated with part of our GoldenGate Setup.
Pros
Integration with other Oracle products.
Install/documentation was easy to understand for interfaces/utility use.
Consistent results, does what we need it to do.
Cons
Oracle Support is not always the quickest to resolve ODI issues.
Specifically with the OUA extractors, the install/documentation was lacking.
Likelihood to Recommend
For our case, we use ODI as suggested by Oracle and integrated with other Oracle products. We are an Oracle shop and it has worked well when used as intended. We use it with the Oracle Utility Suite of products and SOA as well as with Oracle Utility Analytics and extractors. In both cases, it has delivered what we need, so I do not have any examples of it not working.
VU
Verified User
Administrator in Information Technology (1001-5000 employees)
As a number of our back end databases are Oracle based, so an ETL tool was required to handle all the data pipelining. Earlier it was being done through PL/SQL which was bit complex to learn for everyone. So it was decided to use Oracle Data Integrator as a formal ETL Tool. This is being used in specific departments as of now. This is an amazing tool to implement different transformation logics in an easier way and is quite efficient in handling the data which ends up in saving user's time.
Pros
It is very easy to integrate with Oracle data sources at backend.
Plenty of transformation options and reverse engineering is bit easier.
The interface is very simple and user friendly.
Cons
Real time integration is bit of a hassle.
Customer Support could be improved to some extent.
Data ingestion with variety of data sources could be difficult to implement.
Likelihood to Recommend
This is an amazing ETL Tool if you have multiple Oracle source databases. But could be hassle if there are multiple other data sources as it's bit complicated to integrate with them. Overall this is a tool that will optimize and facilitate the integration of data in a fairly simple and integrated way.
VU
Verified User
Employee in Information Technology (10,001+ employees)
We often work with Oracle database products and Oracle Data Integrator has been really useful for EPMA integration. It allows us to have a vivid understanding of topological data. It helps us clarify loose ends as it concerns the plotting of data modules. It provides a significant improvement in clarity that helps us identify issues at job locations. It has been really helpful in visualizing the data set and centralizing company data.
Pros
With Oracle Data Integrator, we get platform independence as it supports a wide range of platforms.
The FCP makes it easy to administer infrastructure and visualize data flows.
It is cost-effective.
Cons
I think it still has a lot of work to do in terms of speed of access and operation. That is why it rates a "7 out of 10" for me.
The quality of support can also be improved.
It can take longer than usual to generate documentation.
Generated code can also be complicated even for technical users.
Likelihood to Recommend
It is best to use Oracle Data Integrator when you need a data consolidation solution. It works effectively in that sense. We have also used it for multiple data integration projects where we had to load data warehouses. It worked efficiently. I would not recommend it if you are working with multiple SDLCs. It is not the best tool for multi-user development environments.
VU
Verified User
Manager in Information Technology (10,001+ employees)
We use Oracle Data Integrator for Oracle EPMA integration. We use it for our data integrations and automation.
Pros
One of the most powerful ways to run your design-time in various environments.
Run-time artifacts in various environments.
Cons
Difficult to use
Deep technical knowledge is needed
Likelihood to Recommend
Oracle Data Integrator is easy to integrate with all kinds of resources. Strong connectivity for all databases (Oracle, MS SQL, MySQL, etc.) and contains many alternative features. For example, It offers scheduled operating steps, email alerts, etc.
VU
Verified User
Professional in Information Technology (1001-5000 employees)
We use many Oracle products and Oracle Data Integrator provides a graphical environment to do an overall process unlike other ETL tools in the market. This is simple to connect with Oracle databases and the inbuilt functions/features is very useful to overcome the common issues.
It handles a large quantity of data with ease and is powerful for processing ETL.
Pros
It has a graphical environment which is easy to understand
Lightweight designer which is very easy to view and edit the objects with ease
All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.
Cons
It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are depreciated simply for commercial reasons, although it looks like the cloud option offers some extra connectors.
It is not very good for real time data integrations.
Likelihood to Recommend
When we use Oracle JDE, EBS, Hyperion with lot of customizations
When huge data integrations are needed but there is no need for real time integration
Error monitoring required unlike Flat File Integrations which won't have good error monitoring
Complementary products like Hyperion are already in place with ODI licenses included
VU
Verified User
Team Lead in Information Technology (10,001+ employees)
It's used in critical integration projects to address the problems of integrating with multiple formats of various sources. We are able to debug at different log levels. It's easy to reuse components and it's helped in avoidance of any hard coding. It's easy to develop, maintain, configure and secure. We have the ability to call scripts,. The PL/SQL routines along with its regular mappings helped to avoid use of multiple tools.
Pros
Leveraging the abilities of Target Database for transformations and computation
Unique ability to integrate with heterogeneous sources works well.
An application developer does not need to worry much about error handling like pl/SQL Developers have to do
Cons
Need improvements in ease of access to the user interface
Need to worry about whether all the required jar files are available or not for any new connection of any new technology.
Each new technology has its own approach to establish the connectivity from ODI. Needs a seamless connectivity.
Often ODI Repository throws errors for various reasons and a restart of the jobs will fix the issue automatically. But it could be avoided in first place. Like PK Violation on ODI Variables.
ODI Agent time out errors. Need more work on High Availability. J2EE agents also fail to provide High Availability sometimes. Need a solution where at least one agent always works and balances connections on any intermittent network failures.
Likelihood to Recommend
When we need to work with different sources within the same project, we are able to integrate from the sources and load to the one target. When we need to validate multiple files and load the data immediately in a loop, a simple code does the trick via Oracle Data Integrator. Whoever needs to extract, transform and load from any source can go do that with Oracle Data Integrator.
Oracle Data Integrator was used along with Oracle Goldengate product to consolidate data into Oracle database from other data resources in other DBMS and ETL jobs. The data was integrated or converted into using target format using Oracle Data Integrator.
Pros
Converts data from various sources into one target format using various business logic rules and integrates with various DBMS types.
Transformed data from DB2, SQL Server and other Oracle databases into flat files and then used ETL jobs to load into Oracle DB target
Data Integrator and Goldengate were used together to accomplish the data movement needed for business and data consolidation in live environment. Data Integrator helped with development and in reducing lead time to convert data into target.
Cons
Still complex product to use for ETL developers. Needed lot of training and testing before it could be implemented in production data conversion.
Initial set up was resource intensive on machine and manpower used on this project.
Better GUI interface with less options should be designed for Big data integration tool.
Likelihood to Recommend
Well suited for data consolidation into data warehouse type of database from multiple sources in real time.
VU
Verified User
Employee in Information Technology (10,001+ employees)
It is being used in an organization that provides an online assessment platform, for which I work as a freelancer. Based on the unique E-LT architecture, the need for an ETL server sitting between the source and target server gets removed. Elimination of ETL server and ETL engine reduces the maintenance costs and thus reduced learning curve reduce the overall labor costs of the company. According to the current situation, Oracle Data Integrator supports RDBMSs such as Oracle, Sybase IQ, and Exadata.
Pros
It supports all platforms, hardware and OSs with the same software.
It utilizes the source and target server to perform complex transformations without the need of ETL server sitting between source and target server which makes architecture more simple and efficient.
Data Connectivity is very good as it supports all RDBMSs.
Cons
When you develop on ODI studio, you need to restart the program as it occupies a lot of RAM.
It is not meant for real time data integration.
It is hard to maintain the security setup.
Likelihood to Recommend
ODI data transformation capabilities are saving our development time as compared to previous projects.
In my organization, my department develops business intelligence solutions for our worldwide customers, whose business can be in any kind of sector. In this scenario, ODI is being used to integrate data among all the pieces of the software architecture, connecting Oracle and non-Oracle technologies.
In my 6 years experience, I used ODI to: - feed up relational environments, like Data Warehouses or Data Marts models with reporting purposes - feed up Hyperion Planning, Hyperion Essbase, Hyperion Financial Management or INFOR applications, for our customers' controllers - read data from Oracle and non-Oracle technologies (i.e.: SAP, SQL Server, INFOR, and many other), thanks to all ODI's connectors and interpreter - schedule tasks and workflow, independently from the operating system, thanks to ODI's agent (the service that controls all the tool's tasks).
ODI helps integrating data across different sources and targets, executing operating systems command, managing mistakes or discards, logging all the operations performed by the integration flows and scheduling those flows.
Pros
Is simple and easy to learn, thanks to the low number of development objects that it has (mainly: interfaces, procedures and packages, plus variables).
It allows you to integrate data from and to any kind of technology. This is a strong point since it's able to connect practically to any technology, Oracle and not.
It allows you to create integration flows that manage through steps on any task.
It provides both an automatic and a customizable management of integration mistakes.
If you feel stronger in developing through hard code, ODI allows you to integrate anything through procedures.
It supports almost any kind of developing language, like SQL, PLSQL, Java, Javascript, C#, and so on.
It's easy to backup, since it provides a native way to export all the developments but also its relational repositories (master and work) can be exported from the database where they reside.
Cons
The newest version (ODI 12c) has been released with some minor bug related to environment stability (i.e. connection loss).
After some time that you develop on ODI studio, you need to restart the program, since it tends to occupy a lot of RAM.
The ODI studio may need a machine with a lot of resources, otherwise it may become slow.
Likelihood to Recommend
Oracle Data Integrator is well suited in all the situations where you need to integrate data from and to different systems/technologies/environments or to schedule some tasks. I've used it on Oracle database (Data Warehouses or Data Marts), with great loading and transforming performances to accomplish any kind of relational task. This is true for all Oracle applications (like Hyperion Planning, Hyperion Essbase, Hyperion Financial Management, and so on).
I've also used it to manage files on different operating systems, to execute procedures in various languages and to read and write data from and to non-Oracle technologies, and I can confirm that its performances have always been very good.
It can become less appropriate depending on the expenses that can be afforded by the customer since its license costs are quite high.
