Enabling ODBC connections to the databases

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 broker 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.

• To set up JDBC connections to databases, see Enabling JDBC connections to the databases.
• On z/OS® systems, see Data sources on z/OS for information about enabling connections to databases. You do not have to follow the tasks that are described in this section.
• On Linux and UNIX systems, unixODBC is the supported driver manager and is installed by default as part of the IBM® Integration ODBC Database Extender SupportPac. The SupportPac is automatically installed in silent mode when the installation of the IBM Integration Bus component completes. For more information, see Installing the IBM Integration ODBC Database Extender. DataDirect database drivers continue to be used by the unixODBC driver manager when interfacing with Oracle, Sybase, and SQLServer databases.
• On Linux and UNIX systems, delete the ODBCINI64 environment variable if it exists; it is not required by IBM Integration Bus Version 9.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 a broker environment; consider your requirements carefully before specifying other parameters in your tailored ODBC .ini files.

To enable connections on distributed systems: