DAC 11G Installation and Configuration- Part1

Create Database User:-

For Sql Server:-
Create a DAC_USER  and add the below permissions to the user.

For Oracle:-
Create a user in the database and grant all privileges to the user.

 Select dac11g_install and Run As Administrator

 

Click Next

 

 Select the folder where Informatica is installed.

 

Select domains.infa file which is under Informatica folder.

 

Create a folder DAC11G and Select that folder to have the DAC installation files.

 

Select appropriate option.

 Select Install

 

Click Done

Click DAC Client to configure

 

Click on configure

Create Connection and Click Next.

 Enter details as shown above and for Authentication . choose create New authentication file.

Click OK

 

 Enter DAC_USER details, user created in the database and click OK

 

(For SQL Server Only) driver is available for Oracle, SQL Server driver has to be downloaded.

Download SQL SERVER driver Executable Jar File and copy jar file in to the lib directory of DAC(sqljdbc4.jar) and rename the file to sqljdbc.jar

 

Test Connection now.

 Create a new connection to log into DAC.

Click on Login

 

Click Yes

Enter DAC_USER details.

 Enter Administrator username and password.

Click on Tools-> DAC Server Management -> Repository Configuration . Change Mode to Standalone