Basic Source Properties Tab

Property

Description

Source Name

The source name can be a maximum of 127 characters. You cannot change the name of an existing source.

Connection Method

ODBC DSN or ODBC Driver

Choose whether to use an ODBC data source or a DSN-less connection string.

Source DSN

Select the data source name (DSN) for the source you are adding or modifying. The Name column displays data source names, and the Driver column displays the name of the ODBC driver associated with each DSN.  Driver names vary depending on the manufacturer and version. For a SQL Server source, look for a DSN entry that uses the Driver SQL Server. For a Db2 source, look for a Driver of StarSQL (64-bit). For an Oracle source, look for a Driver name that includes ODBC or Oracle.

The DSNs that appear depend on how the Replicator Service is configured to start. If the Replicator Service logs on as a system account, a list of system DSNs appears. If the Replicator Service logs on as a user account, the DSNs defined for the specified user account appear in addition to the system DSNs. (You specify whether the Replicator Service logs on as a system account or a specific Windows user account when you configure the service.)

Source Driver

Specifies an ODBC driver to use with a DSN-less connection string.

ODBC Driver Connection String

Specifies an ODBC connection string (maximus 254 characters)

Authentication Method

Choose between Remote Credentials and Use Integrated Security. If you select Remote Credentials, you must enter a User ID and Password.

If you select  Use Integrated Security, the User ID and Password fields will be disabled. You may also have to enter additional information in either the ODBC DSN or connection string e.g. Trusted_Connection=Yes for SQL Server.

User ID
and
Password

Enter the user ID and password that allows the Replicator Service to log in and copy data from the current source. If the subscription is defined to perform SQL processing on the source data, the user ID also must have permissions that allow those operations.

If the source is a SQL Server system that uses Windows Only authentication, these fields appear dim because the Replicator Service automatically passes the Windows login that is specified in the Log On As section of the Data Replicator Service configuration.

If the source is a SQL Server system that uses SQL Server and Windows (Mixed Mode) authentication, you must enter the Windows login that the Replicator Service is configured to use.