ODI Tool for Huge Data
We use this Data Integrator tool to handle ETL(Extract, Transform and Load) part of large volume of data to fulfil our stakeholder …
Overview
What is Oracle Data Integrator (ODI)?
Oracle Data Integrator is an ELT data integrator designed with interoperability other Oracle programs. The program focuses on a high-performance capacity to support Big Data use within Oracle.
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
- Connect to traditional data sources (11)9.999%
- Complex transformations (11)9.999%
- Simple transformations (11)9.999%
- Business rules and workflow (11)9.191%
Pricing
N/A
Unavailable
What is Oracle Data Integrator (ODI)?
Oracle Data Integrator is an ELT data integrator designed with interoperability other Oracle programs. The program focuses on a high-performance capacity to support Big Data use within Oracle.
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
10 people also want pricing
Alternatives Pricing
N/A
Unavailable
What is SolarWinds Task Factory?
According to the vendor, SolarWinds Task Factory saves time managing tedious ELT/ETL tasks with high-performing SQL Server Integration Services (SSIS) components that can be used within the Visual Studio environment to connect to nearly any data source. Task Factory’s components and tasks have been…
What is Dataloader.io?
Dataloader.io delivers a cloud based solution to import and export information from Salesforce.
Product Demos
Oracle Data Integrator(ODI)|| Oracle Data Integrator Strategy
YouTube
Oracle Data Integrator(ODI) || ODI XML to DataBase Part-1
YouTube
Oracle Data Integrator(ODI) demo video | ODI Tutorials
YouTube
Oracle Data Integrator(ODI)|| ODI Interview questions
YouTube
ODI INTRODUCTION Demo: RR ITEC, Hyderabad, India
YouTube
Oracle Data Integrator(ODI) || Introduction
YouTube
Features
Return to navigation
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is Oracle Data Integrator (ODI)?
Oracle Data Integrator offers Bulk Data Movement and Data Transformation. It offers extract load and transform (ELT) technology that operates even across heterogeneous systems.
Features include :
Features include :
-ELT architecture
-Heterogeneous platform support for enterprise data integration
-Knowledge modules for optimized developer productivity and extensibility
-Service-oriented data integration and management for SOA environments
Oracle Data Integrator (ODI) Video
What is Oracle Data Integrator?
Oracle Data Integrator (ODI) Competitors
Oracle Data Integrator (ODI) Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
Oracle Data Integrator is an ELT data integrator designed with interoperability other Oracle programs. The program focuses on a high-performance capacity to support Big Data use within Oracle.
IBM InfoSphere Information Server, Talend Data Fabric, and Informatica Cloud Data Integration are common alternatives for Oracle Data Integrator (ODI).
Reviewers rate Connect to traditional data sources and Simple transformations and Complex transformations highest, with a score of 9.9.
The most common users of Oracle Data Integrator (ODI) are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(125)Attribute Ratings
Reviews
(1-25 of 29)Companies can't remove reviews or game the system. Here's why
June 04, 2021
ODI Tool for Huge Data
- The User Interface is pretty neat and clean which is very easy to use.
- There are a lot of transformation options available to choose from.
- The scalability and performance are top notch.
- The cost part is bit high as compared to its peers.
- Sometimes there is a lag and it gets hanged.
- Real time data Integration cannot be handled.
December 14, 2020
Oracle Data Integrator delivers for our company!
- Integration with other Oracle products.
- Install/documentation was easy to understand for interfaces/utility use.
- Consistent results, does what we need it to do.
- Oracle Support is not always the quickest to resolve ODI issues.
- Specifically with the OUA extractors, the install/documentation was lacking.
December 09, 2020
An Amazing ETL Tool!
- It is very easy to integrate with Oracle data sources at backend.
- Plenty of transformation options and reverse engineering is bit easier.
- The interface is very simple and user friendly.
- Real time integration is bit of a hassle.
- Customer Support could be improved to some extent.
- Data ingestion with variety of data sources could be difficult to implement.
December 09, 2020
What i think about Oracle Data Integrator
- Extract, transform and load the data
- Work well with large volume of data
- Use with multiple sources
- Bit difficult to use as compare to other tools
- Sometime feels slowness while working
December 04, 2020
Oracle Data Integrator is great for any ETL use cases
- High-volume, batch load ETL processes
- Data transformations before data warehousing
- Flexible big-data extractions
- More easily used in other clouds/platforms
- More features in UI
- Updated flow of ETL processes in UI
December 04, 2020
Oracle Data Integrator--a great tool for Oracle users
- It is well integrated within the Oracle ecosystem
- Great product for data cleansing and virtualization
- Can have everything done in one tool in most cases
- It has great scalability/performance
- Oracle support is not the best when needing help with the system
- The documentation is also very poor and takes very long to generate
- Some parts of it are not intuitive to use and get hard to troubleshoot
- Like other Oracle products, you must have very, very thorough knowledge about their systems to understand
- Like all Oracle products, cost is high
May 25, 2020
Easily integrates data, but could perform better
- With Oracle Data Integrator, we get platform independence as it supports a wide range of platforms.
- The FCP makes it easy to administer infrastructure and visualize data flows.
- It is cost-effective.
- I think it still has a lot of work to do in terms of speed of access and operation. That is why it rates a "7 out of 10" for me.
- The quality of support can also be improved.
- It can take longer than usual to generate documentation.
- Generated code can also be complicated even for technical users.
February 28, 2020
Oracle Data Integrator review
- There are enough aggregate functions to design a Data Warehouse. In this way, summary tables can be created.
- Works compatible with Oracle databases. By making ODBC connections, database connections are made more stable.
- The end user interface of Oracle Data Integrator ETL can be made simpler and more convenient.
- Oracle external database connections are time out after a certain period of time. Therefore, data transfers can be disrupted.
January 30, 2020
Outstanding addition to our Oracle JD Edwards Programs
- Visualization of data set
- Organizing your staff's work in one central location
- I find most Oracle products to lack ease of use. Oracle Data Integrator is no exception. I find that my older employees have a difficult time navigating the programs.
- We have not been able to fully figure out all the customization of the Graphic designer modules. No-fault to Oracle Data Integrator there's just a lot.
January 19, 2020
Oracle Data Integrator Review
- One of the most powerful ways to run your design-time in various environments.
- Run-time artifacts in various environments.
- Difficult to use
- Deep technical knowledge is needed
October 25, 2019
Oracle Data Integrator enthusiast!
- Complex transformations.
- Compatibility with almost any knows valid source.
- Suited for batch loading processes.
- Small bugs related to Java.
- The user interface is not intuitive.
- The complexity of the tool makes difficult to find qualified people in the market.
- Expensive.
September 19, 2019
Oracle Data Integration (ETL for Huge Data)
- It has a graphical environment which is easy to understand
- Lightweight designer which is very easy to view and edit the objects with ease
- All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.
- It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are depreciated simply for commercial reasons, although it looks like the cloud option offers some extra connectors.
- It is not very good for real time data integrations.
September 18, 2019
ODI User Review
- They connect to financial tools such as Hyperion.
- Holds financial data very well and easily retrieved when needed.
- All the support teams are very helpful and there when you need them
- Speed can sometimes be very slow.
- You need many technical support individuals to maintain.
- N/A
September 18, 2019
Heterogeneous Technologies in play with Oracle Data Integrator
- Leveraging the abilities of Target Database for transformations and computation
- Unique ability to integrate with heterogeneous sources works well.
- An application developer does not need to worry much about error handling like pl/SQL Developers have to do
- Need improvements in ease of access to the user interface
- Need to worry about whether all the required jar files are available or not for any new connection of any new technology.
- Each new technology has its own approach to establish the connectivity from ODI. Needs a seamless connectivity.
- Often ODI Repository throws errors for various reasons and a restart of the jobs will fix the issue automatically. But it could be avoided in first place. Like PK Violation on ODI Variables.
- ODI Agent time out errors. Need more work on High Availability. J2EE agents also fail to provide High Availability sometimes. Need a solution where at least one agent always works and balances connections on any intermittent network failures.
- Converts data from various sources into one target format using various business logic rules and integrates with various DBMS types.
- Transformed data from DB2, SQL Server and other Oracle databases into flat files and then used ETL jobs to load into Oracle DB target
- Data Integrator and Goldengate were used together to accomplish the data movement needed for business and data consolidation in live environment. Data Integrator helped with development and in reducing lead time to convert data into target.
- Still complex product to use for ETL developers. Needed lot of training and testing before it could be implemented in production data conversion.
- Initial set up was resource intensive on machine and manpower used on this project.
- Better GUI interface with less options should be designed for Big data integration tool.
November 14, 2017
Oracle Data Integration: A Data Connectivity tool
- It supports all platforms, hardware and OSs with the same software.
- It utilizes the source and target server to perform complex transformations without the need of ETL server sitting between source and target server which makes architecture more simple and efficient.
- Data Connectivity is very good as it supports all RDBMSs.
- When you develop on ODI studio, you need to restart the program as it occupies a lot of RAM.
- It is not meant for real time data integration.
- It is hard to maintain the security setup.
November 07, 2017
Data Warehouse Architect's Review of Oracle Data Integrator
- ODI is a tool that can talk or learn how to talk, with any database or operating system in its own language, this is the power of ODI!
- I managed to connect to an Ingress Database, within 3 days of time (it is not supported out of the box).
- When a new version of source and/or target database supports new data types, it takes my 5 minutes to implement it into ODI and immediately start using it.
- 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. It takes your 3 days to learn ODI and be an "intermediate ODI Developer", if you know how to write SQL.
- Big data connectors are implemented since 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.
- They need to work on the multiuser development environment and include the ability to comply with different kinds of SDLCs.
June 22, 2017
ODI review by an integrator consultant
- Is simple and easy to learn, thanks to the low number of development objects that it has (mainly: interfaces, procedures and packages, plus variables).
- It allows you to integrate data from and to any kind of technology. This is a strong point since it's able to connect practically to any technology, Oracle and not.
- It allows you to create integration flows that manage through steps on any task.
- It provides both an automatic and a customizable management of integration mistakes.
- If you feel stronger in developing through hard code, ODI allows you to integrate anything through procedures.
- It supports almost any kind of developing language, like SQL, PLSQL, Java, Javascript, C#, and so on.
- It's easy to backup, since it provides a native way to export all the developments but also its relational repositories (master and work) can be exported from the database where they reside.
- The newest version (ODI 12c) has been released with some minor bug related to environment stability (i.e. connection loss).
- After some time that you develop on ODI studio, you need to restart the program, since it tends to occupy a lot of RAM.
- The ODI studio may need a machine with a lot of resources, otherwise it may become slow.
June 22, 2017
ODI: Flexibility, reusability and performance for data integration with various source and target technologies.
- 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.
- Continuous integration is missing and would be a really nice feature to enforce a good development lifecycle.
- Better handling of files and folders, to be able to easily go through all the files of a folder.
- Security setup is not easy to maintain.
November 23, 2016
Oracle Data Integrator - a natural migration from OWB
- It's fast. If you have used OWB before, you will notice how much faster ODI is.
- The Knowledge Modules (KMs) are extremely useful.
- Integrates really well with the rest of the Oracle Technology Stack (GoldenGate, WebLogic, OEM, and, of course, the Oracle Enterprise Database).
- In ODI 12c, Oracle added a migration tool for OWB clients. It works, but not as well as we thought. We knew we would have to recreate the process flow - but then some of our OWB scripts didn't migrate well - and we ended up spending a lot more time than we initially thought [while] going through the entire migration.
- The installation isn't trivial. It took us a while to figure out which components need to reside where, how WebLogic fits in, and how to set it all up.
- The Oracle training for ODI is outrageously expensive - over 4K for a 5-day class.
November 21, 2016
Oracle Data Integrator - The real data integrator
- Oracle Data Integrator nearly addresses every data issue that one can expect. Oracle Data Integrator is tightly integrated to the Oracle Suite of products. This is one of the major strengths of Oracle Data Integrator. Oracle Data Integrator is part of the Oracle Business Intelligence Applications Suite - which is highly used by various industries. This tool replaced Informatica ETL in Oracle Business Intelligence Applications Suite.
- Oracle Data Integrator comes with many pre-written data packages. If one has to load data from Excel to Oracle Database, there is a package that is ready available for them - cutting down lot of effort on writing the code. Similarly, there are packages for Oracle to SQL, SQL to Oracle and all other possible combinations. Developers love this feature.
- Oracle Data Integrator relies highly on the database for processing. This is actually an ELT tool rather than an ETL tool. It first loads all the data into target instance and then transforms it at the expense of database resources. This light footprint makes this tool very special.
- The other major advantage of Oracle Data Integrator, like any other Oracle products, is a readily available developer pool. As all Oracle products are free to download for demo environments, many organizations prefer to play around with a product before purchasing it. Also, Oracle support and community is a big advantage compared to other vendors.
- The Java framework does not stand up to the mark. It crashes frequently. There is a long [list] of improvements required in terms of client tools framework.
- Though Oracle Data Integrator lets people login from a web browser to monitor different activities, it crashes and performs very poorly when logged in out of network. Even Oracle Data Integrator client tools don't perform well on a remote desktop. Increasing Java buffer is one of the workarounds, that might work. So, a better client tools and interface is a big advantage.
- Navigation is another pain area. It is very difficult to find out the precise error, in case of a failure, in Oracle Data Integrator. In Informatica, it is a cake walk to pull out a session log that shows up the exact reason for failure. Although Oracle Data Integrator is tightly integrated to database, it is very poor in providing the exact error at high level. One has to dig through to get it.
October 11, 2016
ODI – cost effective tool for integration purposes
- For us, it is particularly good for batch loading processes, because it is quite easy to connect different sources.
- Great for ETL processes, since it allows you to extract data from very different sources, perform some transformation, and load it to your final system.
- It was not difficult for our technical team to learn and adopt the tool.
- The main problem for us is that, from time to time, and for reasons we still were unable to discover, ODI loses the connection, and integration processes fail.
- I think there’s some room to improve the controlling of this process, but I don’t think they will perfect ODI in this way because Oracle has other licensed tools.
September 20, 2016
Seamlessly connect different sources
- It connects to any source (database, files, web services) and target.
- Modify the logic of SQL with knowledge modules.
- Easy development.
- The product sometimes have small bugs, which are fixed with patches.
- Very complex queries are difficult to do in graphics mappings
- It has functionality versions but can not develop in parallel a same object.
August 03, 2016
Oracle Data Integrator - Complex tool for Data Movement
- Has many different source and destination connectors
- Manages workflow for data movement
- Many options in the data transformation toolbox
- Error handling is quite complicated
- Very cumbersome user interface
- Too much complexity makes easy jobs harder to maintain
- Oracle Data Integrator is a very powerful tool. The graphical user interface simplifies the generation of complex SQL statements which can be used to extract and transform large amounts of data.
- ODI allows users to structure and schedule packages of code. It allows you to combine data extraction and transformation sequences based on business area, relationships, or whichever design technique best suits your organization.
- ODI is able to provide detailed logging information and send out alerts via email, simplifying the process of monitoring and debugging issues.
- ODI does not have an intuitive user interface. It is powerful, but difficult to figure out at first. There is a significant learning curve between usability, proficiency, and mastery of the tool.
- ODI contains some frustrating bugs. It is Java based and has some caching issues, often requiring you to restart the program before you see your code changes stick.
- ODI does not have a strong versioning process. It is not intuitive to keep an up to date repository of versioned code packages. This can create versioning issues between environments if you do not have a strong external code versioning process.