Prerequisites
Before you add your connector, you need to download the JDBC driver and the CDC API as well as to set up Informix to use the application’s change data capture (CDC) capability.Download the Native JDBC Driver and the CDC API
Install the native IBM JDBC driver and the CDC API, as follows:-
Download the driver and the API from the links below and copy them into
InstallationDirectory/lib:- JDBC driver: https://repo1.maven.org/maven2/com/ibm/informix/jdbc/4.50.11/jdbc-4.50.11.jar.
- CDC API: https://repo1.maven.org/maven2/com/ibm/informix/ifx-changestream-client/1.1.3/ifx-changestream-client-1.1.3.jar
Because the JAR files are located inInstallationDirectory, you need to put these files on every machine that you use for a cluster environment.
Set Up Informix for CDC
Perform the following steps to enable the Change Data Capture API in :-
Run the following script as the Informix user from the
$INFORMIXDIR/etcdirectory:syscdcv1.sql - Verify that the syscdcv1 database exists by creating a connection to it as the user Informix.
- Set the DB_LOCALE environment variable (on your machine) to match the locale of the database from which you are capturing data.
The INTERVAL type is not supported by Change Stream client in the CDC API.
Add the Informix Connector
Authenticate to Informix
After you add the connector, you need to set the required properties.- Host: Enter your IBM host name.
- Port: Enter the port number that connects to the server that hosts your database. The default port value is 1526.
- Database: Enter the name of your database.
- User: Enter the username that you use to authenticate to your database.
- Password: Enter the password that you use to authenticate to your database.
Complete Your Connection
To complete your connection:- Define advanced connection settings on the Advanced tab. (In most cases, though, you should not need these settings.)
- Click Create & Test to create your connection.