Wednesday, July 20, 2022

Perfect order of ODI export and import

 Smart Export / Import is the recommended way to achieve such a migration. This is the easiest way to make sure all the dependencies are taken along and it's possible to skip the Topology when importing.

If the Smart Export / Import is not used, the objects should be imported in a specific order to avoid missing references :

1.     Projects : Empty

2.     Variables (as even the Physical Topology can use variables)

3.     If not existing : Physical Topology

4.     If not existing : Logical Topology

5.     Projects Folders, KMs, Sequences, User Functions

6.     Models

7.     Interfaces and Procedures

8.     Packages

9.     Scenario and Load Plans

How To Refresh ODI 12c Component-Style (Built-in) Knowledge Modules

 How To Refresh ODI 12c Component-Style (Built-in) Knowledge Modules

Regardless of the version of ODI 12c used, component-style (built-in) KMs can be refreshed by executing the following SDK command from the ODI Studio Groovy editor:

OdiAdapter.getInstance(odiInstance).refreshRepositorySeededObjects (odiInstance, true);

  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...