Specify Connection Authentication on a SQL/MX Target
Add the following parameters to the Replicat parameter file to specify ODBC connection authentication for Replicat to use on the target SQL/MX database.
TARGETDBDSN
USERIDuser
, PASSWORDpassword
-
Use the
TARGETDB
andUSERID
parameters as one entry. -
Supply the ODBC data source name with
TARGETDB
. -
Supply the user name and password with
USERID
.
Parent topic: Preparing the System for Oracle GoldenGate