Oracle Data Integrator (ODI) Reviews

We are moving data from everywhere to everywhere else all the time. We will be moving data to a cloud solution in the future and ODI seems to be able to do it as well.

The tool is declarative, and it only runs on the target staging databases, so I have full control over it and I can change the SQL that the tool generates. I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly.

It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases. Going forward, that is very important.

When I do a BI type of project, I like to pick the simplest declarative solution that I can find. So ODI appeals to me at a base solution level, but that sometimes puts a lot of burden on me personally to fix all of the nuances of the platform that I am integrating to and from. Some might argue this is just a part of the job, but if there is an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it provides me value. I can see a great deal of value of ODI plus an add-on solution that might know how to avoid performance issues on the target database with, for example, the proper use of SQL functions.

Less than one year.

The possibilities provided by using knowledge modules and the integration with other Oracle products.

The old fashion PL/SQL codes have been translated into ODI, improving the way of maintenance. Several developers can work on the same project easily.

The software is developed on Java so it is very hardware dependent. You will need enough hardware to run the software otherwise you will struggle with it.

I've been using it for the last four years.

There were no issues with the deployment.

When developing on huge internal repositories, the performance is often quite poor.

It's been able to scale for our needs.

I have managed to solve my questions/issues via OTN or forums.

I haven't used any other products.

The first time might look a bit complex but using the right documentation it should be easy to handle.

It was already implemented on the projects where I have worked.

I didn't look at any other similar products.

Strong and reliable ETL tool with high performance and helpful features

Enhance export/import features and add more features (I think they enhanced it in the 12c version)

More than 3 years 11g and now start working with 12c.

Export/import isn't stable and they don't have a clear behavior.

No issues.

Developed a project on SSIS (SQLServer Integration Services), and used to write ETL in scripts (PL/SQL).

Straightforward set-up.

Go ahead it is a very good, stable and reliable product. 

The most valuable features of ODI are the relatively comprehensive ELT features (i.e. execution of data transformation and validation processes), with scheduling.

In our experience with ODI, we've found that the best use of it was with the development of our data warehouse.

There are a couple areas for improvement. First, it needs better error handling (i.e. messages, debugging). Second, it also needs the ability to perform more complex interfaces (i.e. multiple sources to targets).

I've used it for over a year.

There have been no issues with the deployment.

We have had no issues with the stability.

There have been no issues scaling it for our need.

In our experience, technical support is just average.

It is relatively complex for a first-time setup. There is a need to set up separately the RCU configuration of agents, and there's definitely a learning curve to this.

We implemented with our in-house team.

 Oracle Data Integrator Enterprise Edition has advanced capabilities like loading slowly changing dimensions, complex data integration process flow logic, re-usable mappings and design-time automation through scripting.  Built-in dimensional modeling tools are included in Oracle Data Integrator to simplify Oracle Data Warehouse Integration.  Oracle Data Integrator ensures automatic detection and recycling of faulty data before insertion in the target application and is performed through data integrity rules and constraints defined both on the target application and in Oracle Data Integrator.  In order to ensure real-time data integration, Oracle Data Integration suite provides all key components required to enable real-time data warehousing and operational data hubs.

 As with any big tool, truly mastering ODI may take months.

 Oracle Data Integrator separates the declarative rules from the implementation details. It can run entirely within a Service Oriented Architecture. ODI is the most integrated ETL product for running data integration as a service, accessing web services and writing to web services as a target.

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.

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.

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.

We have had no issues with the deployment.

There have been no performance issues.

It's been able to scale for our needs.