Adding ODBC Parameters for Connecting to a PostgreSQL Source Database
Adding ODBC Parameters for Connecting to a PostgreSQL Source Database
PowerExchange uses the DataDirect ODBC driver for PostgreSQL to connect to PostgreSQL source databases. You can define the ODBC_CONN_PARAMS statement in the dbmover.cfg file if you want to add ODBC parameters to the connection strings that are used on the servers you specify for the following processing:
Change data capture
Creating, deleting, or modifying capture registrations from the PowerExchange Navigator or DBLUCBRG utility
For example, you might need to add ODBC parameters if your site policies require database connections to use SSL encryption, specific cryptographic protocols, or self-signed or third-party signed SSL certificates.