The goal of Oracle Data Integrator is to automate information exchange between applications :
Some integration needs are data oriented, especially those involving large data volumes. Other integration projects lend themselves to an event-oriented architecture for asynchronous or synchronous integration. (Changes tracked by Changed Data Capture constitute data events).
Oracle Data Integrator is well suited to a broad range of integration projects– ETL, Data Migration, Master data management, Business Activity Monitoring (BAM), Business Process Management (BPM), Business Process Reengineering (BPR), and Web Services integration – implemented using a combination of Data-oriented, Event-oriented, and Service-oriented mechanisms.
by executing high-volume, high-performance loading of data warehouses, data marts, On Line Analytical Processing (OLAP) cubes, and analytical applications. It transparently handles incremental loads and slowly changes dimensions, manages data integrity and consistency, and analyzes data lineage.
Master Data Management—by providing a comprehensive data synchronization infrastructure for customers who build their own data hubs, work with packaged MDM solutions, or coordinate hybrid MDM systems with integrated SOA process analytics and Business Process Execution Language (BPEL) compositions.
by calling on external services for data integration and by deploying data services and transformation services that can be seamlessly integrated within an SOA infrastructure. It adds support for high-volume, high-performance bulk data processing to an existing Service-oriented architecture.