Oracle Data Integrator (ODI) Archived Reviews (More than two years old)
- Highest Rating
- Lowest Rating
- Review Length
Jan 28 2018
The enhanced security model and debugger are nice new features while the new layout is an advantage and disadvantage
What do you think of Oracle Data Integrator (ODI)?The new release of Oracle Data Integrator (ODI 12c) is now available. Let´s find out what the new features of ODI12c are that this version includes. First, is there anything fancy in the installation process? Just one note here: to be able to use ODI Studio, the enterprise installation needs to be selected (instead of the Standalone option) while launching the ODI installation program. For the configuration part, creating a new login to ODI repository you are requested to specify a new wallet password. ODI12c provides you with a possibility to store your credentials in a wallet that is protected by a password. How much it helps to protect and manage your credentials with a single password! Goodbye Interfaces, Welcome Mappings First of all, we do not deal with…
Aug 25 2017
With the Knowledge Modules, we're able to create our own reusable integration strategies for connecting to RDBMS, Hadoop, cloud services, etc.
What is most valuable?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… more»
How has it helped my organization?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!
What needs improvement?- Development Lifecycle - native REST integration - Easier security
Which solution did I use previously and why did I switch?I used Oracle Warehouse Builder (OWB) which is now at the end of its life. ODI is much more flexible and has the great advantage to be able to connect to a lot of different source or target technologies.
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
417,803 professionals have used our research since 2012.
Aug 24 2017
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.
What is most valuable?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.
How has it helped my organization?My organization develops solutions using all the Oracle EPM products, and ODI has helped us to integrate all the different technologies.
What needs improvement?I think that the product as an overall solution is good. I would only point out some minor bugs or glitches in the development interface (ODI studio), but I do not think that any of them are worthy to… more»
What's my experience with pricing, setup cost, and licensing?Being an ODI developer, I never had to pay for this product. I know that the pricing/licensing is not really low, but the product is really good.
What other advice do I have?Always keep in mind that ODI offers a huge number of solutions to any task you are developing. There is not a best practice in solving a problem; being able to identify the best solution for your… more»
Which other solutions did I evaluate?I tried many integration tools, both Oracle and other vendors. I think that ODI is one of the most complete and open solutions, since it can work with almost any technology and it gives you the… more»
Mar 24 2017
A tool that can talk or learn how to talk, with any database or operating system in its own language.
What is most valuable?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… more»
How has it helped my organization?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… more»
What needs improvement?They need to work on the multiuser development environment and include the ability to comply with different kinds of SDLCs.
What's my experience with pricing, setup cost, and licensing?There are various options in licensing, either per seat or per target core count. It depends how you want to use it.
Which solution did I use previously and why did I switch?We switched because of ODIs impressive increasement in development productivity.
What other advice do I have?If you want a robust, flexible solution with no extra hardware that is easy to learn, then ODI is the right product for you. ODI is a tool, that can talk or learn how to… more»
Which other solutions did I evaluate?We also looked at Informatica Power Center, AbInitio, Business Objects Data Integrator (BODI), and SQL Server Integration Services (SSIS).
Oct 31 2016
What is most valuable?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… more»
What needs improvement?One thing that is included, and it's going to improve, is the integration with a configuration management tool. Right now, they integrate with Subversion. And we know in the future, there's going to be more tools implemented there for… more»
Which solution did I use previously and why did I switch?A lot of the projects I've worked on recently are Oracle VM apps projects. So, it's the folks that are in the Informatica version of VI apps, and looking at moving to the latest and greatest, which has Oracle Data Integrator behind the… more»
What other advice do I have?So I would rate ODI a nine. And that's really because, just looking across the other ETL tools, so I mentioned Informatica, there's a lot of other ones out there. I've seen what ODI does from a sort of a declarative design approach, and the… more»
Which other solutions did I evaluate?As far as why consider Oracle Data Integrator, I think the big thing is the ability to consolidate all of your ETL into one place. Whether it's an Oracle to Oracle, source to target load, or even Oracle to Hadoop, or anything in between… more»
Sep 28 2016
I can readily develop processes that use relational, file, XML, JMS messaging, web and big data sources or targets.
What is most valuable?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… more»
How has it helped my organization?It allows a single skill set to handle virtually all of the data transport and transformation needs of a company. It moves the ETL processing to where the data resides and saves network traffic and… more»
What needs improvement?There needs to better support of external version control software, currently only SVN is present, but I hear the GIT is planned in future patch. From a DevOps point of view it would be useful to add… more»
What's my experience with pricing, setup cost, and licensing?The licensing model has changed a few times over the years - read the Oracle price list or speak to sales.
Which solution did I use previously and why did I switch?As an independent consultant, I work with other ETL products, and switching is requirement of my employers. However, of the products I used recently (Informatica and Talend), I feel ODI gives me the… more»
What other advice do I have?Plan your ODI infrastructure, especially where data is transformed to ensure you get the best balance between license costs and performance. Get your developers trained in best practices so that avoid… more»
Jun 09 2016
The features that we have applied to our project have helped to reduce manual effort and increase our scalability.
What is most valuable?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… more»
How has it helped my organization?The features that we have applied to our project has helped us reduce manual effort and increased our scalability and growth. I worked on multiple domains where requirements were adversely different… more»
What needs improvement?I am personally satisfied with current version, however, I think they should be able to provide a feature where we can easily use a configuration tool for TFS, GIT etc. This is essential for code… more»
What's my experience with pricing, setup cost, and licensing?It is not as costly as other ETL tools.
Which solution did I use previously and why did I switch?I have not used any other product. However, I have seen other ETL tools in use such as BODS, SOA, and Informatica and I did not like them as I did not that they were user friendly.
What other advice do I have?You should use Oracle Data Integrator for your data transformation, or at the very least give it a try.
Jun 01 2015
What do you think of Oracle Data Integrator (ODI)?
What is most valuable?Strong and reliable ETL tool with high performance and helpful features
What needs improvement?Enhance export/import features and add more features (I think they enhanced it in the 12c version)
For how long have I used the solution?More than 3 years 11g and now start working with 12c.
What was my experience with deployment of the solution?Export/import isn't stable and they don't have a clear behavior.
What do I think about the scalability of the solution?No issues.
Which solution did I use previously and why did I switch?Developed a project on SSIS (SQLServer Integration Services), and used to write ETL in scripts (PL/SQL).
How was the initial setup?Straightforward set-up.
What is Oracle Data Integrator (ODI)?
Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services. Oracle Data Integrator (ODI) 12c, the latest version of Oracle’s strategic Data Integration offering, provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate.
ODI12c further builds on its flexible and high-performance architecture with comprehensive big data support and added parallelism when executing data integration processes. It includes interoperability with Oracle Warehouse Builder (OWB) for a quick and simple migration for OWB customers to ODI12c. Additionally, ODI can be monitored from a single solution along with other Oracle technologies and applications through the integration with Oracle Enterprise Manager 12c.
Also known asODI
Oracle Data Integrator (ODI) customers
Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University