1. Upgrading Business Intelligence Applications
  2. In-Place Upgrade
  3. Pre-Upgrade Tasks
  4. Back Up the ODI Repository
  5. Export Oracle Data Integrator Repository Content

Export Oracle Data Integrator Repository Content

Export the content from the Oracle Data Integrator Repository of Oracle BI Applications 11.1.1.10.3 to a local directory.

  1. Launch the Oracle Data Integrator Studio client and connect to the Oracle Data Integrator repository of Oracle BI Applications 11.1.1.10.3, not the Oracle Data Integrator repository backup.
  2. Select the Topology tab. From the Connect Navigator menu on the top right corner of the window, select Export.
  3. Export connections.
    1. In the Export Selection dialog, select Smart Export to launch the Smart Export wizard.
    2. Drag the Global context and DS_TALEO15A_SRCFILES into the Objects to be Exported window. Provide a meaningful name for the export file, and then click Export.
    This exports the logical and physical topology including assigned Datasource Num ID values and database connection details.
  4. Export the security details.
    1. In the Export Selection dialog, select Export Security Settings.
    2. Choose to export to a local file (directory).
    This exports your user configurations.
  5. Export customizations, if any in your Oracle Data Integrator repository.
    1. Right-click the Custom folder and select Export.
      Description of odi-customfolder-export.png follows
      Description of the illustration odi-customfolder-export.pngAll custom and customized ETL tasks are in a separate CUSTOM folder.
    2. In the next window, select Child components export.
  6. Export the customized data stores.
    1. From the Connect Navigator menu on the top right corner of the window, select Export.
    2. In the Export Selection dialog, select Export Multiple Objects.
    3. Drag and drop your custom and customized data stores to the list to export. Make sure you select the Export child objects option.