Oracle Data Integrator helps to you to integrate the vast amounts of information stored in disparate systems. Oracle Data Integrator streamlines the high-performance movement and transformation of data between disparate systems in batch, real-time, synchronous, and asynchronous modes, with a focus on batch processing large amounts of data.
Oracle Data Integrator is optimized to handle very large transformations that cannot be managed by Oracle Mediator. The main scenarios are depicted in the graphic:
- A BPEL process or a mediator service component passes XML payload for a document larger than 10 MB to Oracle Data Integrator to transform the payload.
- A BPEL process or an mediator service component passes an XML payload to Oracle Data Integrator to transform and load an XML file into a database.
- Oracle BAM, Oracle Complex Event Processing, Oracle BPEL Process Manager, human task, or Oracle Mediator trigger a rule requiring a data warehouse refresh for Oracle Business Intelligence. Oracle Data Integrator orchestrates data-tier loading and insertion into a staging area, and then transforms aggregate data and loads tables, enabling Oracle Business Intelligence and data warehouse applications to report on the triggered data.
Oracle SOA Suite and Oracle Data Integrator enable enterprises to perform any kind of data transfer and transformations: from real-time to batch and from small data changes propagation to complete replications. They enable companies to more easily handle initiatives related to business intelligence (BI), data warehousing, master data management (MDM), Oracle BAM, application migration and consolidation, and SOA.