Oracle Data Integrator (ODI) Valuable Features
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 »Oracle Data Integrator is powerful, likely the most potent tool for data integration.
View full review »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 »Buyer's Guide
Oracle Data Integrator (ODI)
April 2024
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,740 professionals have used our research since 2012.
ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases. It automates processes with metadata, providing fast staging and building data marks. Despite some lag in development compared to newer tools, ODI remains powerful, facilitating quick integration, even across multiple companies within a corporate structure.
View full review »SB
SlavenBatnozic
CTO at Hammerknife
The tool improved our data integration workflow primarily due to its compatibility with Oracle. Its integration makes it very convenient for analytics. Its most valuable feature is robust extended capability. The solution's debugging capabilities are good.
View full review »BD
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 »The CAEM is very useful, particularly in its modularity and portability. We can also use real-time transformation to build and load data. It works more quickly than other ELTs and it's very simple and modular. It can be used for all integrations, not only AIT or ELT.
View full review »ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules.
View full review »PC
Prajith Chowthee
Independent Consultant at Unaikui
The most valuable feature is Data movement.
View full review »I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support.
View full review »It can extract all day. It doesn't look after any particular database. It is not platform-dependent, and that's the main thing that makes it really useful.
It has good plug-ins.
The studio was quite useful.
It was a user-friendly product.
The product is stable. It's scalable.
View full review »The most valuable feature of ODI is the to use of the whole ETL to create a data lake.
View full review »SN
reviewer1782720
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 »I will need to involve the integration team to elaborate on the features, as they can provide input. I work mostly on the functional-technical side. However, in Oracle Data Integrator, the governance, especially the service governance, is good. There is also a schedule-based data-pulling mechanism. The message-pulling mechanism in the solution is good, and we can define threshold limits on top of the services. For instance, if I publish some equipment gateway or email gateway, the end user can consume a specific number of services from the solution.
View full review »GO
Gurcan Orhan
Data Quality Software Development Manager at Yapı Kredi Bank
Flexibility, ease of customization, extensive features, ease of deployment, and the ability to access to all kinds of different source system technologies. No need for extra hardware for transformation step. Easy to learn & develop.
Now, ODI has Cloud Service which you can deploy your repositories to Oracle Data Integrator Cloud Service for you to use both on prem, Big Data and cloud environments.
Oracle Data Integrator (ODI) can support any type of databases that has a jdbc driver in a native way. I have accessed and retrieve data from an Ingress database. Big data connectors are implemented to ODI 11.1.1.7 (out-of-the-box) and upper version that support many well-known Big Data architecture.
Knowledge Module architecture helps you to build your data integration activities with less effort.
You can switch to source, staging area or target to improve your querying performance. If you have to do a join from different source systems, you can decide which data to move to where and figure out the place for best output.
Variables can help you to perform loops and conditional statements in packages for helping ETL
View full review »The most value feature of this product are the Knowledge Modules. Oracle Data Integrator comes with a comprehensive library of Knowledge Modules that helps automate the data flow, reduce the learning curve, and shorten the implementation time.
View full review »SM
reviewer2012175
DBA at a comms service provider with 201-500 employees
The product has an ELT approach. It is much faster than any other ETL.
RG
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 »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.
AS
AshokSharma
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 »AY
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.
The biggest feature for ODI is the fact that it uses the power of the source or target database to actually perform the ETL processing. So a typical data integration tool might have its own ETL engine, and that would be an additional server, additional costs, something else you have to maintain. ODI actually has the ability to create and generate code that runs potentially on your Oracle database, or even on a big data target, on Hadoop or somewhere like that. So, you have that flexibility, and you don't have to have that additional cost in maintenance.
A couple other additional benefits of Oracle Data Integrator would be the use of what's called a knowledge module. So this is like a code template that uses the metadata that you have available within ODI, and within your mapping, to generate that code, that then can be executed, like I said before, on the source or target system. The code will be generated in the native format of that database or that technology. So, again, you have sort of a hands-off.
These knowledge modules are built in. They can be developed and modified. So, the biggest thing, I always think, with ODI is, it fits around your data warehouse needs. Rather than taking your production, or your business, and trying to make it fit a tool, you do the opposite. You make the tool fit your business.
View full review »MJ
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 »MA
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 »The most important aspect of the product is the ability to work with almost any data source or target. I can readily develop processes that use relational, file, XML, JMS messaging, web and big data sources or targets.
I can control the style of integration through "knowledge modules", and if they don’t do exactly what I want. I can write my own or customize the Oracle supplied ones.
The ability to execute third-party (or in-house developed) Java code by installing JAR files allows a great deal of flexibility; for example, I can add custom processors to do access web APIs that use token based authentication.
Another key feature is that we do not need to pass our data through some form of ETL engine hosted on a server; in some cases for example transforming data within a data warehouse all of the processing is done in single SQL queries thus reducing network traffic.
Finally, the rich SDK supplied with ODI allows developers to create virtually any form of development or deployment automation.
View full review »ODI is integrated with Hyperion Planning, Essbase and other Oracle products. Data transfer is also easy since ODI already knows the metadata of these applications between the different databases. There is also ease of development in terms of the interface and customization with scripts, as well as data lineage and tracking, which are advantages to us.
View full review »The product separates business logic (data mapping) from how data moves from source to target. A Knowledge Module defines the steps to move data from an Oracle DB to SQL Server for example, leaving only the transformation logic for the developer to define. This results in an ability develop transformations more rapidly than say Informatica.
View full review »The ability to extract from multiple sources, the flexibility of using the Knowledge module, and the ergonomics of the GUI are the features I've found most valuable.
View full review »RK
Rüdiger KOch
Team Leader Development at Deutsche Bahn AG
The most valuable feature that we use is the Knowledge Modules.
View full review »The user interface for the data integrator tool is probably the most valuable piece. I'm a relatively newcomer to the ODI. We opted to use ODI instead of Informatica. Relatively, I do not have a lot experience with a lot of VARs, but I've been able to understand a lot more about the direction Oracle is heading through the tool. It was very intuitive. It helps to have a good background in data manipulation, but it's very intuitive and has given a good appreciation of what the tool can do.
View full review »The main features we use and has helped us to implement our ETL process are
- Data transformation
- In memory engine
- KM customization
- User friendly GUI
- Versioning
- Big Data support
- Security support
- Easy deployment
- Reusable Mapping
- Multiple Target Load
- ELT Architecture
- Application Server support for other vendor servers such as IBM Websphere
Provides us with a relational database.
View full review »The most valuable feature is that it's bundled with all the other Oracle products. We use the ODI with BI Apps. It does all the ELT along with our data warehouse for BI purposes. That’s good. It comes as a bundled package. If we want to use the newest, latest version, we can install it separately.
It's very user friendly. We used to use Informatica; compared to that, it's easier.
View full review »PB
Paolo Borghi
Oracle Business Intelligence Consultant at a tech consulting company with 51-200 employees
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.
View full review »RR
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 »This is a stable and comprehensive solution.
View full review »DB
David Barragan
Principal Owner at New Frontier Professionals LLC
Separate environments for dev, test and prod from one management facility.
It can do so much more than just load data. It can basically automate any task that you can think of, such a executing scripts for servers outside of your Oracle environment, executing any task that the IT team wishes to execute can be done via ODI. I created a button on a user’s machine once, this button executed only her job in ODI regardless of all the other jobs that were created. I love working with ODI because it tests your thought limits and creativity and the possibilities are endless when it comes to innovative tasks.
View full review »Their code-once-use-everywhere approach for coding data flows. Unlike other ELT solutions, ODI allows for creating scripts ("modules") which are then shared across multiple data load processes. If you find a bug, you fix it once, and it is fixed for everyone. It is the same if you need to code a new feature. It is also worth mentioning that ODI supports over a dozen of scripting languages. Chances are that your favorite language is amongst them.
View full review »The most valuable feature is being able to schedule the jobs, especially when they're multi-step.
View full review »The Knowledge Module is the most valuable feature in our experience with it.
View full review »I found nothing overly amazing about this tool, although I appreciate its ability to easily load slowly changing dimensions.
View full review »It is an ETL tool, which does the extract, transform, and load.
View full review »The ODI topology and designer are the most valuable features. The topology gives me total freedom in switching between technologies / ETL agents. The mapping designer gives me a good graphical overview of ETL mappings.
View full review »I'm not very comfortable with ODI, but it is one of the Oracle product that we use. I know the interfaces and that it's used for financials. The ODI client can be configured so that Excel data can automatically be pumped into Oracle Forms directly.
View full review »In my opinion the notable difference between ODI 10 and ODI 11 is the possibility to keep multiple interfaces open at the same time. This makes it very comfortable to work with. Another technical feature that I like, is the possibility to create a dataset. This is the Oracle set operator inside the interfaces such as UNION, INTERSECT, MINUS. It has a friendly interface where you can see all tools very clearly because the designer tab shows the operator, topology and security workflow together and you can access them at the same time without any problems.
View full review »- Direct infusion of statements to the database, which allows the full use of database capability
- Ease of creating data flow and transformation
- Flexibility on technology on transformation
The EL-T approach that will first load into the target dataserver before doing the transfer is a great architecture improvement compared to standard ETL tools that use a staging area and usually process the data in Java. With ODI, almost all the job is pushed down on the underlying technology, for instance the Oracle database or the Spark server.
The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance.
ODI is really the tool for any kind of integration because it speaks the language of the technology we connect. We can work with RDBMS but also in Hadoop, cloud services, flat files, web services, etc.
View full review »Heterogeneous technologies can be integrated with ODI, including the latest web services.
I feel that Oracle provides users with the best functionalities from ODI by constantly improving the functionalities in all areas.
It's highly flexible, and can interface with almost any technology. One of the best ETL tools.
View full review »MI
reviewer1258245
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 »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 »DW
Dava Wang(汪燊)
Data engineer at realestate.pingan.com
Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast.
View full review »It is a clever integration tool to extract data from every possible source, and it can transform the source data to a format the targets can handle. It is suitable for data warehouses and data migrations.
View full review »AP
Aslam Pasha
Assistant Manager at a integrator with 501-1,000 employees
I have found most of the Oracle Fusion middleware and hardware to be valuable.
View full review »ODI is a very accessible tool, especially since the mapping functionality has been added.
The ability to build integrations that process large amounts of data (in GBs), be it file transfers ,DB operations, and web service calls, etc.
View full review »RA
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.
It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases. Going forward, that is very important.
View full review »The possibilities provided by using knowledge modules and the integration with other Oracle products.
View full review »Strong and reliable ETL tool with high performance and helpful features
View full review »The most valuable features of ODI are the relatively comprehensive ELT features (i.e. execution of data transformation and validation processes), with scheduling.
View full review »
Oracle Data Integrator Enterprise Edition has advanced capabilities like loading slowly changing dimensions, complex data integration process flow logic, re-usable mappings and design-time automation through scripting.
Built-in dimensional modeling tools are included in Oracle Data Integrator to simplify Oracle Data Warehouse Integration.
Oracle Data Integrator ensures automatic detection and recycling of faulty data before insertion in the target application and is performed through data integrity rules and constraints defined both on the target application and in Oracle Data Integrator.
In order to ensure real-time data integration, Oracle Data Integration suite provides all key components required to enable real-time data warehousing and operational data hubs.
View full review »
The tool has a in-built "Knowledge Modules" using Oracle ADF, and this provides by default, all possible databases and technologies for data integration, such as file system, Oracle RDBMS, Teradata, and Microsoft SQL Server. This ensures that customers do not compromise their requirements and also falls within many companies budget and technical feasibility.
View full review »Buyer's Guide
Oracle Data Integrator (ODI)
April 2024
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,740 professionals have used our research since 2012.