odbc.ini configuration

Create an odbc.ini configuration that a deployed integration can use for an Open Database Connectivity (ODBC) connection to a database.

Summary of key details

File name or type
odbc.ini
Does the file contain secrets?
No
Location of imported or extracted data
/home/aceuser/ace-server/odbc.ini/
Maximum number of odbc.ini configurations allowed per integration runtime
One

The odbc.ini file

ODBC is a common standard that is used to connect to databases. App Connect includes ODBC libraries with ODBC drivers, which you can use to configure an ODBC connection for a database.

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

  • An [ODBC Data Sources] stanza lists the data source name (DSN) and associated description of each database.
  • A [DSN] stanza is needed for each DSN that is listed in the [ODBC Data Sources] stanza. Each DSN stanza defines the ODBC driver and other necessary database settings, which can vary based on the database manager.
  • A [ODBC] stanza lists mandatory information.
Note: Make sure that your odbc.ini file contains the correct path to ODBC drivers. IBM® App Connect Enterprise 13.0 is installed into /opt/ibm/ace-13, so when you apply an ODBC configuration to an integration runtime, 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 necessary 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 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 file archive for reference: odbc.zip.

You can specify only one odbc.ini file per integration runtime. The file is placed in the work directory of the runtime for the deployed integration to use when it starts.

To configure your integration to use an ODBC connection to a database, create an odbc.ini configuration on the Configurations tab of the Manage page. For more information, see Providing credentials and secrets in configurations.

You can then import the odbc.ini file into the odbc.ini editor, or paste in the contents.
odbc.ini text editor with pasted contents