Integration server configuration type

odbc.ini type

Use the odbc.ini type to create configurations that the integration server will use for an Open Database Connectivity (ODBC) connection to a database.


Summary of key details for the configuration type

File name or type Contains secrets Path extracted/imported to Maximum allowed per integration server
odbc.ini No /home/aceuser/ace-server/odbc.ini 1

Creating the file for a configuration object of type odbc.ini

The odbc.ini type requires an odbc.ini file that the integration server will use. This file is made up of stanzas (or sections) that contain settings in the format key=value for connecting to user-specific data sources:

  1. [ODBC Data Sources] stanza:

    Lists the data source name (DSN) and associated description of each database.

  2. [DSN] stanzas:

    Requires a stanza for each DSN that is listed in the [ODBC Data Sources] stanza. Each DSN stanza defines the ODBC driver and other required database settings, which can vary based on the database manager.

  3. [ODBC] stanza:

    Lists mandatory information.

Note: Ensure that your odbc.ini file contains the correct path to ODBC drivers.
  • IBM® App Connect Enterprise 12 is installed into /opt/ibm/ace-12, so if you want to apply an ODBC configuration to an integration server at version 12.0.1.0-r1 or later, you must update all the driver path properties in the odbc.ini file to point to this path. For example:

    DRIVER=/opt/ibm/ace-12/server/ODBC/dsdriver/odbc_cli/clidriver/lib/libdb2o.so

  • IBM App Connect Enterprise 11 is installed into /opt/ibm/ace-11, so if you want to apply an ODBC configuration to an integration server at version 11.0.0.F-rX (or rX-eus), you must update all the driver path properties in the odbc.ini file to point to this path.

To help you complete your odbc.ini file with the required settings for a database vendor, see Connecting to a database from Linux and UNIX systems by using the IBM Integration ODBC Database Extender in the IBM App Connect Enterprise documentation. The procedure in this topic provides information about the stanza entries that are applicable for different database managers and includes examples of these entries.

A sample odbc.ini file is provided in the attached ZIP archive for reference: odbc.zip.

Only one odbc.ini file can be specified per integration server. (The file is placed in the integration server work directory for use by the integration server when it starts.)

After you create the file, you can use it to create a configuration object as described in Configuration reference: Creating an instance from the Red Hat OpenShift web console and Creating an instance from the Red Hat OpenShift CLI.

For examples of how to use this configuration type, see Tutorials and examples.