Oracle Data Integrator (ODI)

Score6.2 out of 10

126 Reviews and Ratings

Community insights

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.

Reviews

29 Reviews

ODI Tool for Huge Data

Rating: 8 out of 10

Incentivized

June 4, 2021

Use Cases and Deployment Scope

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.

Ojas Elawadhi

Data Analyst in Information Technology at Paytm (5001-10,000 employees)

Vetted Review

2 years of experience

View profile

Oracle Data Integrator delivers for our company!

Rating: 7 out of 10

Incentivized

December 14, 2020

Use Cases and Deployment Scope

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.

Verified User

Administrator in Information Technology (1001-5000 employees)

Vetted Review

2 years of experience

An Amazing ETL Tool!

Rating: 9 out of 10

Incentivized

December 9, 2020

Use Cases and Deployment Scope

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.

Verified User

Employee in Information Technology (10,001+ employees)

Vetted Review

2 years of experience

What i think about Oracle Data Integrator

Rating: 8 out of 10

Incentivized

December 9, 2020

Use Cases and Deployment Scope

We use data integrator to handle large amount of data, bulk batch loads,use it for data transformation and integration with different platforms. We use this for our client request to fulfill their requirement. We are working in insurance industry in which lots of data from different sources needs to be handled. It solve our purpose to mange large volume of data from different sources.

Pros

Extract, transform and load the data
Work well with large volume of data
Use with multiple sources

Cons

Bit difficult to use as compare to other tools
Sometime feels slowness while working

Likelihood to Recommend

Efficiently work with different platforms but we should have deep knowledge of tool.

Lakhan Suri

SQL AND BI Developer in Information Technology at Carmen Solutions (11-50 employees)

Vetted Review

2 years of experience

View profile

Oracle Data Integrator is great for any ETL use cases

Rating: 8 out of 10

Incentivized

December 4, 2020

Use Cases and Deployment Scope

There are many products that do extract, transform, and load on data sets. It is a core task for any data engineer or data analyst. Alongside Oracle Cloud, we use Oracle Data Integrator to run ETL processes on our data. We use it widely to maintain our business intelligence systems.

Pros

High-volume, batch load ETL processes
Data transformations before data warehousing
Flexible big-data extractions

Cons

More easily used in other clouds/platforms
More features in UI
Updated flow of ETL processes in UI

Likelihood to Recommend

Oracle Data Integrator is well suited for any extract, transform, and load processes someone needs. It is very versatile and allows for even very large amounts of data to be uploaded and transformed. It is especially useful for big data transformations. Any cloud users will find this tool very useful.

Cameron Gable

Software Engineer III in Research & Development at Serimmune Inc. (11-50 employees)

Vetted Review

1 year of experience

View profile

Oracle Data Integrator--a great tool for Oracle users

Rating: 8 out of 10

Incentivized

December 4, 2020

Use Cases and Deployment Scope

Oracle Data Integrator is a very good ETL tool that can be used for many different business cases. We currently use it as an ETL application that ties into many of our backend systems. It helps us connect with many systems with the great integrations it has and gives us the ability to closely tie our data together. We use this for our data teams currently which then gets used for reports, etc. to make workflow and processes more streamlined.

Pros

It is well integrated within the Oracle ecosystem
Great product for data cleansing and virtualization
Can have everything done in one tool in most cases
It has great scalability/performance

Cons

Oracle support is not the best when needing help with the system
The documentation is also very poor and takes very long to generate
Some parts of it are not intuitive to use and get hard to troubleshoot
Like other Oracle products, you must have very, very thorough knowledge about their systems to understand
Like all Oracle products, cost is high

Likelihood to Recommend

Oracle Data Integrator is best used for data warehousing, master data management, data migration, big data integration, and application integration. If you have an environment that is in the Oracle platform, this tool also works great with it. We have been using it as an ETL tool to get data from the different Oracle systems we have, and it works great. However, it does not work great with different environments if you have multiple types of systems. You will find yourself buying more than one application to satisfy your needs.

Verified User

Manager in Engineering (51-200 employees)

Vetted Review

5 years of experience

Easily integrates data, but could perform better

Rating: 7 out of 10

Incentivized

May 25, 2020

Use Cases and Deployment Scope

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.

Verified User

Manager in Information Technology (10,001+ employees)

Vetted Review

2 years of experience

Outstanding addition to our Oracle JD Edwards Programs

Rating: 9 out of 10

Incentivized

January 30, 2020

Use Cases and Deployment Scope

We are currently using the Oracle Data Integrator in order to fully understand and visualize topological data. We find the visualizations are quite wonderful for presentations and has recently been used to identify issues in certain locations of our jobsite. I highly recommend plotting the data in the module as it has done wonders for our field staff. If you're have repeat issues in a certain location but have not been able to find the continuity along a dataset. I beg you to try using this module.

Pros

Visualization of data set
Organizing your staff's work in one central location

Cons

I find most Oracle products to lack ease of use. Oracle Data Integrator is no exception. I find that my older employees have a difficult time navigating the programs.
We have not been able to fully figure out all the customization of the Graphic designer modules. No-fault to Oracle Data Integrator there's just a lot.

Likelihood to Recommend

Let me put it this way. If you're already using an Oracle product, this is a no-brainer. These products are made to work with each other. Not only that, but if you're familiar with all the shortcuts and you're working with datasets that need visualizations, Oracle Data Integrator product masterfully incorporates large datasets into a visualizer. It by far the best I've seen to date.

Verified User

Engineer in Finance and Accounting (501-1000 employees)

Vetted Review

1 year of experience

Oracle Data Integrator review

Rating: 9 out of 10

Incentivized

January 29, 2020

Use Cases and Deployment Scope

Oracle Data Integrator is used in enterprise projects designed for data warehouse and ETL. It makes sense for us to use the ODI ETL product, especially since the databases we work with are usually oracle products. You can create individual ETL packages with the Oracle Data Integrator ETL product. You can schedule these ETL packets at certain time intervals. You can generate summary tables using aggregate functions in an Oracle Data Integrator product. In this way, you can create data march tables to be used in the data warehouse. The end-user interface of the Oracle Data Integrator product has an intricate appearance. The ETL design screen needs to be more straightforward and more user-friendly. Also, connections to databases other than Oracle can fail after certain periods of time.

Pros

There are enough aggregate functions to design a Data Warehouse. In this way, summary tables can be created.
Works compatible with Oracle databases. By making ODBC connections, database connections are made more stable.

Cons

The end user interface of Oracle Data Integrator ETL can be made simpler and more convenient.
Oracle external database connections are time out after a certain period of time. Therefore, data transfers can be disrupted.

Likelihood to Recommend

Oracle Data Integrator ETL product is efficient in projects where Oracle databases are heavily used. In the Oracle Data Integrator ETL tool, you can quickly transfer and transform data by connecting source and destination databases with ODBC. You can run your millions of data transfers separately by dividing them into multiple packages. This will give you performance results in data transfer operations. JSON can issue ODI ETL product errors with XML data or in oracle external databases. Sometimes the solution to these errors can cause serious time losses.

zahit bogus

Business Intelligence Consultant in Information Technology at EMO A.Ş (501-1000 employees)

Vetted Review

1 year of experience

Oracle Data Integrator Review

Rating: 8 out of 10

Incentivized

January 19, 2020

Use Cases and Deployment Scope

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.

Verified User

Professional in Information Technology (1001-5000 employees)

Vetted Review

5 years of experience

Loading Reviews List....

Oracle Data Integrator review

Rating: 9 out of 10

Incentivized

January 29, 2020

Use Cases and Deployment Scope

Pros

There are enough aggregate functions to design a Data Warehouse. In this way, summary tables can be created.
Works compatible with Oracle databases. By making ODBC connections, database connections are made more stable.

Cons

The end user interface of Oracle Data Integrator ETL can be made simpler and more convenient.
Oracle external database connections are time out after a certain period of time. Therefore, data transfers can be disrupted.

Likelihood to Recommend

zahit bogus

Business Intelligence Consultant in Information Technology at EMO A.Ş (501-1000 employees)

Vetted Review

1 year of experience