Logging into DAC for the First Time and Importing Metadata into the DAC Repository
Installing and Setting Up Oracle BI Applications
4-47
To import metadata into the DAC Repository
1.
In DAC, select Tools, then DAC Repository Management, then Import to display
the Import dialog.
Make sure that the correct DAC_HOME\dac\export\ directory is displayed at the
top of the dialog. If necessary, use the 'Change import/export directory' button to
select the \dac\export\ directory. If the wrong directory is selected, the
Applications list will be empty
2.
In the Categories area, select the Logical check box and the System check box.
The information imported by these options is as follows:
3.
In the Applications List table, use the check boxes in the Selected column to
specify the source system applications for which you will import the ETL
metadata, as follows:
a.
Select the check box next to Universal.
To avoid possible ETL errors in other applications (for example, missing
tasks), you must import the Universal application.
b.
Select the check box for any other business applications that you want to
deploy.
4.
Select the Truncate Repository Tables check box.
Note:
The DAC Client can connect to only one DAC Repository at a
time.
Categories Options
Description
Logical
Imports all information contained in the DAC Design view and the
execution plan information for the DAC Execute view.
System
Imports all information contained in the DAC Setup view, except
passwords for servers and database connections.
Note:
Do not select the Data Warehouse option unless Oracle
specifically instructs you to do so. This container is reserved for
special purposes.
Tip:
Make a note of the Application names that you select. When
you create data warehouse tables later in the configuration process,
you might need to type in the names exactly as they are displayed
here (for more information, see
Section 4.9.1, "Creating Data
Warehouse Tables"
).