IBM Informix connection | IBM Cloud Pak for Data as a Service

IBM Informix connection

To access your data in an IBM Informix database, create a connection asset for it.

IBM Informix is a database that contains relational, object-relational, or dimensional data. You can use the Informix connection to access data from an on-prem Informix database server or from IBM Informix on Cloud.

Supported Informix versions (on-prem)

Informix 14.10 and later. This version does not support the Progress DataDirect JDBC driver, which is used by the Informix connection. The Informix connection supports Informix 14.10 features that are comparable to previous Informix versions, but not the new features. Issues related to DataDirect's JDBC driver are not supported.
Informix 12.10 and later
Informix 11.0 and later
Informix 10.0 and later
Informix 9.2 and later

Create a connection to Informix

To create the connection asset, specify these connection details:

Database server name
Database name You don't have to specify the database. With no database specified, you can import metadata from every database that is available for that connection.
Hostname or IP address
Port number The default is 1526.
Username and password

On-prem Informix database servers: For Private connectivity, to connect to a database that is not externalized to the internet (for example, behind a firewall), you must set up a secure connection.

Choose the method for creating a connection based on where you are in the platform

In a project: Click Assets > New asset > Connect to a data source. See Adding a connection to a project.
In a catalog: Click Add to catalog > Connection. See Adding a connection asset to a catalog.
In a deployment space: Click Import assets > Data access > Connection. See Adding data assets to a deployment space.
In the Platform assets catalog: Click New connection. See Adding platform connections.