- Monitoring console (13)8.383%
- Connector modification (12)7.979%
- Pre-built connectors (12)7.777%
- Support for real-time and batch integration (13)7.070%
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Oracle Data Integrator, and make your voice heard!
Entry-level set up fee?
- No setup fee
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Would you like us to let the vendor know that you want pricing?
It handles a large quantity of data with ease and is powerful for processing ETL.
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.
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.
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).