Exporting Content from the 11.1.1.10.1 ODI Repository

Use these instructions to export content from the 11.1.1.10.1 ODI repository.

To export content from the 11.1.1.10.1 ODI repository:
  1. Launch the ODI Studio client and connect to the ODI repository for Oracle BI Applications 11.1.1.10.1. (Do not connect to the backup of the ODI repository).
  2. Navigate to the Topology tab. From the Connect Navigator (Topology icon drop-down on the top right side of the navigator pane), select Export.

    As part of the procedures described here, you will export files to a local directory.

  3. To export connections, complete the following steps:
    1. Launch the Smart Export wizard from the Export selection dialog.
    2. Drag the Global context into the Objects to be Exported window. Provide a meaningful name for the export file and click Export.
      This exports the logical and physical topology including assigned Datasource Num ID values and database connect details.
  4. To export security details, complete the following steps:
    1. Select the option to export security settings.
    2. Choose to export to a local file (directory).
      This action exports your user configurations.
  5. To export any customizations in your ODI repository, complete the following steps:
    1. Export the Custom folder by right-clicking it and selecting the Export option.

      Per the customization methodology, all custom and customized ETL tasks are in a separate CUSTOM folder.

    2. In the next window, ensure that the Child Components Export check box is selected.
  6. To export customized data stores, complete the following:
    1. Click the Export option from the navigator window.
    2. Select the option to export multiple objects.
    3. Drag and drop your purely custom and customized data stores. Ensure that the Export child objects option is selected.
      In the example below, WC_ALLOC_INV_BALANCES_F/FS are purely custom tables while W_GL_OTHER_F/FS are tables that have been customized.