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

Exporting 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 export DAC metadata

  1. In the DAC menu bar, select Tools > DAC Repository Management > Export.
  2. Select the directory to which you want to export DAC metadata, or accept the default directory.
  3. Select the appropriate source system containers.
  4. Select the appropriate categories of metadata you want to export:
    • Logical. Exports all information contained in the Design view and database connection information.
    • System. Exports all information contained in the Setup view, except passwords for servers and database connections.
    • Run Time. Exports information about ETL runs (contained in the Execute view).
  5. Click OK.
  6. Verify the export process by reviewing the log file \OracleBI\DAC\log\export.log.
Oracle® Business Intelligence Data Warehouse Administration Console Guide Copyright © 2007, Oracle. All rights reserved.