|Oracle® Fusion Middleware Upgrade Guide for Oracle Data Integrator
11g Release 1 (11.1.1)
Part Number E12642-01
The following sections introduce some key concepts of the Oracle Data Integrator environment for 10g Release 3 (10.1.3.x) users:
Oracle Data Integrator 10g Release 3 (10.1.3) provided the following components:
Oracle Data Integrator
Oracle Data Profiling
Oracle Data Quality for Data Integrator
Oracle Data Integrator 11g provides updates to all of these components, but not in a single installation. In Oracle Data Integrator 11g, Oracle Data Profiling and Oracle Data Quality components are packaged and installed separately, but they still provide the same resources and services.
Specifically, Oracle Data Integrator 11g provides the following installation options:
Oracle Data Integrator Client Components
This component replaces the Oracle Data Integrator 10g graphical modules (Designer, Operator, Topology and Security Manager), which are all merged into a single Fusion Common Platform (FCP) user interface.
This new component is a Java API for performing run-time and design-time operations.
Oracle Data Integrator Standalone Agent
Oracle Data Integrator Java EE Components
This component is a Java EE flavor of the run-time agent, for deployment within an application server.
This component replaces the ODI 10g Repository Explorer (Metadata Navigator) and Lightweight Designer components. It also installs the Oracle Enterprise Manager Plug-in for ODI.
This component is a web service that allows context and scenario listing. A scenario is designed to put a source component (interface, package, procedure, variable) into production. Other run-time web service operations (executing scenarios and sessions) are available on the Standalone and Java EE agent components.
For more information, see "Working with Web Services in Oracle Data Integrator" in Oracle Fusion Middleware Developer's Guide for Oracle Data Integrator
Although the overall product architecture has not changed, 10g users should be aware the following changes to plan for their updates.
Before you begin the upgrade process, consider the following:
Upgrading to ODI 11gR1 is performed using the Upgrade Assistant. It is not possible to upgrade repositories from the Oracle Data Integrator user interface.
For instructions on verifying that your database meets the requirements of Oracle Fusion Middleware 11g, see "Upgrading and Preparing Your Databases" in the Oracle Fusion Middleware Upgrade Planning Guide. Oracle recommends that you refer to your database-specific upgrade documentation for additional information.
For more information on cloning repositories, see Task 4: Copy (Clone) Existing 10g Master and Work Repositories.
The run-time agent is available as a standalone agent or a Java EE agent. Both of these agents are now connected to a single Work Repository and act as schedulers. The agents connect systematically to the Master Repository at startup.
For these agents to start properly:
The agent now uses the HTTP protocol rather than its own protocol. In addition, the standalone agent is no longer started as a service using the Wrapper tool. To configure the agent for high availability, Oracle Process Manager and Notification Server (OPMN) is used and can be configured using some built-in scripts.
Oracle Data Integrator 10g users should also be aware of the following changes in Oracle Data Integrator 11g:
Knowledge modules and technologies are available in a directory called
Host and Modules are removed from the Security. This entire feature is deprecated.
The following scripts are deprecated: Jython, agentscheduler, agentweb, designer, topology, security, and operator.
Repository creation for Oracle, DB2 and Microsoft SQL Server can be performed using Repository Creation Utility (RCU). This tool allows creation and management of schemas for multiple Oracle products.
Repository creation and import is possible from the ODI Studio. The mimport and mupgrade scripts are deprecated.
ODI is now shipped with DataDirect JDBC drivers to connect to technologies such as MSSQL and DB2. Note that the other ODI drivers can still be used to connect to the database. The additional drivers for the Standalone Agent are in the
/drivers directory, but the drivers for the ODI Studio are in the
For more information, see "Add Additional Drivers and Open Tools" in Oracle Fusion Middleware Installation Guide for Oracle Data Integrator.
Note:For a detailed list of the new features in Oracle Data Integrator 11gR1, see "What's New In Oracle Data Integrator?", in Oracle Fusion Middleware Developer's Guide for Oracle Data Integrator.