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.
Oracle Data Integrator delivers for our company!
An Amazing ETL Tool!
What i think about Oracle Data Integrator
Oracle Data Integrator is great for any ETL use cases
Oracle Data Integrator--a great tool for Oracle users
Easily integrates data, but could perform better
Oracle Data Integrator review
Outstanding addition to our Oracle JD Edwards Programs
Oracle Data Integrator Review
Oracle Data Integrator enthusiast!
Oracle Data Integration (ETL for Huge Data)
ODI User Review
Heterogeneous Technologies in play with Oracle Data Integrator
Oracle Data Integrator - used for data consolidation and integration project.
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
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
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
Oracle Data Integrator(ODI) || ODI XML to DataBase Part-1
Oracle Data Integrator(ODI) demo video | ODI Tutorials
Oracle Data Integrator(ODI)|| ODI Interview questions
ODI INTRODUCTION Demo: RR ITEC, Hyderabad, India
Oracle Data Integrator(ODI) || Introduction
Features
Data Source Connection
Ability to connect to multiple data sources
- 9.9Connect to traditional data sources(11) Ratings
Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications
- 9.3Connecto to Big Data and NoSQL(9) Ratings
Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases
Data Transformations
Data transformations include calculations, search and replace, data normalization and data parsing
- 9.9Simple transformations(11) Ratings
Simple data transformations are calculations, data type conversions, aggregations and search and replace operations
- 9.9Complex transformations(11) Ratings
Complex data transformations are data normalization, advanced data parsing, etc.
Data Modeling
A data model is a diagram or flowchart that illustrates the relationships between data
- 9.3Data model creation(10) Ratings
Ability to create and maintain data models using a graphical tool to define relationships between data
- 9.5Metadata management(10) Ratings
Automated discovery of metadata with ability to synchronize and share metadata with other tools like Master Data Management
- 9.1Business rules and workflow(11) Ratings
Ability to define and manage business rules and workflows
- 8.5Collaboration(10) Ratings
Collaboration is enabled by a shared repository of project information and metadata
- 9.3Testing and debugging(11) Ratings
Tool to debug and tune for optimal performance
Data Governance
Data governance is the practise of implementing policies defining effective use of an organization's data assets
- 9.5Integration with data quality tools(9) Ratings
Integration with tools for cleansing, parsing and normalizing data according to business rules
- 8.7Integration with MDM tools(7) Ratings
Integration with master data management tools to ensure data consistency across the organization
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is Oracle Data Integrator (ODI)?
Features include :
Oracle Data Integrator (ODI) Video
Oracle Data Integrator (ODI) Competitors
Oracle Data Integrator (ODI) Technical Details
Operating Systems | Unspecified |
---|---|
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(125)Attribute Ratings
Reviews
(1-25 of 29)ODI Tool for Huge Data
Oracle Data Integrator delivers for our company!
An Amazing ETL Tool!
What i think about Oracle Data Integrator
Oracle Data Integrator is great for any ETL use cases
Oracle Data Integrator--a great tool for Oracle users
Easily integrates data, but could perform better
Oracle Data Integrator review
Outstanding addition to our Oracle JD Edwards Programs
Oracle Data Integrator Review
Oracle Data Integrator enthusiast!
Oracle Data Integration (ETL for Huge Data)
- When we use Oracle JDE, EBS, Hyperion with lot of customizations
- When huge data integrations are needed but there is no need for real time integration
- Error monitoring required unlike Flat File Integrations which won't have good error monitoring
- Complementary products like Hyperion are already in place with ODI licenses included
ODI User Review
Heterogeneous Technologies in play with Oracle Data Integrator
Oracle Data Integration: A Data Connectivity tool
Data Warehouse Architect's Review of Oracle Data Integrator
- 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.
ODI review by an integrator consultant
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.
ODI: Flexibility, reusability and performance for data integration with various source and target technologies.
Oracle Data Integrator - a natural migration from OWB
Oracle Data Integrator - The real 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.
ODI – cost effective tool for integration purposes
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.