Oracle Data Integrator (ODI) Review

The tool has a in-built "Knowledge Modules" using Oracle ADF which supports all possible databases for data integration.

Valuable Features:

The tool has a in-built "Knowledge Modules" using Oracle ADF, and this provides by default, all possible databases and technologies for data integration, such as file system, Oracle RDBMS, Teradata, and Microsoft SQL Server. This ensures that customers do not compromise their requirements and also falls within many companies budget and technical feasibility.

Improvements to My Organization:

We had a customer whose core business was a logistics suite. ODI was used for their reporting purpose in some key BI reports such as "Container Load Plan (CLP) Reports", "Master Data Management Reports", "Business Partner Reports - Non Shipper Reports ", "Customer Consignee Details Reports". The customers requirements were delivered by using OTM (Oracle Transportation Management) as the Source OLTP System by us. We were also able to integrate ODI with their transactional system and therefore, we generated the reports through an ETL & data warehousing model. Due to this, the customer was able to get a deep-dive insight into their business performance across the south-east Asian logistics industry.

Room for Improvement:

Although we're satisfied with its overall performance in terms of integrity, scalability, and usability, it could be improved by including a separate UI for viewing the session runs through the operator layer of ODI. They could also reduce the complexity of having to move between tabs in the same window.

Deployment Issues:

We have had no issues with the deployment.

Stability Issues:

There have been no performance issues.

Scalability Issues:

It's been able to scale for our needs.

**Disclosure: My company has a business relationship with this vendor other than being a customer: We are a service provide for the product and have a Diamond level partnership with the vendor due to the level and number of solutions we have delivered to varying customers across industries.
More Oracle Data Integrator (ODI) reviews from users
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: June 2021.
511,773 professionals have used our research since 2012.
Add a Comment
ITCS user