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

No comments:

Post a Comment

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