IT Central Station is now PeerSpot: Here's why

Oracle Data Integrator (ODI) Room for Improvement

Ricardo Giampaoli - PeerSpot reviewer
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at TeraCorp Consulting

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.

View full review »
AS
Applications Support Manager at a marketing services firm with 1,001-5,000 employees

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.

View full review »
Rodrigo Radtke De Souza - PeerSpot reviewer
Solutions Architect at a tech consulting company with 51-200 employees

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.

View full review »
Buyer's Guide
Oracle Data Integrator (ODI)
June 2022
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
610,190 professionals have used our research since 2012.
Mohamed Ahmed Fouad - PeerSpot reviewer
Banking Excellence - Predictive Analysis at a financial services firm with 11-50 employees

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.

View full review »
SN
Technical Lead at a computer software company with 10,001+ employees

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.

View full review »
Pujitha Gade - PeerSpot reviewer
Senior Plsql & ODI Developer at Infosys

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.

View full review »
MI
SAP Business One Project Manager at a consumer goods company with 11-50 employees

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.

View full review »
NM
Principal Consultant at a tech services company with 501-1,000 employees

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

View full review »
Buyer's Guide
Oracle Data Integrator (ODI)
June 2022
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
610,190 professionals have used our research since 2012.