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-22 of 22)Companies can't remove reviews or game the system. Here's why
December 09, 2020
An Amazing ETL Tool!
This is very easy to integrate with Oracle data sources and as most of my databases are in oracle so I gave preference to this tool.
December 09, 2020
What i think about Oracle Data Integrator
December 04, 2020
Oracle Data Integrator is great for any ETL use cases
December 04, 2020
Oracle Data Integrator--a great tool for Oracle users
Oracle Data Integrator works very well if the rest of your systems are in the Oracle environment. There are some other good alternatives out there, but for what Oracle Data Integrator has to offer, it is good. It is also a little harder to use compared to the other ones I have seen (like Boomi, which is very easy to use and integrated with many systems).
May 25, 2020
Easily integrates data, but could perform better
We were using Actian Pervasive before switching to Oracle and the main reason was the cost. We were getting less functionality at even more cost. Although it is much faster in terms of operation, Oracle makes it easy to connect to all data sources making data integration easier as a result.
February 28, 2020
Oracle Data Integrator review
I have used the Pentaho Data Integrator ETL tools in different projects with the SQL Server Integration Services product from the Microsoft product family. Oracle Data Integrator ETL product is efficient in projects where Oracle databases are heavily used. The end-user interface of SQL Server Integration Services (SSIS) is quite simple and straightforward. It also has an active user community. You can find solutions in these communities for the problems you are experiencing. Since the Pentaho Data Integrator ETL is an open-source application, you can bring your ETL design costs to a very reasonable level. This project will contribute positively to your expenses.
January 19, 2020
Oracle Data Integrator Review
Powerful features and Oracle based
October 25, 2019
Oracle Data Integrator enthusiast!
Since our main databses are Oracle, we decided to use this tools. No other tools were evaluated (some research made, though).
September 18, 2019
ODI User Review
- Microsoft Dynamics 365 (formerly Microsoft Dynamics CRM)
I think that Oracle Data Integrator is much better because of the user interface it provides.
Chose Oracle Data Integrator for its compatibility and integration with Oracle Goldengate
November 14, 2017
Oracle Data Integration: A Data Connectivity tool
ODI is best suited for Oracle Hyperion environments. We have also used it to manage files on different operating systems.
November 07, 2017
Data Warehouse Architect's Review of Oracle Data Integrator
Because of variety of my projects that I involved, I used nearly all the world wide known tools within data warehouse environment.
- Data Modeling Tools : Sybase Power Designer, SQL Developer Data Modeler, ERwin Data Modeler.
- BI Tools: OBIEE, Cognos, Microstrategy, Business Objects, Qlikview, Tableau.
- ETL Tools: ODI, OWB, IBM Data Stage, SAP Data Services, Informatica, Microsoft SSIS, Pentaho, Talend.
June 22, 2017
ODI review by an integrator consultant
Talend Data Integrator has been evaluated during the setup of the architecture for a customer, in comparison to ODI, since it's an open source ETL. But, differently from the meaning of "open source", it has licence costs too that aren't that different from ODI ones. Moreover, the other components of the business intelligence architecture of the customer were Oracle, so we thought that ODI would suit at best with them, more than a different vendor software.
June 22, 2017
ODI: Flexibility, reusability and performance for data integration with various source and target technologies.
ODI is the naturel successor of OWB, adopting the same EL-T approach but supporting a lot more technologies as source and target. The overall product is much more stable and not tied to the Oracle Database.
Unlike Informatica, ODI generates all the code in the native underlying technologies used for source or target. This makes it easier to develop and usually faster to load.
Unlike Informatica, ODI generates all the code in the native underlying technologies used for source or target. This makes it easier to develop and usually faster to load.
November 23, 2016
Oracle Data Integrator - a natural migration from OWB
We migrated to ODI from OWB - and we found ODI to be light years ahead of OWB (features, performance, and connectivity). We also looked at Informatica, but were turned down by its cost. Being a SAP Business Objects shop, we also considered the SAP Data Integrator tool (it offers data lineage capability that could be very valuable) - but since our entire data platform is running on Oracle, we preferred staying with Oracle. Once ODI 12g came out with the OWB to ODI migration tool, it was a no-brainer.
November 21, 2016
Oracle Data Integrator - The real data integrator
- Informatica, Pentaho and Oracle Warehouse Builder
Oracle's own ETL tool was Oracle Warehouse Builder, initially. When Oracle built the Oracle Business Intelligence Applications Suite, Oracle is in need of a strong ETL. As Oracle Warehouse Builder is not a strong ETL that customers prefer and as already Informatica captured most of the ETL market, Oracle choose Informatica as it's ETL tool for Oracle Business Intelligence Applications Suite. In parallel, Oracle started developing it's own ETL tool which can replace Informatica in their OBIA Suite. The outcome is Oracle Data Integrator. Oracle Data Integrator is built keeping customers in mind and what customers are trying to achieve over the last decade. Though, OBIA 11g customers are now left with only one choice of ETL Tool - ODI, they love it for it's simplicity and light foot print. Pentaho on the other hand is not comparable to either ODI or Informatica. I mentioned it as I used it for a short period.
October 11, 2016
ODI – cost effective tool for integration purposes
We thought IBM was too expensive and more difficult to use. With Microsoft, since we have our main application running with Oracle DB, we understood it’d be easier for us to work with ODI.
August 03, 2016
Oracle Data Integrator - Complex tool for Data Movement
Oracle Data Integrator is a superior tool when dealing with Hyperion Planning and Essbase cubes and applications. The native connectors allow for easy data movement and transformations from one environment to the other. I do believe that Oracle Data Integrator is a very complex tool with a steep learning curve.
- Informatica
Informatica was slightly more intuitive but slightly less powerful than Oracle Data Integrator. My use of Informatica was much less extensive than Oracle Data Integrator, so I can not speak as in-depth about the strengths and weaknesses of Informatica. We used ODI much more for custom ETL while we used Informatica more for out-of-the-box solutions.
December 14, 2015
ODI - not necessarily an enterprise solution, but good enough for smaller financial systems implementations
- HAL, Informatica, Data Relationship Management and Hyperion Financial Data Management
ODI is less user friendly than FDM and DRM but is much easier to deploy than core ETL tools such as HAL or Informatica. The tool is easier to master and is usually more than capable of handling the run of the mill tasks required for Hyperion deployments. It has been a good middle road for deployments where an IT shop can manage small updates to SQL logic but does not want the full overhead of managing something like Informatica.
August 04, 2014
Only ETL tool I know that works the way it is claimed
IBM Infosphere, Informatica. I worked on the mentioned tools as well as ODI. I liked ODI because it is easy to use with great features that every other ETL tool has in the market.
July 29, 2014
ODI Review
Our organization was using the Oracle BPM and the Oracle Data Integrator has good integration with BPM. We got good support from Oracle in setting up the integrated environment.