Skip to main content
This connector is available in Sync Self-Hosted deployments only.

​
Prerequisites

Before you add your Informix connector, you need to download the JDBC driver and set up Informix to use the CData Sync application’s change data capture (CDC) capability.

​
Download the Native JDBC Driver

Download the Informix JDBC driver and copy it into InstallationDirectory/lib.
Because the JAR file is located in InstallationDirectory, you need to put this file 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 Informix:
  1. Run the following script as the Informix user from the $INFORMIXDIR/etc directory: syscdcv1.sql
  2. Verify that the syscdcv1 database exists by creating a connection to it as the user Informix.
  3. Set the DB_LOCALE environment variable (on your Sync machine) to match the locale of the database from which you are capturing data.
The INTERVAL type is not supported by Informix Change Stream client in the CDC API.
For details about the CDC Engine, see Using the Sync CDC Engine.

​
Informix コネクタを追加

​
Informix への認証

After you add the connector, you need to set the required properties.
  • Host: Enter your IBM Informix host name.
  • Port: Enter the port number that connects to the server that hosts your Informix database. The default port value is 1526.
  • Database: Enter the name of your Informix database.
  • User: Enter the username that you use to authenticate to your Informix database.
  • Password: Enter the password that you use to authenticate to your Informix database.

​
接続を完了する

To complete your connection:
  1. Define advanced connection settings on the Advanced tab. (In most cases, though, you should not need these settings.)
  2. Click Create & Test to create your connection.