Primary data server connectivity

Replication Agent requires a JDBC driver to communicate with the primary database. JDBC drivers for Microsoft SQL Server databases are provided by the database vendors. If the JDBC driver for your database is not already installed, obtain the appropriate driver from the vendor’s Web site. Refer to the Replication Agent Release Bulletin for the version of the Microsoft SQL Server JDBC.

To set the CLASSPATH environment variable

Install the JDBC driver on the host machine on which Replication Agent resides or where Replication Agent can access it.
Add the location of the JDBC driver to the CLASSPATH environment variable. For Microsoft Windows:

Go to Start | Settings | Control Panel | System | Environment, and add the following to the existing CLASSPATH environment variable, using the semicolon (;) as the path separator, or create the path in the User Variables panel:
```
drive:\path_name\driver
```
where:
- drive is the drive letter.
- path_name is the name of the path where you installed the JDBC driver.
- driver is the name of the JDBC driver. For Microsoft SQL Server, the name is sqljdbc.jar.
Click Apply, then OK.

Table 4-7 contains a description of the Replication Agent configuration parameters that must be set.

**Table 4-7: Configuration parameters to connect to the primary data server**
Configuration parameters	Description
pds_username	The Microsoft SQL Server user login that the Replication Agent uses to log in to the primary database. (This user login must be granted permissions as described in “Replication Agent permissions”.)
pds_password	The password for the user login that the Replication Agent uses to log in to the primary database.
pds_dac_port_number	The dedicated administration connection port number that Replication Agent uses to connect to the primary database during the server-level initialization of the primary data server.
pds_host_name	The name of the host machine on which the Microsoft SQL Server data server resides.
pds_port_number	The client socket port number for the primary database gateway server.
pds_server_name	The server name of the Microsoft SQL Server data server.
pds_database_name	The name of the primary database on the Microsoft SQL Server data server, from which transactions will be replicated.