Oracle Data Integrator (ODI) Review

One of the benefits of it is the usage of the principle ‘write once, execute anywhere’.

What is most valuable?

It is a clever integration tool to extract data from every possible source, and it can transform the source data to a format the targets can handle. It is suitable for data warehouses and data migrations.

How has it helped my organization?

We replaced many manual actions and tasks with mappings in Oracle Data Integrator, and created schedules, and then used SOA Suite services to automatically transfer large data amounts between different systems.

What needs improvement?

The integration between the Oracle Repository and versioning tools like TortoiseSVN.

For how long have I used the solution?

We’ve used 11G for four years, and 12.1.3 for two years.

What was my experience with deployment of the solution?

One of the benefits of it is the usage of the principle ‘write once, execute anywhere’. You set up the architecture in the topology within Oracle Data Integrator.

What do I think about the stability of the solution?

We've experienced no issues with performance.

What do I think about the scalability of the solution?

We haven't needed to scale it yet.

How are customer service and technical support?

We haven't needed to use it yet.

Which solution did I use previously and why did I switch?

Previously we used Oracle Warehouse builder, and custom made PL/SQL data warehouses. We’ve chosen Oracle Data integrator over other solutions because it is the successor of Oracle Warehouse builder, and Oracle Data Integrator provides a more structured working-method, and the data warehouse is easier to maintain.

How was the initial setup?

The installation is rather straightforward, with the available documentation it must be possible to do the installation by yourself. You must have sufficient knowledge of Oracle Data Integrator to make the correct decisions during the creation of the architectural setup.

What about the implementation team?

We used an in-house team but hired interim experts, and created a team with combined knowledge levels, from rooky to expert. The initial setup is rather complex, and needs an experienced architect to make the correct decisions. The change of success is highly depending on the decisions that are made during the setup.

What's my experience with pricing, setup cost, and licensing?

I have no info on the ROI or the licensing, but I know the license costs are high, so Oracle Data Integrator is only suitable for the larger companies.

What other advice do I have?

To benefit the most of Oracle Data Integrator it is important to assemble a team with the experience to make the project a success.

Which version of this solution are you currently using?

11G to 12.1.3.
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
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: May 2021.
510,204 professionals have used our research since 2012.
Add a Comment