Importing DAC Metadata

Importing DAC Metadata

The DAC's Import/Export feature enables you to import source system-specific DAC metadata into the DAC repository. You can also 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 Client, on the Tools menu, select DAC Repository Management, and then select Import.
2. Select the directory from which you want to import DAC metadata, or accept the default directory.
3. Select the appropriate applications for which you want to import metadata.
4. Select the appropriate categories of metadata you want to import:
   
   • Logical. Exports all information contained in the Design view and metadata defined in the Seed Data menu.
   • System. Exports all information contained in the Setup view, except passwords for servers and database connections.
   • Run Time. Exports information about ETL runs and schedules (contained in the Execute view).
   • User Data. (Applicable to DAC standalone authentication only) Exports the users, roles, and passwords. Note: When importing roles and passwords, if the encryption key is different in the repository to which you are importing from that in which the metadata was exported, the roles and passwords will be unreadable.
5. If you are importing metadata into a blank repository or to completely replace selected categories of the current metadata in the repository, select Truncate Repository Tables. This option overwrites the content in the current repository. It also greatly increases the speed of the import process.
6. If you want DAC to import new records and update existing records, select Update Existing Records. If you do not select this check box, DAC will only insert new records. This option is only available if you do not select the Truncate Repository Tables option.
   Note: When importing DAC metadata into a container, if you select the Update Existing Records option (and not the Truncate Repository Tables option), you also need to import the metadata into any child containers. Otherwise, the child containers will be inconsistent with the parent container.
7. (Optional) Select Enable bulk mode to insert the imported metadata into the repository as an array insert. You should elect this option only if you also selected the Truncate Repository Tables option.
   This action increases the speed of the import process.
8. Click OK.
9. Verify the import process by reviewing the log file <Domain_Home>\dac\log\import.log.

Applying Patches

The DAC metadata patch feature enables you to do the following:

• Update the predefined ("out-of-the-box") Oracle BI Applications metadata provided by Oracle. In this process, DAC works in conjunction with OPatch, a utility supplied by Oracle.
• Move subsets of DAC metadata from one environment to another.