IT Central Station is now PeerSpot: Here's why

Oracle Data Integrator (ODI) Valuable Features

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

It's the best tool for data integration. It can do anything you want, but the only downside is that you need to know what you are doing. You can take 10 times longer to do the same thing if you don't know how to use the tool.

You have to know how to change the KM, how to use the dynamic coding, how to create dynamic models, and so on. In a lot of places, I see people using ODI wrongly, but the good thing about the tool is that isn't hard to fix common mistakes. With this you can improve performance, and in some cases, more than 10 times.

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

The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful.

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

ODI has the ability to connect to virtually any technology out there. If it does not connect out-of-the-box, we can very easily add a new technology into it. This flexibility gives a tremendous developmental advantage to its users, which can use ODI as the official ETL tool for any kind of integration project.

Its Knowledge Modules (KMs) may abstract the “how” portion of integrations, allowing the users to focus on the “what” that needs to be done. It can be easily used by either young ETL developers or expert professionals.

For resumes, the ease of use for young professionals and its great development flexibility for expert professionals make it a great product to be used for every ETL project out there.

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,812 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 integration of the solution with Oracle is very good. It's nice and easy.

The scalability is great. It's one of the reasons we chose the solution.

The stability is okay.

We found the implementation to be quick and easy.

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

ODI's most valuable features are it utilizes the database engine and is very lightweight.

ODI's ability to connect multiple types of database environments from a particular server, place, or system is beneficial. I can connect to many databases, such as Dev, UAT, production, or user acceptance test databases. All together in only one place. It's all about changing the context in that particular application. The moment you change the context, the ODI will start processing the data from different environments altogether.

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

Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application.

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

The best feature of this solution is the documentation. Everything is set out clearly with step-by-step instructions.  

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,812 professionals have used our research since 2012.