1 Introduction to Oracle Data Integrator

Oracle Data Integrator provides a fully unified solution for building, deploying, and managing complex data warehouses or as part of data-centric architectures in an SOA or business intelligence environment. This chapter provides an introduction to Oracle Data Integrator and its various components.

This chapter includes the following sections:

What is Oracle Data Integrator?

Oracle Data Integrator (ODI) features an active integration platform that includes all styles of data integration: data-based, event-based and service-based. ODI unifies silos of integration by transforming large volumes of data efficiently, processing events in real time through its advanced Changed Data Capture (CDC) framework, and providing data services to the Oracle SOA Suite. It also provides robust data integrity control features, assuring the consistency and correctness of data. With powerful core differentiators - heterogeneous E-LT, Declarative Design and Knowledge Modules - Oracle Data Integrator meets the performance, flexibility, productivity, modularity and hot-pluggability requirements of an integration platform.

Oracle Data Integrator Components

The Oracle Data Integrator platform integrates in the broader Fusion Middleware platform and becomes a key component of this stack. Oracle Data Integrator provides its run-time components as Java EE applications, enhanced to fully leverage the WebLogic Application Server. Oracle Data Integrator components include exclusive features for Enterprise-Scale Deployments, high availability, scalability, and hardened security. The ODI architecture relies on the following components that collaborate together:

  • Repositories

  • ODI Studio and User Interfaces

  • Design-time Projects

  • Run-time Agent

  • ODI Console

  • Oracle Enterprise Manager Fusion Middleware Control

  • Management Pack for Oracle Data Integrator

For more information regarding ODI components see the Understanding the Oracle Data Integrator Component Architecture section in Understanding Oracle Data Integrator.

Basic Tasks for Configuring and Managing Oracle Data Integrator

The following provides a summary of the steps you need to take to configure and manage a basic Oracle Data Integrator environment after you have installed the software:

Table 1-1 Roadmap for Configuring and Managing Oracle Data Integrator

Task Documentation

1. Create a master and work repository schema

See the Creating the Oracle Data Integrator Master and Work Repository Schema section in Installing and Configuring Oracle Data Integrator.

2. Create additional work repositories

See Creating a Work Repository.

3. Configure a domain for Oracle Data Integrator agents

4. Create an agent

5. Start an agent

6. Configure load balancing on a Standalone agent

See Load Balancing Agents

7. Configure high availability for Oracle Data Integrator

See Roadmap for Setting Up a High Availability Topology .

8. Configure security

See Managing Security in Oracle Data Integrator.

9. Set up a topology

See Setting Up a Topology.

10. Set up data services

See Creating and Using Data Services.

11. Run, debug, and monitor integration processes

See Running and Monitoring Integration Processes.

12. Use Enterprise Manager to manage ODI environment

See ODI Domain, Oracle Enterprise Manager Fusion Middleware Control, and Management Pack for Oracle Data Integrator.

13. Stop an agent

See the Stopping Your Oracle Data Integrator Agents section in Installing and Configuring Oracle Data Integrator.