> ## 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)

export const CommonDatasourceAddConnector = ({datasource = "the data source", title = "the connector", destination = false, siteNameShort = "Sync"}) => {
  return <>
      <p>
        To enable {siteNameShort} to use data from {datasource}, you first must add the
        connector, as follows:
      </p>
      <ol>
        <li>Open the <strong>Connections</strong> page of the {siteNameShort} dashboard.</li>
        <li>Click <strong>Add Connection</strong> to open the <strong>Select Connectors</strong> page.</li>
        <li>
          Click the <strong>{destination ? "Destinations" : "Sources"}</strong> tab and locate
          the <strong>{title}</strong> row.
        </li>
        <li>
          Click the <strong>Configure Connection</strong> icon at the end of that row to open
          the <strong>New Connection</strong> page. This action opens the{' '}
          <strong>Add Connection</strong> dialog box.
          <br />
          <strong>Note:</strong> If the <strong>Configure Connection</strong> icon is not
          available, click the <strong>Download Connector</strong> icon to install
          the {title} connector.
        </li>
        <li>Enter a name for your connection in the <strong>Add Connection</strong> dialog box.</li>
        <li>Click <strong>Add</strong> to open the <strong>Settings</strong> tab for your connector.</li>
      </ol>
      <p>
        For more information about installing new connectors, see{' '}
        <a href="../connections">Connections</a>.
      </p>
    </>;
};

export const CommonDatasourceIntroSource = ({datasource = "the data source", siteName = "CData Sync"}) => {
  return <p>
      You can use the {datasource} connector from the {siteName} application to capture data
      from {datasource} and move it to any supported destination. To do so, you need to add
      the connector, authenticate to the connector, and complete your connection.
    </p>;
};

export const driverVersion = "M";

export const siteNameShort = "Sync";

export const siteName = "CData Sync";

export const datasource = "Informix";
export const pageTitle = "Informix (Native)";
export const advancedurl = "JI";

<CommonDatasourceIntroSource datasource={datasource} siteName={siteName} />

<Note>This connector is available in {siteNameShort} Self-Hosted deployments only.</Note>

## Prerequisites

Before you add your {datasource} connector, you need to download the JDBC driver and set up Informix to use the {siteName} application's change data capture (CDC) capability.

### Download the Native JDBC Driver

Download the [{datasource} JDBC driver](https://repo1.maven.org/maven2/com/ibm/informix/jdbc/15.0.1.1/jdbc-15.0.1.1.jar) and copy it into `InstallationDirectory/lib`.

<Note>Because the JAR file is located in `InstallationDirectory`, you need to put this file on every machine that you use for a cluster environment.</Note>

### Set Up Informix for CDC

Perform the following steps to enable the Change Data Capture API in {datasource}:

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 {siteNameShort} machine) to match the locale of the database from which you are capturing data.

<Note>The INTERVAL type is not supported by {datasource} Change Stream client in the CDC API.</Note>

For details about the CDC Engine, see [Using the {siteNameShort} CDC Engine](../../jobs/change-data-capture#using-the-sync-cdc-engine).

## Add the Informix Connector

<CommonDatasourceAddConnector datasource={datasource} title={pageTitle} destination={false} siteNameShort={siteNameShort} />

## Authenticate to Informix

After you add the connector, you need to set the required properties.

* **Host:** Enter your IBM {datasource} host name.
* **Port:** Enter the port number that connects to the server that hosts your {datasource} database. The default port value is **1526**.
* **Database:** Enter the name of your {datasource} database.
* **User:** Enter the username that you use to authenticate to your {datasource} database.
* **Password:** Enter the password that you use to authenticate to your {datasource} 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.