DAC Configuration_Part1

1.Create One User For DAC Repository:

2.Installing JDBC Drivers for DAC Database Connectivity:

                You Must install the appropriate JDBC driver in the DAC\lib directory to enable DAC database connectivity. If the required JDBC drivers are not already installed, you need to install the JDBC driver on the machines where both the DAC server and DAC client are installed.

        if your using JDK 1.5 use ojdbc5.jar and if using JDK 1.6 use ojdbc6.jar.

Finally, What I am Trying to Say is,

$ORACLE_HOME/jdbc/lib/ojdbc5.jar -->JDK 1.5

$ORACLE_HOME/jdbc/lib/ojdbc6.jar –>JDK 1.6

3.Logging Into DAC for the First Time:

                         The Login … dialog box appears. Click Configure.

              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. This Information Will Be Stored In DAC Metadata table...'W_ETL_USER'.

But DAC Will Store Password in Encrypted Format As Shown In Below.

EX:

In the Configuring … dialog box, select Create Connection, and then click Next.

            By Entering Appropriate Information, Here In This Step,you Need to Create a Authentication file.

             The DAC authentication file contains the repository database schema owner and password and a DAC encryption key.

              An authentication file and a DAC repository have a one-to-one relationship. The first time users connect to a DAC repository, they must either specify an authentication file that was previously created or create a new authentication file. When creating a new authentication file, the user must specify the database schema owner and password That is Used to as DAC Repository.

Finally, The authentication file authenticates the database in which the repository resides.

4.Creating DAC Repository Tables:

Enter The User Name and Password for login...

Select “Yes” to create the DAC Repository Tables

5.Connection between the DAC Server and the DAC Repository:

               Here In This Step You can enter the required details or you can just select The option as shown in the below Image.

7.Installing pmcmd and pmrep to Enable Communication Between Informatica PowerCenter and DAC:

DAC uses the Informatica pmrep and pmcmd command line programs to communicate with Informatica PowerCenter in the following ways:

• DAC Server uses
  
  • pmrep to communicate with PowerCenter Repository Services.
    
  • pmcmd to communicate with PowerCenter Integration Services to run the Informatica workflows.
    
• DAC Client uses
  
  • pmrep to synchronize tasks with Informatica workflows and to keep the DAC task source and target tables information up to date.
    

                     The pmrep program is installed in the PowerCenter Client and PowerCenter Services bin directories (for example, \PowerCenter8.6.1\client\bin and \PowerCenter8.6.1\server\bin). Because of the requirement to co-locate the DAC Client with the PowerCenter Client, the pmrep program is available on the machine for the DAC Client to use.
                    The pmcmd program is installed in the PowerCenter Services bin directory. In order for DAC to access pmcmd, it must also reside in the PowerCenter Client bin folder on the same machine where the DAC Client is installed. Copying the pmcmd executable file from the PowerCenter Services bin folder to the PowerCenter Client bin folder is a manual process.