Reference Manual

10.5.2
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

ODBC_CONN_PARAMS Statement

The ODBC_CONN_PARAMS statement specifies DataDirect ODBC parameters to add to connection strings that are used to connect to Microsoft SQL Server, MySQL, or PostgreSQL sources on the servers you identify. These additional parameters are used for change data capture and for creating, deleting, or modifying capture registrations from the PowerExchange Navigator or DTLUCBRG utility.

For example, you might need to add ODBC parameters if your site has database connection requirements such as SSL encryption, specific cryptographic protocols, or use of self-signed or third-party signed SSL certificates.

Linux, UNIX, and Windows

None

ODBC_CONN_PARAMS=(DBTYPE={MSQL|MYSQL|PG}
,SERVER=server_pattern[,port_pattern]
,ADDL_PARAMS=parameter1,parameter2,...
)

DBTYPE: Specifies the type of source database for which to specify additional DataDirect ODBC connection parameters. This value must match the TYPE parameter value in the CAPI_CONNECTION statement for the source. Options are:

MSQL
. For Microsoft SQL Server sources.
MYSQL
. For MySQL sources.
PG
. For PostgreSQL sources.

No default is provided.
SERVER=server_pattern[,port_pattern]: Identifies the database server or servers for which to use the additonal ODBC parameters for connecting to the source database. Optionally, you can include a port number or port number pattern.

To specify a server or port pattern, include the asterisk (*) wildcard, which represents zero or more characters, or the question mark (?) wildcard, which represents a single character. Separate the server and port values with a comma.
ADDL_PARAMS: Specifies one or more ODBC parameters to add to the connection string that is sent to the DataDirect driver for connecting to the source. These parameters are used on the servers that match the server name pattern and have an available port that matches the port pattern.

Specify parameters that your DataDirect driver supports in odbc.ini files. For more information, see the DataDirect documentation for your driver type. However, do not
use any of the following ODBC parameters that are not supported by this DBMOVER statement:

For Microsoft SQL Server sources
: DRIVER, HOST, PORT, DB, AM, DOMAIN, UID, and PWD
For MySQL sources
: DRIVER, HOST, PORT, DB, UID, and PWD
For PostgreSQL sources
: DRIVER, HOST, PORT, DB, UID, and PWD

No validation is performed on the ODBC parameters you add. Verify that your parameter entries are valid.

The following example statement adds the ODBC EncryptionMethod (EM) and ValidateServerCertificate (VSC) parameters for connections to a Microsoft SQL Server source on any server that has a name beginning with "usw1P" and ending with "VG2F" and an available port with a four-digit port number beginning with "143":

ODBC_CONN_PARAMS=(DBTYPE=MSQL, SERVER="usw1P*VG2F,143?", ADDL_PARAMS="EM=6;VSC=0")

You can specify multiple ODBC_CONN_PARAMS statements in the same DBMOVER configuration file, for example, for different source database types or servers.

Rename Saved Search

Table of Contents

Reference Manual

Reference Manual

ODBC_CONN_PARAMS Statement

ODBC_CONN_PARAMS Statement