Enabling ODBC connections to the databases

Set up the resources and environment that the integration node requires for Open Database Connectivity (ODBC) connections to databases on distributed systems.

Before you begin

Read the following topic: Configuring databases.

Note: In IBM® App Connect Enterprise, you do not need to install the IBM Integration ODBC Database Extender program to use database nodes in your applications. The program code is installed as part of the IBM App Connect Enterprise installation.

About this task

You can configure both ODBC and Java™ Database Connectivity (JDBC) connections for access to databases:

  • To set up ODBC connections to databases, follow the instructions in this section.

    Optionally, after configuring the ODBC connection parameters, run the mqsicvp command to verify that the integration node can connect to the data source, and to provide useful information about the data source and its interface.On Linux® and UNIX systems, this command also checks that the ODBC environment is set up correctly.

  • On Linux and UNIX systems, IBM Integration ODBC Database Extender, which encapsulates unixODBC, is provided as the driver manager. IBM App Connect Enterprise provides DataDirect ODBC drivers for interfacing with Oracle, Sybase, and SQLServer databases. On Linux x86-64, IBM App Connect Enterprise also provides a DataDirect ODBC driver for interfacing with a PostgreSQL database. For other databases, you must provide the appropriate ODBC driver.

    On Windows, the ODBC driver manager is provided by the operating system. IBM App Connect Enterprise provides DataDirect ODBC drivers for interfacing with Oracle, PostgreSQL, and Sybase. For other databases, you must provide the appropriate ODBC driver.

  • To set up JDBC connections to databases, see Enabling JDBC connections to the databases.
  • On Linux and UNIX systems, delete the ODBCINI64 environment variable if it exists; it is not required by IBM Integration Bus 10.0. For more information, see Database connections. The sample odbc.ini and odbcinst.ini files that are supplied, and the information that is contained in these configuration topics, include all the connection parameters that are supported for connections to your databases. Any additional parameters that are provided by your chosen database drivers are not tested or supported in an IBM App Connect Enterprise environment; consider your requirements carefully before specifying other parameters in your tailored ODBC .ini files.

To enable connections on distributed systems:

Procedure

Define the ODBC DSNs according to your platform:
Windows platformOn Windows:
Follow the instructions in Connecting to a database from Windows systems.
Linux platformUNIX platformOn Linux and UNIX systems:
For all supported databases, follow the instructions in Connecting to a database from Linux and UNIX systems by using the IBM Integration ODBC Database Extender.
You have now configured the ODBC DSNs for your databases.

Results

You have now enabled the integration node to make connections to your databases.