4 Oracle Data Integrator Post-Upgrade Tasks

The Upgrade Assistant automates many of the upgrade tasks, but there are cases where you must manually modify the configuration settings after running the Upgrade Assistant. Review Table 4-1 to determine if you need to perform any additional upgrade procedures:

Table 4-1 Post-Upgrade Procedures for ODI

If you... Then do this to finalize the upgrade...

Centralized master and Work Repositories onto a single instance before the upgrade

Redistribute the repositories accordingly

See Section 4.1, "Redistributing Centralized Repositories After Upgrade"

Selected the Upgrade Oracle Data Integration Schemas option to upgrade the master and Work Repository schemas

Update the connection parameters to the Work Repositories as defined in the ODI topology.

See Section 4.2, "Updating the Work Repository Connection Parameters"

Chose not to Update Topology and Security Metadata during the upgrade

Manually upgrade the ODI 10g metadata so that it can be used with ODI 11g.

See Section 4.3, "Updating Topology and Security Metadata"

Updated the Topology and Security Metadata using Upgrade Assistant

Manually re-apply modifications made in Oracle Data Integrator 10g to the new ODI 11g built-in metadata objects. (The automated upgrade process erases any changes that were made to the ODI 10g objects.)

See Section 4.4, "Re-applying ODI 10g Modifications to the ODI 11g Topology and Security Metadata"

Chose not to Replace KMs with Mandatory Updates during the upgrade

Manually upgrade the ODI 10g KMs so that they can be used with ODI 11g.

See Section 4.5, "Replacing KMs with Mandatory Updates"

4.1 Redistributing Centralized Repositories After Upgrade

Both ODI 10g and ODI 11g support the distribution of schemas on multiple database instances. The Upgrade Assistant, however, supports only one set of database credentials at the time of the upgrade. To use the Upgrade Assistant, you must first clone (copy) all ODI 10g repositories to a single database/server instance. Once the upgrade is completed, you can redistribute the upgraded repositories.


The redistribution process is similar to the cloning processes documented in Section 3.4, "Task 4: Copy (Clone) Existing 10g Master and Work Repositories".

4.2 Updating the Work Repository Connection Parameters

You must update the connection parameters to the upgraded Work Repositories as defined in the ODI topology.

To update the Work Repository Connection Parameters:

  1. Launch the Oracle Data Integrator Console and connect to the Master Repository using Oracle Data Integrator Studio.

    Expand the Work Repositories node in the Repositories accordion of the Topology Navigator.

  2. Edit each Work Repository that is now hosted on a new server and edit its connection parameters by clicking the Connection button in the Work Repository editor toolbar.

  3. Modify the connection parameters, User and Password, on the Definition tab. Modify the JDBC Driver and URL on the JDBC tab. Save the changes.

  4. Validate your changes by creating and testing Repository Connections for these Work Repositories in Studio.

  5. Modify your odiparams script to reflect the new connection parameters to your Master Repository. This file is in the ODI_HOME/oracledi/agent/bin directory, where ODI_HOME is the Oracle Data Integrator installation directory.

    • On UNIX system:


    • On Windows system:


    Edit the odiparams script with a text editor to set the configuration parameters as shown in the following example. (Note that the values are provided for example only; be sure to enter your own parameters):

  6. For each ODI Agent configuration update the odiparams.bat (.sh) script as indicated in step 5.

4.3 Updating Topology and Security Metadata

By default, the Upgrade Assistant enables you to import the same ODI 10g technologies, data types, data type conversions, and languages when upgrading to ODI 11g. If, however, you have selected not to have them upgraded automatically by the Upgrade Assistant, you should upgrade them manually to take advantage of the ODI 11g features. The following ODI 10g metadata should be manually updated using Oracle Data Integrator import features:

  • Technologies

  • Data types and data type conversions

  • Default Actions

  • Action Groups

  • Languages

  • Security profiles

  • Objects

  • Methods


Oracle Data Integrator 11g Topology and Repository Metadata exports are located in the ODI_HOME/oracledi/xml-reference directory. These objects must be imported in 'Synonym Insert-Update' mode.

For more information on importing and exporting ODI metadata, see "Chapter 18, Exporting/Importing" in the Oracle Fusion Middleware Developer's Guide for Oracle Data Integrator.

4.4 Re-applying ODI 10g Modifications to the ODI 11g Topology and Security Metadata

The ODI 11g upgrade process will automatically upgrade your ODI 10g topology and security metadata objects. However, if you modified the topology and security objects that were provided by default with ODI 10g, such as user defined profiles or technologies, you must reapply your changes manually by editing the objects.

For information on modifying topology and security metatdata, see Oracle Fusion Middleware Developer's Guide for Oracle Data Integrator.

4.5 Replacing KMs with Mandatory Updates

By default, the Upgrade Assistant enables you to update ODI 10g Knowledge Modules (KMs) when upgrading to ODI 11g. Most ODI 10g KMs can be used with ODI 11g, so the update is not mandatory for all KMs.

Specifically the following KMs must be manually updated using KM Import/Replace before using ODI 11g (refer to the note below for more information):

  • LKM File to Oracle (EXTERNAL TABLE)

  • LKM File to Netezza (EXTERNAL TABLE)

  • LKM File to Oracle (SQLLDR)

  • LKM File to SAS

  • LKM File to DB2 UDB (LOAD)

  • LKM SAS to SQL

  • LKM SQL to Teradata (TTU)

  • IKM SQL to Teradata (TTU)

  • LKM File to Teradata (TTU)

  • IKM File to Teradata (TTU)

  • IKM Teradata to File (TTU)

  • LKM File to MSSQL (BCP)

  • LKM File to Sybase IQ (LOAD TABLE)


The Knowledge Modules listed above must be updated because they use calls to the odiRef.getTargetTable or odiRef.getTableList APIs to request field or row separators for a file datastore. In ODI 10g, the returned values were inverted when requesting hexadecimal (XFILE_SEP_FIELD, XFILE_SEP_ROW) and ASCII (FILE_SEP_FIELD, FILE_SEP_ROW) separators. To address this issue, the ODI 10g KMs were implemented to work around this issue.

The 11g OdiRef APIs return the correct values; therefore, the KMs have been modified to request the correct hexadecimal or ASCII separators.

For example:

  • odiRef.getTargetTable("FILE_SEP_FIELD") was replaced with odiRef.getTargetTable("XFILE_SEP_FIELD")

  • odiRef.getTargetTable("XFILE_SEP_FIELD") was replaced with odiRef.getTargetTable("FILE_SEP_FIELD")

  • odiRef.getTargetTable("XFILE_SEP_ROW") was replaced with odiRef.getTargetTable("FILE_SEP_ROW")

  • odiRef.getTargetTable("FILE_SEP_ROW") was replaced with odiRef.getTargetTable("XFILE_SEP_ROW")

If you customized KMs using these methods, you must make the appropriate changes to the API calls.