> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sync.cdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Informix (Native)

You can use the Informix connector from the CData Sync application to capture data
from Informix and move it to any supported destination. To do so, you need to add
the connector, authenticate to the connector, and complete your connection.

> [!NOTE]
>
> 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 the CDC API as well as to set up Informix to use the CData Sync application's change data capture (CDC) capability.

### Download the Native JDBC Driver and the CDC API

Install the native IBM Informix JDBC driver and the CDC API, as follows:

1. Download the Informix driver and the API from the links below and copy them into `InstallationDirectory/lib`:

   * Informix JDBC driver: [https://repo1.maven.org/maven2/com/ibm/informix/jdbc/4.50.11/jdbc-4.50.11.jar](https://repo1.maven.org/maven2/com/ibm/informix/jdbc/4.50.11/jdbc-4.50.11.jar).
   * Informix CDC API: [https://repo1.maven.org/maven2/com/ibm/informix/ifx-changestream-client/1.1.3/ifx-changestream-client-1.1.3.jar](https://repo1.maven.org/maven2/com/ibm/informix/ifx-changestream-client/1.1.3/ifx-changestream-client-1.1.3.jar)

   > [!NOTE]
   >
   > Because the JAR files are located in `InstallationDirectory`, 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 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.

> [!NOTE]
>
> 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](https://docs.sync.cdata.com/26.2/en/jobs/change-data-capture.md#using-the-sync-cdc-engine).

## Add the Informix Connector

To enable Sync to use data from Informix, you first must add the
connector, as follows:

<ol>
  <li>Open the **Connections** page of the Sync dashboard.</li>
  <li>Click **Add Connection** to open the **Select Connectors** page.</li>
  <li>Click the **Sources** tab and locate
  the **Informix (Native)** row.</li>

  <li>
    Click the **Configure Connection** icon at the end of that row to open
    the **New Connection** page. This action opens the
    **Add Connection** dialog box.

    **Note:** If the **Configure Connection** icon is not
    available, click the **Download Connector** icon to install
    the Informix (Native) connector.
  </li>

  <li>Enter a name for your connection in the **Add Connection** dialog box.</li>
  <li>Click **Add** to open the **Settings** tab for your connector.</li>
</ol>

For more information about installing new connectors, see
[Connections](https://docs.sync.cdata.com/26.2/en/connections/connections.md).

## Authenticate to 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.

## Complete Your Connection

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.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.