Prerequisites for installing the DAC Client and Server on Windows are the following:
For instance, for Oracle :
CREATE user DAC_REP IDENTIFIED BY DAC_REP
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;
GRANT connect, resource, create view TO DAC_REP;
The DAC installer handles the following configuration:
If you reinstall or upgrade Informatica PowerCenter without reinstalling DAC, you need to manually set these environment variables.
The explanation of the installation are minimal and don't say all details as for instance that you have to hit the Next button.
Installation of the last patch 10052370.
DAC requires JDBC drivers for database connectivity. To enable DAC database connectivity, you must install the appropriate JDBC driver in the dac\lib directory on the machines where the DAC Client and Server are installed.
To install JDBC drivers in the \dac\lib directory, copy the file corresponding to your database version from the directory oracle_database_home\jdbc\lib directory and paste it in the ORACLE_DAC_HOME\bifoundation\dac\lib directory.
A summary picture show you an the end of this section all the task that you must perform for a new installation.
To find them for Oracle, you can see this article : Oracle Database - How to retrieve the connect descriptor parameters? (host, port, service name and SID)
Field | Required Value |
---|---|
Name | Enter a unique name for the connection to the DAC Repository |
Connection type | Select the type of database in which the DAC Repository will be stored. |
Connection String, or Database name, or TNS Name, or Instance | Select the database name or database account name of the DAC Repository. If you are using: * Oracle (OCI8), use the tnsnames entry. * Oracle (Thin), use the instance name. * SQL Server, use the database name. * DB2-UDB, use the connect string as defined in the DB2 configuration. |
Database Host | Enter the name of the machine where the DAC Repository will reside. |
Database Port | Enter the port number on which the database listens. For example, for an Oracle database the default port is 1521, or for a SQL Server database the default port is 1433. |
Optional URL | Can be used to override the standard URL for this connection. |
Optional Driver | Can be used to override the standard driver for this connection. |
Authentication File | Click in this field to do one of the following: * Select an existing authentication file. * Create a new authentication file. |
To create a new authentication file, do the following:
The file is located by default in the directory dac_home\bifoundation\dac\conf\connections and you can/must distribute this authentication file to all user accounts that need to access this DAC Repository.
Summary :
This step configures the Connection Between the DAC Server and DAC Repository.
This step must be performed on the DAC server machine
When the DAC Server is installed on UNIX or Linux, use the serverSetupPrompt.sh to configure the connection between the DAC Server and the DAC Repository