Before you begin
Read the following topic: Configuring databases.
Note: In IBM® Integration Bus Version 10.0, 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 Integration Bus 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.
- 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. 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 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
Results
You have now enabled the integration
node to make connections to your databases.
What to do next
If you have been using the instructions in Working with databases, the next task is Configuring ODBC connections for globally coordinated transactions (optional).