Adding an ADDI project

Perform required configuration steps to add an ADDI project.

About this task

For multiple ADDI projects, you must perform configuration steps to define each additional ADDI project. The following requirements apply when maintaining multiple ADDI projects:

For the first instance of an ADDI project:
- The database name in the must be IAD1.
- The target system for the name IAD1 is automatically installed with the ADDI maps, as described in Installing virtual tables and virtual target maps for ADDI access.
For subsequent ADDI projects:
- It is recommended that the database name start with IAD.
- The target system must start with TSIAD.

Perform the following procedure for each additional ADDI project.

Procedure

Repeat the database definition in the configuration member and make the following changes:
1. Change the NAME value to a unique name (for example, IAD2).
2. Change the LOCATION value to match the Microsoft SQL Server project name containing the ADDI project you need to access.
For information about the database definition parameters, see Modifying the configuration member for ADDI access.
Define a new virtual target system using the studio. The name of the virtual target system must start with TSIAD. This can be done in the Data Service Studio by selecting the Create Virtual Target System in the Server tab under the SQL > Target Systems > DBMS node of the tree. The connection value in each definition must match the NAME value defined in the DATABASE definition in the configuration member.
If required, create authentication information using the CQDDRATH batch utility.