B Importing the ODI Repository dump

This appendix describes how to import the ODI repository dump.

Note:

Please contact your database administrator to perform the following procedure for importing the ODI repository.

Follow the below steps to import the ODI repository dump:

1. Start SQL Developer.
2. Define a connection as SYS to the DBaaS system that has the new ODI repository and connect. Please ensure that you connect to the pluggable database and NOT to the container database.
3. Create the DATA_PUMP_DIR_PDB directory, and point it to a directory in the DBaaS system into which you will import your ODI-CS repository dump file.
4. Define a connection as SYSTEM to the DBaaS system that has the new ODI repository and connect. Using this connection, open the DBA panel.
5. Expand the Data Pump node, right-click Import Jobs and select Data Pump Import Wizard. This opens the Import Wizard.
6. In the Type screen, provide the following information:
   1. Data or DDL: Select Data Only from the drop-down list.
   2. Type of import: Select Schemas.
   3. Credentials or Directories: Specify DATA_PUMP_DIR_PDB.
   4. File Names or URI: Enter the name of the dump file.
7. Click Next.
8. In the Filter screen, select ODI_REPO from the Available source schemas window and click the right arrow to move it to the Selected source schemas window. Click Next.
9. In the Re-Map Schemas section of the Remapping screen, provide the mapping from the ODI_REPO schema to import to the schema in your DBaaS. Click Next. If all defaults were taken during repository installation, the name will be DEV_ODI_REPO.
10. In the Options screen, fill in the details according to the way you performed the export. Click Next.
11. In the Schedule screen, leave all the defaults. Click Next.
12. In the Summary screen, click Finish to start the import process.

Note:

This procedure is only applicable for ATP-D.