Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  15. Appendix B: PowerExchange Glossary

ODBC_CONN_PARAMS Statement

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
No
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.