> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# IBM Informix SSH Connector

## Intro

IBM Informix is a fast and scalable database server that manages traditional relational, object-relational, and dimensional databases. Use Domo's Informix SSH connector to retrieve Informix data based on an SQL query. To learn more about Informix, visit their page ([https://www.ibm.com/analytics/us/en/...logy/informix/](https://www.ibm.com/analytics/us/en/technology/informix/ "https://www.ibm.com/analytics/us/en/technology/informix/") ).

You connect to Informix data in the Data Center. This topic discusses the fields and menus that are specific to the Informix connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in [Adding a DataSet Using a Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Connector").

## Prerequisites

To connect to your Informix account and create a DataSet, you must have the following:

* SSH Hostname, User name, Password
* SSH port
* Database Hostname
* Database Name
* Database Port Number
* Database Username and Password
* Informix Server Name

Before you can connect to an Informix database, you must also whitelist a number of IP addresses on your database server on the port you want to connect to. For the full list of IP addresses, see Whitelisting IP Addresses for Connectors.

<Note>
  **Note:** Domo does not support the SSH keys generated using ssh-keygen. The SSH keys need to be the DES or RSA keys (in PEM format) generated by OpenSSL.
</Note>

## Connecting to Your Informix Account

This section enumerates the options in the **Credentials** and **Details** panes in the Informix Connector page. The components of the other panes in this page, **Scheduling** and **Name & Describe Your DataSet**, are universal across most connector types and are discussed in greater length in [Adding a DataSet Using a Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Connector").

### Credentials Pane

This pane contains fields for entering credentials to connect to your Informix account. The following table describes what is needed for each field:

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:195;a"><thead><tr><th colspan="1" rowspan="1"><p><span class="s1"> Field </span></p></th><th colspan="1" rowspan="1"><p><span class="s1"> Description </span></p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"><p> SSH Hostname </p></td><td colspan="1" rowspan="1"><p> Enter the hostname or URL of the UNIX server to SSH-tunnel through. </p></td></tr><tr><td colspan="1" rowspan="1"><p> SSH User </p></td><td colspan="1" rowspan="1"><p> Enter the SSH username for your UNIX account. </p></td></tr><tr><td colspan="1" rowspan="1"><p> SSH Password </p></td><td colspan="1" rowspan="1"><p> Enter the SSH password for your UNIX account. </p></td></tr><tr><td colspan="1" rowspan="1"><p> SSH Key </p></td><td colspan="1" rowspan="1"><p> Enter the SSH private key. </p></td></tr><tr><td colspan="1" rowspan="1"><p> SSH Port </p></td><td colspan="1" rowspan="1"><p> Enter the port number for your UNIX account. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Database Hostname </p></td><td colspan="1" rowspan="1"><p> Enter the host name for the Informix database. For example: <span class="mt-font-courier-new"> db.company.com. </span></p></td></tr><tr><td colspan="1" rowspan="1"><p> Database Name </p></td><td colspan="1" rowspan="1"><p> Informix database name. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Database Port Number </p></td><td colspan="1" rowspan="1"><p> Enter your Informix port number. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Database Username </p></td><td colspan="1" rowspan="1"><p> Enter your Informix username. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Database Password </p></td><td colspan="1" rowspan="1"><p> Enter your Informix password. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Informix Server Name </p></td><td colspan="1" rowspan="1"><p> Enter the name of your Informix server. </p></td></tr></tbody></table>

Once you have entered valid Informix credentials, you can use the same account any time you go to create a new Informix DataSet. You can manage connector accounts in the **Accounts** tab in the Data Center. For more information about this tab, see [Manage Connector/Adapter Accounts](https://domo-support.domo.com/s/article/360042926054?language=en_US "Manage Connector/Adapter Accounts").

### Details Pane

This pane contains a single menu in which you enter your SQL query.

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:195;a"><thead><tr><th colspan="1" rowspan="1"><p> Menu </p></th><th colspan="1" rowspan="1"><p> Description </p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"><p> Query </p></td><td colspan="1" rowspan="1"><p> Enter the SQL query for the Informix data you want to pull into Domo. </p></td></tr></tbody></table>

### Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see [Adding a DataSet Using a Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Connector").