TrustRadius
Oracle has about 3,500 data integration customer and competes with Informatica, IBM InfoSphere, Talend and SAS DatFlux.https://dudodiprj2sv7.cloudfront.net/product-logos/Iz/j5/I7MQHBPIP9K1.PNGOracle Data Integrator - used for data consolidation and integration project.Oracle Data Integrator was used along with Oracle Goldengate product to consolidate data into Oracle database from other data resources in other DBMS and ETL jobs. The data was integrated or converted into using target format using Oracle Data Integrator.,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.,9,Lead time to complete data integration and transformation project was reduced due to Oracle Data Integrator tools that helped in setting up transformations relatively quickly once it was set up. Reduced lead time helped in reducing project cost as less resources were spent in data conversion project. Overall data consolidation project resulted in quick integration of data from varied DBMS and data sources.,Dallas Oracle Users Group,IBM ClearQuest,IBM ClearQuestData Warehouse Architect's Review of Oracle Data IntegratorOracle 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.,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.,10,It made a tremendous job, all the developers across the organisation learnt ODI rapidly and started to develop. ODI became the strategic ETL tool and data integration tool for my company.,Independent Oracle User Group ODTUG Colombia Oracle Users Group Costa Rica Java User Group Ecuador Java User Group Grupo de Usuarios Oracle El Salvadore Oracle User Group Guatemala Oracle User Group Mexico Panama Oracle User Group Azerbeidzjan Oracle User Group Bulgarian Oracle User Group Oracle Gebruikersclub Holland Oracle User Group Finland Oracle User Group Norway Romanian Oracle User Group Slovenian Oracle User Group (SIOUG) Spain Oracle User Group TROUG Turkish Oracle User Group UK Oracle User Group All India Oracle User Group,Informatica Enterprise Data Integration, Oracle Warehouse Builder, SQL Server Integration Services and BusinessObjects Data Integrator,Oracle Warehouse Builder, SAP Data Services, SQL Server Integration Services, Informatica Master Data Management, Informatica Enterprise Data Integration, IBM InfoSphere Warehouse,50,50,Loading Data Warehouse Performing Data Quality Scheduling On the fly incremental update for different database technologies Fully customized depending on the business needs.,Connecting and receiving data from very very old database management systems. Calling operating system routines to output for OLTP tasks.,Enhancements in multiuser development environment,10ODI review by an integrator consultantIn my organization, my department develops business intelligence solutions for our worldwide customers, whose business can be in any kind of sector. In this scenario, ODI is being used to integrate data among all the pieces of the software architecture, connecting Oracle and non-Oracle technologies.In my 6 years experience, I used ODI to: - feed up relational environments, like Data Warehouses or Data Marts models with reporting purposes - feed up Hyperion Planning, Hyperion Essbase, Hyperion Financial Management or INFOR applications, for our customers' controllers - read data from Oracle and non-Oracle technologies (i.e.: SAP, SQL Server, INFOR, and many other), thanks to all ODI's connectors and interpreter - schedule tasks and workflow, independently from the operating system, thanks to ODI's agent (the service that controls all the tool's tasks).ODI helps integrating data across different sources and targets, executing operating systems command, managing mistakes or discards, logging all the operations performed by the integration flows and scheduling those flows.,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.,9,It's a quite expensive product, and its costs can be absorbed in some time, but it grants stability and great flexibility. It can be used as a main tool to integrate data on different platforms and purposes, granting a greater Return on Investment by limiting the expenses on other more specialized products.,Talend Data Integration,Oracle Database, SQL Developer, Toad for OracleOracle Data Integration: A Data Connectivity toolIt is being used in an organization that provides an online assessment platform, for which I work as a freelancer. Based on the unique E-LT architecture, the need for an ETL server sitting between the source and target server gets removed. Elimination of ETL server and ETL engine reduces the maintenance costs and thus reduced learning curve reduce the overall labor costs of the company. According to the current situation, Oracle Data Integrator supports RDBMSs such as Oracle, Sybase IQ, and Exadata.,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.,8,It is quite an expensive product. It has allowed us to move metadata more efficiently. It can be used to integrate data on different platforms and for different purposes.,Oracle Database,Oracle Database, Agile CRMODI: Flexibility, reusability and performance for data integration with various source and target technologies.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.,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.,9,Thanks to the flexbility of the tool, we could build 3 mappings using variables and the substitution API in replacement of 300 mappings in Oracle Warehouse Builder. It's much easier to maintain.,Oracle Warehouse Builder and Informatica Enterprise Data Integration,Oracle BI Foundation Suite, Oracle Database
Unspecified
Oracle Data Integrator
92 Ratings
Score 7.8 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

Oracle Data Integrator Reviews

Oracle Data Integrator
92 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.8 out of 101
Show Filters 
Hide Filters 
Filter 92 vetted Oracle Data Integrator reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role
Reviews (1-15 of 15)
  Vendors can't alter or remove reviews. Here's why.
No photo available
December 13, 2018

Review: "Oracle Data Integrator - used for data consolidation and integration project."

Score 9 out of 10
Vetted Review
Verified User
Review Source
Oracle Data Integrator was used along with Oracle Goldengate product to consolidate data into Oracle database from other data resources in other DBMS and ETL jobs. The data was integrated or converted into using target format using Oracle Data Integrator.
  • 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.
Well suited for data consolidation into data warehouse type of database from multiple sources in real time.
Read this authenticated review
Gurcan Orhan profile photo
November 07, 2017

"Data Warehouse Architect's Review of Oracle Data Integrator"

Score 10 out of 10
Vetted Review
Verified User
Review Source
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.

  • 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.
  • 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.
Read Gurcan Orhan's full review
Paolo Borghi profile photo
June 22, 2017

Oracle Data Integrator: "ODI review by an integrator consultant"

Score 9 out of 10
Vetted Review
Verified User
Review Source

In my organization, my department develops business intelligence solutions for our worldwide customers, whose business can be in any kind of sector. In this scenario, ODI is being used to integrate data among all the pieces of the software architecture, connecting Oracle and non-Oracle technologies.

In my 6 years experience, I used ODI to:
- feed up relational environments, like Data Warehouses or Data Marts models with reporting purposes
- feed up Hyperion Planning, Hyperion Essbase, Hyperion Financial Management or INFOR applications, for our customers' controllers
- read data from Oracle and non-Oracle technologies (i.e.: SAP, SQL Server, INFOR, and many other), thanks to all ODI's connectors and interpreter
- schedule tasks and workflow, independently from the operating system, thanks to ODI's agent (the service that controls all the tool's tasks).

ODI helps integrating data across different sources and targets, executing operating systems command, managing mistakes or discards, logging all the operations performed by the integration flows and scheduling those flows.

  • 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.

Oracle Data Integrator is well suited in all the situations where you need to integrate data from and to different systems/technologies/environments or to schedule some tasks. I've used it on Oracle Database (Data Warehouses or Data Marts), with great loading and transforming performances to accomplish any kind of relational task. This is true for all Oracle applications (like Hyperion Planning, Hyperion Essbase, Hyperion Financial Management, and so on).

I've also used it to manage files on different operating systems, to execute procedures in various languages and to read and write data from and to non-Oracle technologies, and I can confirm that its performances have always been very good.

It can become less appropriate depending on the expenses that can be afforded by the customer since its license costs are quite high.

Read Paolo Borghi's full review
Ashwini Chandorkar profile photo
November 14, 2017

Oracle Data Integrator Review: "Oracle Data Integration: A Data Connectivity tool"

Score 8 out of 10
Vetted Review
Verified User
Review Source
It is being used in an organization that provides an online assessment platform, for which I work as a freelancer. Based on the unique E-LT architecture, the need for an ETL server sitting between the source and target server gets removed. Elimination of ETL server and ETL engine reduces the maintenance costs and thus reduced learning curve reduce the overall labor costs of the company. According to the current situation, Oracle Data Integrator supports RDBMSs such as Oracle, Sybase IQ, and Exadata.
  • 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.
ODI data transformation capabilities are saving our development time as compared to previous projects.
Read Ashwini Chandorkar's full review
Jérôme Françoisse profile photo
June 22, 2017

Oracle Data Integrator Review: "ODI: Flexibility, reusability and performance for data integration with various source and target technologies."

Score 9 out of 10
Vetted Review
Verified User
Review Source
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.

  • 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.
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.
Read Jérôme Françoisse's full review
Ely Turkenitz profile photo
November 23, 2016

Review: "Oracle Data Integrator - a natural migration from OWB"

Score 8 out of 10
Vetted Review
Verified User
Review Source
We have a large data warehouse that consolidates data from three different case management systems. We use Oracle Data Integrator (ODI) as the primary ETL tool for transporting the data into the data warehouse. Prior to ODI, we used Oracle Warehouse Builder (OWB) for Oracle databases and Microsoft SSIS for SQL Server databases. ODI replaced them both. We found ODI to be a very powerful, full-feature ETL tool, and it's lightning fast, too.
  • 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.
Well, if you are an Oracle shop, then ODI is clearly a very good choice. It is a much better tool than OWB has ever been; it is lightning fast (which really comes handy when you have to transform massive amount of data), and it gives Informatica a run for its money. It [has the] ability to support heterogeneous databases, big data, JMS, XML, and many other flavors.
Read Ely Turkenitz's full review
Federico Shortrede profile photo
October 11, 2016

Oracle Data Integrator Review: "ODI – cost effective tool for integration purposes"

Score 7 out of 10
Vetted Review
Verified User
Review Source
We’re currently using Oracle Data Integrator for integration purposes between legacy systems and eBS, and also to populate a couple of data marts from information in Oracle.
  • 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.

Oracle Data Integrator (ODI) is great for integration between different Oracle data bases, and it also works well taking data from sources like Excel or SQL Server.

We’re not so sure about ODI’s performance when origins are “very far away”, for instance, in different servers connected through an MPLS, or between one “on premise” server with another “cloud server”. But perhaps it is due to lack of knowledge.

Read Federico Shortrede's full review
James Parks profile photo
June 15, 2016

Review: "Oracle Data Integrator Experience as an IT Consulant for a Government Agency"

Score 7 out of 10
Vetted Review
Verified User
Review Source
Oracle Data Integrator is used to extract data from various manufacturing machines, transform it into a usable form, and load it into a data warehouse for use by Oracle Business Intelligence reports. In this case, it was used to attempt a "real-time data warehousing solution," which is not necessarily its intended operation. Data was provided every hour, as required by the client. It was used across the whole organization to help with various decisions, including but not limited to manufacturing quality, resource tracking, accountability, and equipment usage.
  • 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.
Oracle Data Integrator is a good solution for daily data warehousing needs. It is less suitable for business requirements that demand frequent data updates. Accessing static data with Oracle Data Integrator is much simpler than trying to extract, transform, and load dynamic data. It requires a skilled development team to use, so it is more appropriate in long term solutions where a team will be available to manage the code than it is for a short term solution.
Read James Parks's full review
Carlos Sanz Porro profile photo
September 20, 2016

Oracle Data Integrator Review: "Seamlessly connect different sources"

Score 9 out of 10
Vetted Review
Verified User
Review Source
We are currently using ODI for large companies that have the need to generate and consolidate information, move data, transform and consolidate data.

The great quality of ODI, is that it is able to connect to any database and source (xml , txt, SOZ ) both source and target. ODI is all possible, we have not seen in the position of a customer asks us something that ODI can not do . Thanks to that we can modify its core, we can do anything.

ODI allows the multidisciplinary development, its own versioning, and integration with any language (Python , Groovy , t - SQL).
  • 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.
Oracle Data Integrator (ODI) is recommended when you want to move data from heterogeneous sources. Also the multidisciplinary development is appropriate because when an object is being used, it appears locked by another user. ODI is a mature tool on the market.

A developer without advanced knowledge of SQL, can easily use the tool and generate complex queries against the database.
Read Carlos Sanz Porro's full review
Samir Patel, PMP profile photo
August 03, 2016

Review: "Oracle Data Integrator - Complex tool for Data Movement"

Score 5 out of 10
Vetted Review
Verified User
Review Source
Oracle Data Integrator is being used to move meta data from our repository that sits in SQL Server to the Hyperion Planning application. It is being utilized by our Finance department and it allows them to use the planning application efficiently to create budget and forecast information for the current year.
  • 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 best suited for Oracle Hyperion environments. When it comes to moving data to essbase and planning cubes, Oracle Data Integrator is the best tool for the job since the connectors are built in. SSIS for example is limited in this regard and could not accomplish the same task.
Read Samir Patel, PMP's full review
Peter Shepherd profile photo
December 14, 2015

Oracle Data Integrator Review: "ODI - not necessarily an enterprise solution, but good enough for smaller financial systems implementations"

Score 6 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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.
  • 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.
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.
Read Peter Shepherd's full review
No photo available
November 21, 2016

Review: "Oracle Data Integrator - The real data integrator"

Score 8 out of 10
Vetted Review
Verified User
Review Source
Oracle Data Integrator (ODI)is a powerful ETL tool. We use this across the organization to integrate data from various sources (mainly Peoplesoft) and load the processed data into Oracle Data Warehouse. The Data Warehouse loaded by ODI acts as a single source of truth for every department within the organization. All the department's raw data is pulled by ODI and processed before loading into Data Warehouse. Though this is a backend tool, which many front end users are not aware of its existence, it does a great job integrating data from different sources.
  • 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.
I tried various ETL tools and here is [where and] why I recommend Oracle Data Integrator.
1. When you want to process structured data from different databases - Teradata, Exadata, DB2, SQL, Oracle etc.
2. Oracle Data Integrator supports all platforms, hardware, and OS. This is a major advantage compared to other leading tools.
3. The ELT architecture giving a cutting edge performance over leading ETL tools. There is no need to align Oracle Data Integrator between source and target. ODI uses the source and target servers to perform complex transformations.
4. Speeds up the development and maintenance by reducing the code that developers need to write.
Read this authenticated review
No photo available
April 29, 2015

Oracle Data Integrator Review: "My days with ODI"

Score 9 out of 10
Vetted Review
Verified User
Review Source
Its been used as part of the Integration team. The tool is used to move data between any two systems. It helps moving large volumes of data among systems in batch mode.
  • You need not worry about technology, it basically supports anything under the sun which has a JDBC or ODBC driver.
  • Has enough key metrics (KMs) that come with the tool, that we can change and customize it as required to the organization.
  • It supports batch loads to most databases which improves time and efficiency.
  • Its not like other ETL tools where it resides on its own world. The transformations happen on the either the source or target and we can use what best suits the technology we are working on.
  • It does not have all bells and whistles. Needs more integration with Mainframe.
  • Currently it does not have any KMs that load binary files in batch mode to any database.
  • There can be lot of change to the UI, which are normal stuff.
It is best suited for large volumes of data in batch mode.
Read this authenticated review
No photo available
July 29, 2014

Oracle Data Integrator: "ODI Review"

Score 5 out of 10
Vetted Review
Verified User
Review Source
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.
  • Incremental data loads
  • Complex Transformations
  • Detailed documentation of LKM/IKM
  • Troubleshooting of failed jobs
  • More user friendly interface
  • Hierarchy flattening transformations
  • Integration issues with SAP HANA
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.
Read this authenticated review
No photo available
August 04, 2014

Oracle Data Integrator Review: "Only ETL tool I know that works the way it is claimed"

Score 10 out of 10
Vetted Review
Verified User
Review Source
ODI is used in our team to deliver Data warehouse reporting data.
  • ELT functionality to improve the performance of the data load
  • Able to work with different rdbms and file structures without any issue.
  • Adaptability to learning the tool and implementing the projects required by the company.
  • The GUI or ODI studio has Garbage Collector problems like freezing up if used for a long time without closing the studio.
  • ODI 12c has got it, but 11g has a restriction in terms of loading data into multiple targets in the same interface.
The whole knowledge of how ODI works and what customizations can be done using ODI's key metrics. Some key questions to ask are:
Which objects do what in ODI?
How are objects migrated between different environments?
How are agents set up and what are their uses? How do you schedule scenarios?
What different types repositories does ODI use?
Read this authenticated review

Feature Scorecard Summary

Ease of building user interfaces (1)
7.3
Scalability (1)
8.2
Platform management overhead (1)
6.4
Workflow engine capability (1)
8.2
Platform access control (1)
7.3
Development environment creation (1)
7.3
Development environment replication (1)
7.3
Issue monitoring and notification (1)
6.4
Issue recovery (1)
6.4
Upgrades and platform fixes (1)
6.4

About Oracle Data Integrator

Oracle Data Integrator offers High-Performance Bulk Data Movement and Data Transformation
It promises to deliver unique next-generation, extract load and transform (ELT) technology that improves performance and reduces data integration costs—even across heterogeneous systems.
-ELT architecture for improved performance and lower TCO
-Heterogeneous platform support for enterprise data integration
-Knowledge modules for optimized developer productivity and extensibility
-Service-oriented data integration and management for SOA environments

Webcast
Increase Productivity and Innovate with Extreme Performance Data Integration

Oracle Data Integrator Competitors

Oracle Data Integrator Technical Details

Operating Systems: Unspecified
Mobile Application:No