Adding a Destination

Although you must define a source object before you can define a subscription, you do not need to pre-define destinations. The Add Subscription Wizard allows you to create a new destination or modify an existing destination as you define a subscription. Destinations that you specify using the Add Subscription Wizard are automatically added to the Destinations folder.

To directly add a destination, you select the ODBC driver or destination DSN and provide the user account information that has permission to access the destination data.

  1. From the Insert menu, select the Destination command.

The Insert->Destination command displays the Destination Properties dialog.

  1. EITHER Create a destination based on a DSN-less connection string by performing the following steps:

  1. Select the ODBC Driver radio button.

  2. Select an ODBC driver from the list. For instance, select ODBC 17 for SQL Server for SQL Server sources or StarSQL (64-bit) if you are using StarSQL to access Db2 sources.

  3. The ODBC driver name will appear in the Source or Destination Name field above the DSN list. Be sure to modify this name to clearly identify the database; the name cannot be changed after it is saved.

  4. Enter a valid connection string (maximus 254 characters) e.g.

StarSQL: Server=MYRDB;HostName=myhostip;Port=446;IsolationLevel=2;PkgColID=SQDR

SQL Server: Server=MYHOST\SQLEXPRESS

See Using Connection Strings for more examples.

OR

Create a destination based on an ODBC data source by selecting a destination DSN from the list. The destination DSN name automatically appears in the Destination Name field above the DSN list, but you can modify the Destination Name field to better identify the destination database if desired.

The default behavior of the Data Replicator Manager is to limit the display of available ODBC data sources to drivers supported by SQDR. To display all data sources, set the advanced setting addUnsupportedDrivers to true.

  1. Enter the User ID and Password of an account that has permission to access data on the selected destination server. The Data Replicator enforces the security setting configured for the selected DSN. If the DSN is SQL Server that uses Windows authentication you do not need to enter the user ID and password.

  2. Click the Advanced tab if you want to modify the connection limits for the destination.

  3. Click OK to approve the destination properties and return to the Replicator Manager window.

Replicator Manager displays the new destination name in the left pane diagram, under the Destinations folder.