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.
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 Integration Bus provides DataDirect ODBC drivers for interfacing with Oracle, Sybase, and SQLServer databases. For other databases, you must provide the appropriate ODBC driver.
On Windows, the ODBC driver manager is provided by the operating system. IBM Integration Bus provides DataDirect ODBC drivers for interfacing with Oracle 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 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, delete the ODBCINI64 environment variable if it exists; it is not required by IBM Integration Bus Version 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 Integration Bus environment; consider your requirements carefully before specifying other parameters in your tailored ODBC .ini files.
To enable connections on distributed systems:
Procedure
On Windows:- Follow the instructions in Connecting to a database from Windows systems.
On 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.