Create Database Repository User:

Create database user dac_rep with the following commands

SQL> conn system/password;
SQL>create user dac_rep identified by dac_rep;
SQL>grant connect,resource to dac_rep;

Install DAC:

1. Extract the ZIP file dac_windows_x86_101341 to a folder
2. Double click on setup.exe in Disk1 folder
3. In welcome windows, click Next
   
   
   
4. specify the installation location
   
   
   
5. click on Next
   
   
   
6. select Informatica version. Informatica must be installed before installing DAC
   
   
   
7. select informatica installation location and domain info file
   
   
   
8. It check for prerequisites and click next
   
   
   
9. click Install
   
   
   
10. click Finish
    
    
    
    

Oracle Driver setup:

search for ojdbc14.jar file in oracle installation and copy the file to $ORACLE_DAC_HOME\bifoundation\dac\lib directory

Configure DAC:

1. select client from the programs to start configuring DAC
   
   
   
2. click on configure button
   
   
   
3. select create new connection radio button and click Next
   
   
4. Click on Next and give connection name and TNS. In my case YNS is XE and it can be ORCL for you. please check tnsnames.ora in case of doubt
   
   
   
5. click on authentication file and from pop up drop down, select create new authentication file
   
   
   
6. click on Ok and save it to local default directory
   
   
   
7. click on Ok and give filename to store as DAC_CONN.con
   
   
   
8. provide the dac_rep user details we create initially
   
   
   
9. click on test connection
   
   
   
   
   
10. click apply
    
    
    
11. click next by selecting new connection
    
    
    
12. login with Administrator/Administrator using DAC_CONN
    
    
    
13. click on yes for creation of table space
    
    
    
14. create new administrator user in case you want to change , otherwise use Administrator/Administrator and click on ok
    
    
    
15. click on yes to analyse DAC repository tables
    
    
    
16. It opens a DAC Window to start working
    
    

Configure Connection between DAC Server and Repository

1. Log into Administration console and from Tools menu , select DAC Server Management>>DAC Server Setup
   
   
   
2. click on yes for the pop up window
   
   
   
3. provide the database details an click on test connection
   
   
   
   
   
4. click on close and save

Configure DAC client connection to Informatica server:

The DAC Client uses the Informatica pmrep and pmcmd command line programs to
communicate with Informatica PowerCenter. Follow the config steps

1. copy the pmcmd.exe program from the PowerCenter 8.6\server\bin directory to PowerCenter 8.6\client\bin directory
   
   
   
2. Create an environment variable called INFA_DOMAINS_FILE with the value set to the directory path to the domans.infa file
   
   
   
3. Add informatia bin (C:\Informatica\PowerCenter8.6.0\client\bin) location to the system path
   
   
   
4. Verify pmcmd command by opening a command prompt
   
   
   
5. verify the pmrep command by opening a new command prompt
   
   
   
   
6. In the DAC Client, click on Setup view, then click on Informatica Servers tab.
   
7. click on new button and create Integration service configurations in DAC, save and test connection
   
   
   
8. Click on New again and create repository service configuration, Save and test connection
   
   

¶ 5:20 AM