Creating the connection to RepConnector

A RepConnector connection defines the information that Replication Server uses to connect to the RepConnector server, to replicate data.

Before you create the connection, gather the following information:

• The location of the isql utility, which is in the Replication Server installation directory in OCS-15\bin on Windows or OCS-15/bin on UNIX.

• The DSI name for the RepConnector connection (from line 3.a on your worksheet; it is also the same name added to the interfaces file).

• A user name to connect to the RepConnector connection (from line 3.e on your worksheet).

• A password for this user name (from line 3.f on your worksheet).

1. Using isql, log in to the Replication Server with a user ID that has system administrator permission:

   isql -U <username> -P <pwd> -S <server_name>
   

   where:

   • username is the user ID with sa permission in the Replication Server.

   • pwd is the password for the user ID.

   • server_name is the server name of the Replication Server.

2. Create the connection and define the user ID and password for the RepConnector connection:

                create connection to <dataserver>.<database>
                set error class to rs_sqlserver_error_class
                set function string class to rs_sqlserver_function_class
                set username <dsi_username>
                set password <dsi_password>
                set batch to 'off'
                set dsi_xact_group_size to '-1'
                with dsi_suspended
   

   where:

   • dataserver is the RepConnector connections DSI name. This is the same name you added to the Replication Server interfaces file. Use the name recorded in 3.a on your worksheet.

   • database is the name of the database to which you are replicating. Record this value in 3.j on the worksheet.

     When you create this connection in Replication Server, you must designate it with the dataserver.database data pair value. However, the database name in Replication Server is just a placeholder, and RepConnector does not use that name. Therefore, use a name that clearly designates the replicate or destination (in this case RepConnector), to manage the RepConnector connection in an environment where you are also managing traditional Replication Server connections, whose destinations are actually databases. For example, designate the connection as RepConnector.RepCondb.

   • dsi_username is the user ID that is used to connect to the RepConnector connection. Use the value recorded in 3.e on your worksheet.

   • dsi_password is the password for the user ID. Use the value recorded in 3.f on your worksheet.

   • set batch to 'off' is required by RepConnector. This instructs Replication Server not to batch the commands to send to RepConnector.

   • set dsi_xact_group_size to '-1' is required by RepConnector. This instructs Replication Server not to group the transactions as a single transaction before sending them to RepConnector.

For example:

create connection to RepConnector.RepCondb
set error class to rs_sqlserver_error_class
set function string class to
    rs_sqlserver_function_class
set username sa
set password null
set batch to 'off'
set dsi_xact_group_size to '-1'
with dsi_suspended