Connecting to IBM Informix

Prev Next

When connecting to a IBM Informix database from the Syniti Knowledge Platform (SKP), provide the following connection properties to establish a secure and reliable connection. This article explains each property to understand what information is required and how it is used.

Property

Description

Notes

Name

(required)

Name of the IBM Informix connection unique to the SKP.

Not applicable

Description

Enter a description that briefly states the purpose of this connection.

Not applicable

Hostname
(required)

The network name or IP address of the IBM Informix machine you want to connect to.

Not applicable

Server

(required)

The name of the Informix server instance to connect to on the host machine.

Multiple server instances can run on a single hostname. Specify the required server instance.

Service

The service name or port number used for the connection.

Can reference a named service from the sqlhosts file or specify a TCP port number (typically 9088). If omitted, the driver uses default sqlhosts configuration.

Username
(required)

The database account identifier used for authentication when establishing the connection.

The account must have the necessary privileges for the operations being performed.

Password
(required)

The password for the username above.

This value is used to authenticate the connection to the database.

Database

The name of the specific Informix database instance to connect to on the server.

Informix servers can host multiple logical databases.

Protocol

The network protocol used to establish the connection. TCP/IP-based protocols are standard for remote connections.

onsoctcp (Informix native protocol over TCP/IP for database server connections)

drsoctcp (DRDA over TCP/IP for DRDA aliases)

drtlitcp (DRDA over TCP/IP - alternative).

Extended Properties

Use the + Add Property button to add any additional connection properties.

Not applicable

Create a Connection