DAC - Installation and Configuration v10.1.3.4.1 on Windows

> Oracle Business Intelligence Application (OBIA)

1 - Prerequisites for Installing DAC

Prerequisites for installing the DAC Client and Server on Windows are the following:

  • Download the file Oracle Business Intelligence Data Warehouse Administration Console v10.1.3.4.1 on OTN
  • Create a repository user which will store the dac object

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;
Advertising

3 - DAC Configuration Handled by the DAC Installer

The DAC installer handles the following configuration:

  • In the config.bat file, the DAC installer configures the JAVA_HOME and DAC_HOME variables.
  • In the dac_env.bat file, the DAC installer creates an environment variable named INFA_DOMAINS_FILE and sets the value to the directory path of the domans.infa file.
  • The DAC installer adds the directory path to Informatica PowerCenter binaries to the PATH environment variable.

If you reinstall or upgrade Informatica PowerCenter without reinstalling DAC, you need to manually set these environment variables.

4 - Procedure

The explanation of the installation are minimal and don't say all details as for instance that you have to hit the Next button.

  • Unzip the dac downloaded file
  • Start the installation with the dac\Disk1\setup.exe
  • Install location : C:\orahome\10gR3_1
  • Choose informatica 8x or 7x. For Informatica 8.1.1 or 8.6.1, you have to choose 8.x
  • Informatica 8x location :
    • Informatica Powercenter : C:\Informatica\PowerCenter8.x.x\server
    • Informatica PowerCenter Domain File : C:\Informatica\PowerCenter8.x.x\domains.infa
  • Prerequisite check : Ok.
  • Summary

  • Click the Install button

  • Success !
Advertising

5 - Patch

Installation of the last patch 10052370.

  • extract the content of the file p10052370_101341_Generic.zip
  • Terminate all DAC clients and server(s).
  • Rename the jar file DAC_BASE\bifoundation\dac\DAWSystem.jar as DWASystem.jar.old
  • Rename the xml file DAC_BASE\bifoundation\dac\conf\infa_command.xml as infa_command.xml.old
  • Copy the patched up DAWSystem.jar file into DAC home directory (DAC_BASE\bifoundation\dac\)
  • Copy the patched up infa_command.xml file into DAC_BASE\bifoundation\dac\conf\

6 - JDBC Driver

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.

  • For Oracle database 11g, ojdbc6.jar
  • For Oracle database 9.x or 10.x, ojdbc14.jar

7 - Creation of the Repository

A summary picture show you an the end of this section all the task that you must perform for a new installation.

  • Start the DAC Client by navigating to the $ORACLE_DAC_HOME\bifoundation\dac directory and double-clicking the startclient.bat file (of in the start menu)

  • The Login … dialog box appears.
  • Click Configure.
  • In the Configuring … dialog box, select Create Connection, and then click Next.
  • Enter the appropriate connection information:

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:

  • Click in the Authentication File field of the Configuring… dialog box.
  • In the Authentication File dialog box, select Create authentication file.
  • In the Create Authentication File dialog box, enter a unique name for the authentication file, and click OK. (Oracle.con for instance)

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.

  • Enter the Table Owner Name and Password for the database where the repository will reside.
  • In the Configuring… dialog box, click Test Connection to confirm the connection works.
  • Click Apply, and then click Finish.

Summary :

  • In the Login… dialog box, do the following:
    • Select the Connection just created from the drop-down list.
    • Enter Administrator as the User Name.
    • Enter Administrator as the Password.
    • Click Login and follow the picture below

Advertising

8 - Configuration of the connection between the DAC Server and the DAC Repository

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