Oracle^® Business Intelligence Data Warehouse Administration Console Guide > Common Tasks Performed in the DAC >

Importing DAC Metadata

The DAC's Import/Export feature allows you to import or export source system-specific DAC metadata into or out of the DAC repository. You can use this feature to migrate DAC metadata from one environment to another, such as from a development environment to test or production environments.

To import DAC metadata

1. In the DAC menu bar, select Tools > DAC Repository Management > Import.
2. Select the directory from which you want to import DAC metadata, or accept the default directory.
3. Select the appropriate source system containers.
4. Select the appropriate categories of metadata you want to import:
   • Logical. Imports all information contained in the Design view and database connection information.
   • System. Imports all information contained in the Setup view, except passwords for servers and database connections.
   • Run Time. Imports information about ETL runs (contained in the Execute view)
5. If you are importing metadata into a blank repository or to completely replace the current metadata in the repository, select Truncate Repository Tables.

   This action overwrites the content in the current repository. Selecting the Truncate Repository Tables option greatly increases the speed of the import process.

6. (Optional) Select Enable Batch Mode to insert the imported metadata into the repository as an array insert.

   This action increases the speed of the import process.

7. Click OK.
8. Verify the import process by reviewing the log file \OracleBI\DAC\log\import.log.