Edit

Share via

Advanced Connection Properties

  • Article

Important

Change Data Capture for Oracle by Attunity is deprecated now. For details, refer to the announcement.

Use the Advanced Connection Properties dialog box to add more connection parameters to the connection string.

The additional connection parameters can be any ODBC connection parameter that is supported by the SQL Server database instance you are using.

The parameters added using the Advanced Connection Properties dialog box are added to the parameters selected in the Connect to SQL Server dialog box.

The last instance of each parameter provided overrides any previous instances of the parameter. Parameters added using the Advanced Connection Parameters dialog box follow and replace the parameters provided in the SQL Server Connection dialog box. For example, if the SQL Server Connection dialog box specifies SERVER1 as the Server name, and the Additional Connection Parameters page contains ;SERVER=SERVER2, the connection will be made to SERVER2.

Parameters added using the Advanced Connection Properties dialog box are passed as plain text.

Important

Do not include login credentials in the Advanced Connection Properties dialog box. They will not be encrypted when they are passed across the network.

See Also

Access the CDC Designer Console
SQL Server Connection for Instance Creation