2016-04-14T06:40:00Z

What needs improvement with Oracle Data Integrator (ODI)?

Julia Miller - PeerSpot reviewer
  • 0
  • 247
PeerSpot user
26

26 Answers

SM
Real User
Top 20
2023-11-28T13:39:06Z
Nov 28, 2023

The initial setup is a bit complex compared to other tools.

Search for a product comparison
Emad Mokhatab - PeerSpot reviewer
Real User
Top 20
2023-08-17T07:25:31Z
Aug 17, 2023

Stability could be improved because some operators have issues.

Miodrag Milojevic - PeerSpot reviewer
Real User
Top 5Leaderboard
2023-07-21T11:05:15Z
Jul 21, 2023

There is an automated method for handling errors in the load process. However, at present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly. This issue can be improved.

Hari Krishna Boddala - PeerSpot reviewer
Real User
Top 10
2023-03-14T10:12:23Z
Mar 14, 2023

In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release. Specifically, I'd like to see if the solution will support us in acquiring data from our databases.

Gurkan-Onay - PeerSpot reviewer
Real User
Top 20
2023-02-13T20:29:49Z
Feb 13, 2023

The initial setup could be easier and it would be helpful if they'd reduce licensing costs.

Abdou Mohamadou - PeerSpot reviewer
Real User
Top 5
2023-01-12T16:19:37Z
Jan 12, 2023

Reverse engineering is complicated when reversing from the database to the repository. It's pretty challenging to manage.

Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
Muharrem Iseri - PeerSpot reviewer
Real User
Top 5
2022-11-25T12:54:18Z
Nov 25, 2022

Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better.

Jagadish Sau - PeerSpot reviewer
Real User
Top 20
2022-10-31T15:02:05Z
Oct 31, 2022

An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations. Oracle Data Integrator (ODI) has features that support at least ninety percent of my organization, so it's only real-time integration that I'd like to see in the next release of the solution.

Samir Bhattarai - PeerSpot reviewer
Real User
Top 10
2022-10-18T08:37:16Z
Oct 18, 2022

The price needs to be lowered. It's too expensive. There are a few other tools that can do what Oracle does. It's not necessarily the leader in the space. As far as what I have learned from other people, I've heard that the Oracle console is big and confusing. If it was less complex, it would be easier to customize.

Swati-Singh - PeerSpot reviewer
Real User
Top 5Leaderboard
2022-09-06T12:26:39Z
Sep 6, 2022

ODI could improve the ease of use. There is a steep learning curve to use the solution.

Pujitha Gade - PeerSpot reviewer
MSP
Top 20
2022-04-30T18:29:12Z
Apr 30, 2022

It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us.

MI
Real User
2022-02-07T18:39:20Z
Feb 7, 2022

I think Oracle should add more functions to improve optimization. Automation should be improved to enhance the product. Some of our customers carry out data comparisons between Oracle and other features and Oracle is lacking in some of those tools and features.

SN
Real User
2022-02-15T17:12:53Z
Feb 15, 2022

ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use.

NM
MSP
2022-01-24T18:43:22Z
Jan 24, 2022

An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types.

AS
Real User
2021-11-18T08:59:58Z
Nov 18, 2021

The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects. One aspect I always struggle with is there's no single view to see which jobs are going to run or what time. You have to look around, it's very clunky. If you had a couple of agents, you can't see everything in one place. You have to go and look at an agent schedule and look at that, and then, go to another one to look. There's no single view that gives you the whole picture. What would be nice for us is, if ODI can easily integrate to GitHub, to allow us to have all our source code in GitHub rather than within ODI. This would be a very good feature, everyone is using GitHub.

MA
Real User
2020-10-28T13:43:06Z
Oct 28, 2020

The resource management aspect of the solution could be improved. The migration process could be easier. Technical support could be better. They're okay, however, their service could improve a bit. The solution could be more reliable.

MJ
Real User
2020-06-03T10:13:00Z
Jun 3, 2020

There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue. Error descriptions should be easy and specific to actual problems rather than generic lengthy descriptions. Also, another main feature that should be readily available is that there should be a source component available that can extract data from a source based on the custom query rather than giving a source data store only in the mapping.

RK
Real User
2019-07-12T20:52:00Z
Jul 12, 2019

The performance of the user interface is in need of improvement.

it_user1083117 - PeerSpot reviewer
Real User
2019-05-05T21:16:00Z
May 5, 2019

Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts.

RA
Real User
2019-01-24T16:35:00Z
Jan 24, 2019

* ETL process registry solution is missing. * To manage dependencies between loading packages. * Versioning logic and release process are not well supported.

DB
User
2018-11-25T02:07:00Z
Nov 25, 2018

* Click intensive on mapping * Lots of mouse clicking * GUI could be improved.

it_user911514 - PeerSpot reviewer
User
2018-08-02T16:51:00Z
Aug 2, 2018

It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses.

DW
Real User
2018-03-01T08:21:00Z
Mar 1, 2018

The ODI scheduler for agent sometime fails with no sign, which impact the ETL solution severely. The property window in the ODI studio always does not refresh as it should. Sometimes, the mapping or package automatically gets edited.

AY
Consultant
2016-05-04T06:03:00Z
May 4, 2016

There is always room for improvement, even when something is really good, but I think ODI is one of the best ETL tools in the market. However, I've always waited for the web service feature to be improved in next versions, so at last the 12C version the web service has been improved, some of the limitations of the 11g version were solved. Also, it would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons, although it looks like the cloud option offers some extra connectors (for example, in Salesforce CRM).

RG
Consultant
Top 5Leaderboard
2016-05-01T11:30:00Z
May 1, 2016

Right now, we have two very different GUIs - 11g and 12c. 11g is faster to develop than 12c as it takes more steps to do exactly the same as 11g, but you have a lot of things that you need to do yourself. 12c implemented some things for which you have to use some specialized code automatically, like parallel data load, but it is slower to develop. For me, the best thing would be to merge the GUI from 11g into the capabilities of 12c.

RR
Consultant
Top 20
2016-04-14T06:40:00Z
Apr 14, 2016

In my opinion, ODI should connect to ALL Oracle products out-of-the-box, but currently that’s not the case for all of them. Hyperion Financial Management (HFM) is one of the Oracle products for which Oracle decided to remove its ODI support in its last product version. In other words, if you wish to use ODI and HFM together, both from Oracle, you will need to create custom code, which does not make any sense to me. Another area to improve would be the development life-cycle, which did improve in the latest ODI version, but needs further improvements.

Oracle Data Integrator (ODI) is a data integration software solution that provides a unified infrastructure to streamline data and application integration projects. It uses a powerful design approach to data integration, which separates the declarative rules from the implementation details. The solution is based on a unique ELT (Extract Load Transform) architecture, eliminating the need for a standalone ETL server and proprietary engine.  Oracle Data Integrator Features ODI has many...
Download Oracle Data Integrator (ODI) ReportRead more