Try our new research platform with insights from 80,000+ expert users
Oracle Data Integrator (ODI) Logo

Oracle Data Integrator (ODI) pros and cons

Vendor: Oracle
4.1 out of 5
3,913 followers
Post review
 

Oracle Data Integrator (ODI) Pros review quotes

AS
Nov 18, 2021
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.
PB
Aug 24, 2017
It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors.
AY
Mar 18, 2019
​All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
MJ
Jun 10, 2020
All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner.
Hari Krishna Boddala - PeerSpot reviewer
Mar 14, 2023
The solution's initial setup is straightforward, especially compared to Mule, which our team has worked with before and found to be a bit more complex in terms of setup.
Jagadish Sau - PeerSpot reviewer
Oct 31, 2022
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.
Samir Bhattarai - PeerSpot reviewer
Oct 18, 2022
It's scalable.
Henry Niessen - PeerSpot reviewer
Apr 4, 2024
ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases.
Swati-Singh - PeerSpot reviewer
Sep 6, 2022
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.
MA
Oct 28, 2020
The scalability is great. It's one of the reasons we chose the solution.
 

Oracle Data Integrator (ODI) Cons review quotes

AS
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.
PB
Aug 24, 2017
I would only point out some minor bugs or glitches in the development interface (ODI studio).
AY
Mar 18, 2019
It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
MJ
Jun 10, 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.
Hari Krishna Boddala - PeerSpot reviewer
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.
Jagadish Sau - PeerSpot reviewer
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.
Samir Bhattarai - PeerSpot reviewer
Oct 18, 2022
The price needs to be lowered. It's too expensive.
Henry Niessen - PeerSpot reviewer
Apr 4, 2024
ODI could improve by focusing on streamlining its features without unnecessary overhead.
Swati-Singh - PeerSpot reviewer
Sep 6, 2022
ODI could improve the ease of use. There is a steep learning curve to use the solution.
MA
Oct 28, 2020
The resource management aspect of the solution could be improved.