Oracle Data Integrator (ODI) Valuable Features

Brian Dandeneau
Business Process and Strategy Specialist Advisor at NTTData
The Knowledge Module (KM) is my favorite feature of ODI. This is where I learned how to use variables to make jobs dynamic. I took that knowledge and created a KM that would go into iTunes and pull the sales of eBooks. Making something that is reusable, like a KM, is important to not only reduce build time but also maintenance in the future. View full review »
Ricardo Giampaoli
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 »
Alan Yves
Big Data / Business Intelligence / Datawarehousing at DWgrain (Client Health BIS)
There are several very important features that we use daily. * All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration. * ODI is really powerful for BI projects with traditional star-schema loads. For example, we integrated Salesforce to an Oracle data warehouse with it.ODI is a platform agnostic, you may have any data source and any target to integrate and ODI will enable you to connect. * It facilitates real-time data replication from Microsoft SQL Server to an operational database sitting on Oracle Database. * It provides for legacy systems integration. It integrates any SQL server database. View full review »
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: January 2021.
456,719 professionals have used our research since 2012.
Muhammad Arif Javed
Senior Manager Software Development at Techlogix
There are number of valuable features in this tool: * Declarative design * Client-server architecture model. * Very good user access model * Pre-built user profiles defined that give you control for access management * Very good logging and execution logs feature which gives you complete detail of executions and you can query these in a different manner. 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. View full review »
Rodrigo Radtke De Souza
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 »
Mohamed Ahmed Fouad
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 »
Muhammad Tahir
Assistant Manager - MIS Analyst at TCS Private Limited
We can easily create ETL processes and schedules. We can check logs on a daily basis. It handles multiple routines very smartly. View full review »
Business677
Business Analyst at Paunaste OÜ
* Reusing existing ETL development pattern in the next similar tasks. * It's flexible to add new common procedures. * Knowledge modules can be modified to fix small issues. View full review »
Rüdiger KOch
Team Leader Development at DB Systel
The most valuable feature that we use is the Knowledge Modules. View full review »
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: January 2021.
456,719 professionals have used our research since 2012.