TrustRadius Insights for Oracle Data Integrator (ODI) are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
User-Friendly Interface: Reviewers have consistently praised the simplicity and user-friendliness of the interface, making it easy to navigate and utilize efficiently. The neat and clean design enhances the overall user experience, with users finding it particularly intuitive for extracting, transforming, and loading data.
Abundance of Transformation Options: Many users have highlighted the wide range of transformation options available, which significantly aids in completing tasks effectively and efficiently. These diverse options cater to different data handling needs, allowing users to work with large volumes of data from multiple sources seamlessly.
Scalability and Performance: The scalability and performance of the product have been commended by reviewers for handling high-volume batch load ETL processes and providing flexibility with big-data extractions. Users appreciate the top-notch scalability that enables them to tackle complex data integration tasks within one efficient tool.
Loading Reviews List....
Oracle Data Integrator (ODI) Reviews
9 Reviews
Mid-sized Companies (51-1,000 employees)
Search is temporarily unavailable. Filters are still applied.
Oracle Data Integrator is a very good ETL tool that can be used for many different business cases. We currently use it as an ETL application that ties into many of our backend systems. It helps us connect with many systems with the great integrations it has and gives us the ability to closely tie our data together. We use this for our data teams currently which then gets used for reports, etc. to make workflow and processes more streamlined.
Pros
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
Cons
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
Likelihood to Recommend
Oracle Data Integrator is best used for data warehousing, master data management, data migration, big data integration, and application integration. If you have an environment that is in the Oracle platform, this tool also works great with it. We have been using it as an ETL tool to get data from the different Oracle systems we have, and it works great. However, it does not work great with different environments if you have multiple types of systems. You will find yourself buying more than one application to satisfy your needs.
We are currently using the Oracle Data Integrator in order to fully understand and visualize topological data. We find the visualizations are quite wonderful for presentations and has recently been used to identify issues in certain locations of our jobsite. I highly recommend plotting the data in the module as it has done wonders for our field staff. If you're have repeat issues in a certain location but have not been able to find the continuity along a dataset. I beg you to try using this module.
Pros
Visualization of data set
Organizing your staff's work in one central location
Cons
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.
Likelihood to Recommend
Let me put it this way. If you're already using an Oracle product, this is a no-brainer. These products are made to work with each other. Not only that, but if you're familiar with all the shortcuts and you're working with datasets that need visualizations, Oracle Data Integrator product masterfully incorporates large datasets into a visualizer. It by far the best I've seen to date.
VU
Verified User
Engineer in Finance and Accounting (501-1000 employees)
Oracle Data Integrator is used in enterprise projects designed for data warehouse and ETL. It makes sense for us to use the ODI ETL product, especially since the databases we work with are usually oracle products. You can create individual ETL packages with the Oracle Data Integrator ETL product. You can schedule these ETL packets at certain time intervals. You can generate summary tables using aggregate functions in an Oracle Data Integrator product. In this way, you can create data march tables to be used in the data warehouse. The end-user interface of the Oracle Data Integrator product has an intricate appearance. The ETL design screen needs to be more straightforward and more user-friendly. Also, connections to databases other than Oracle can fail after certain periods of time.
Pros
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.
Cons
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.
Likelihood to Recommend
Oracle Data Integrator ETL product is efficient in projects where Oracle databases are heavily used. In the Oracle Data Integrator ETL tool, you can quickly transfer and transform data by connecting source and destination databases with ODBC. You can run your millions of data transfers separately by dividing them into multiple packages. This will give you performance results in data transfer operations. JSON can issue ODI ETL product errors with XML data or in oracle external databases. Sometimes the solution to these errors can cause serious time losses.
Oracle Data Integrator (ODI)is probably the best ETL tool in the market. We use it in order to integrate data from several different sources (mainly Oracle and SQL Server) and load the processed data into our Data Warehouse, applying some basic data quality rules (not the main function of ODI, but it has some small data quality features).
Pros
Complex transformations.
Compatibility with almost any knows valid source.
Suited for batch loading processes.
Cons
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.
Likelihood to Recommend
Oracle Data Integrator (ODI) is a top choice when you want to integrate data from different and/or heterogeneous sources (any known database and a lot of types of valid files). Not suitable if you don't have well qualified IT professionals in your company since it is a complex tool.
I think that Oracle Data Integrator is effective in terms of keeping a database of financial information and it is also helpful since it connects with financial tools such as Hyperion. I utilize hyperion to pull data from Oracle Data Integrator and use that as a leverage to build a company's financial projections. However, I think one big issue is that it can be quite slow during busy times. I think speed is one of the most essential things for the monthly close process.
Pros
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
Cons
Speed can sometimes be very slow.
You need many technical support individuals to maintain.
N/A
Likelihood to Recommend
Oracle Data Integrator is a great tool to use when you do detailed financial planning and analysis. You can create multiple scenarios. For example, you can create best case, reasonable case, and worst case scenarios on Hyperion and use that to understand different scenarios in order to hedge for risk in your forecast.
VU
Verified User
Analyst in Finance and Accounting (201-500 employees)
Oracle Data Integrator (ODI) enabled us to assist our customers loading their data warehouse and get insights from their data both in batch mode or in real-time. We helped customers in various fields: finance, gambling, telecom, transportation, education etc.
Pros
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.
Cons
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.
Likelihood to Recommend
ODI can access a large range of technologies as source or target so it's suited for most of the loadings. For efficient change data capture and streaming, I would recommend other tools for the ingestion part though, like Oracle Golden Gate and Apache Kafka which are dedicated to that. File processing is not that easy in ODI so if it's your main use case you might want to look at another tool.
Oracle Data Integrator (ODI) is used to integrate applications, bulk data movement and of course to load a data warehouse environment.
ODI helped me to reduce a slowly changing dimension type 2 with the same output, from 22,000 seconds to 168 seconds. [I] Manage to load 10.000+ files to a table from 1000+ different sources under 20 minutes with approximate 300 GB of data per day.
Pros
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.
Cons
They need to work on the multiuser development environment and include the ability to comply with different kinds of SDLCs.
Likelihood to Recommend
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. What else do you need?
It helped me to reduce a slowly changing dimensions type 2 with the same output, from 22,000 seconds to 168 seconds.
Loaded 10.000+ files to a table from 1000+ different sources under 20 minutes with approximate 300GB of data per day.
In my prior role, I primarily used ODI as the ETL tool to transform data from relational systems or flat files into Hyperion Essbase. It was also the extraction tool from Essbase to various data marts/warehouses. ODI was used to map multiple source files/tables together, transform the data appropriately to align with Essbase nomenclature/naming conventions. ODI was also used as a scheduling tool to kick off command-line utilities specific to the Hyperion toolset and to manage interdependent data processing jobs for a given organization.
Pros
Transforms and loads large amounts of data (gigabyte and up).
Stores complex transformation logic in an understandable way that is easily updated after the fact.
Managed multiple ETL user groups/credentials to segment data availability and execution pathways.
Cons
ODI has a very arduous process for migrating components from one environment to another. I've found it to be error prone unless migrating a full schema which is not always a viable option.
ODI has no web-based administration panel, all admin tasks must be handled via hard install.
The scheduler tool is difficult to initially set up and not intuitive to manage. Takes a while to stand up properly.
Likelihood to Recommend
Oracle Data Integrator (ODI) is good when large amounts of data are to be processed and the ETL logic is maintained by a team of IT professionals. Where it loses out against other tools, is it cannot be managed by the data owner (i.e. finance) as the tool relies on SQL logic which is not always understood by the data owner. Coupled with the fact that it is not managed via the web but through hard install, it makes it difficult to diffuse ETL tasks from IT to the core business.
Oracle Data Integrator was used to pull the Oracle BPM data into data mart. It was being used across the whole organization. It pulled the data from various sources and pushed it to a single source with very complex transformations. Master and incremental data was being loaded into the data warehouse.
Pros
Incremental data loads
Complex Transformations
Detailed documentation of LKM/IKM
Troubleshooting of failed jobs
Cons
More user friendly interface
Hierarchy flattening transformations
Integration issues with SAP HANA
Likelihood to Recommend
For simple transformation and small business it is very good ELT tool but if you look for the big business and the complex transformation it has gaps to fill for example Hierarchy flattening jobs or multi language translation jobs etc. will make this tool good to use in big organizations.
VU
Verified User
Team Lead in Information Technology (501-1000 employees)
