Logging into DAC for the First Time and Importing Metadata into the DAC Repository
4-44
Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
4.8 Logging into DAC for the First Time and Importing Metadata into the
DAC Repository
When you log into DAC for the first time, you create a set of stored login information.
Also, as part of the first-time login process, DAC prompts you to create the DAC
Repository schema. Once the schema is created, you can then import metadata into the
DAC Repository.
This section contains the following topics:
Section 4.8.1, "Logging into DAC and Creating a Connection to the DAC
Repository"
Section 4.8.2, "Importing Metadata into the DAC Repository"
4.8.1 Logging into DAC and Creating a Connection to the DAC Repository
When you log into DAC for the first time, you must first configure a connection to
connect to the DAC Repository. DAC stores this connection information for
subsequent logins.
After configuring a connection to the DAC Repository and logging in, the DAC will
automatically prompt you to upgrade the repository schema.
DAC Repository Database Authentication File
When you configure a connection to the DAC Repository, the configuration process
includes creating a new authentication file or selecting an existing authentication file.
The authentication file authenticates the database in which the repository resides. If
you create a new authentication file, you will specify the table owner and password
for the database.
A user with the Administrator role must distribute the authentication file to any user
account that needs to access the specified DAC Repository. For information about
managing user accounts, see
Section A.2, "About DAC User Account Management."
.
To log into DAC for the first time and upgrade the repository schema
1.
Start the DAC Client by navigating to the DAC_HOME\dac directory and
double-clicking the startclient.bat file.
The Login ... dialog appears.
Table 47
DAC Metadata Files That Need to Be Copied to DAC Server Machine
File/directory Name
Location of
File/directory in Oracle
BI Applications
Installation
File to Be Copied to Following Location
parameterfileOLTP.txt ORACLE_
HOME\biapps\dwrep\
dac_metadata\dac_
server
Copy this file to the DAC_
HOME\dac\Informatica\parameters\inpu
t directory on the DAC Server machine.
parameterfileDW.txt
ORACLE_
HOME\biapps\dwrep\
dac_metadata\dac_
server
Copy this file to the DAC_
HOME\dac\Informatica\parameters\inpu
t directory on the DAC Server machine.