Oracle Data Integrator (ODI) Pros

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 »
Jagadish Sau - PeerSpot reviewer
Technical lead at a transportation company with 10,001+ employees
What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company.
View full review »
Samir Bhattarai - PeerSpot reviewer
Manager- Application and Cloud Services at a tech services company with 501-1,000 employees
It's scalable.
View full review »
Buyer's Guide
Oracle Data Integrator (ODI)
November 2022
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
656,862 professionals have used our research since 2012.
Swati-Singh - PeerSpot reviewer
Assistant consultant at Tata Consultancy
The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module.
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.
View full review »
Suruj  Nawosah - PeerSpot reviewer
Head of ICT at AfrAsia Bank Limited
The most valuable feature of ODI is the to use of the whole ETL to create a data lake.
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
Oracle provides great documentation.
View full review »
NM
Principal Consultant at a tech services company with 501-1,000 employees
Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support.
View full review »
MiodragMilojevic - PeerSpot reviewer
Senior Data Archirect at Telenor
ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules.
View full review »

Oracle Data Integrator (ODI) Cons

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.
View full review »
Jagadish Sau - PeerSpot reviewer
Technical lead at a transportation company with 10,001+ employees
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.
View full review »
Samir Bhattarai - PeerSpot reviewer
Manager- Application and Cloud Services at a tech services company with 501-1,000 employees
The price needs to be lowered. It's too expensive.
View full review »
Buyer's Guide
Oracle Data Integrator (ODI)
November 2022
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
656,862 professionals have used our research since 2012.
Swati-Singh - PeerSpot reviewer
Assistant consultant at Tata Consultancy
ODI could improve the ease of use. There is a steep learning curve to use the solution.
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 »
Suruj  Nawosah - PeerSpot reviewer
Head of ICT at AfrAsia Bank Limited
We used a third party to do the implementation of ODI.
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
The solution lacks some functions 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 »
MiodragMilojevic - PeerSpot reviewer
Senior Data Archirect at Telenor
The initial setup is complex, especially if you also have to install a console.
View full review »
Buyer's Guide
Oracle Data Integrator (ODI)
November 2022
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
656,862 professionals have used our research since 2012.