IBM Integration Bus, Version 10.0.0.3 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS


Configuring a JDBC provider configurable service

You can configure a JDBC provider configurable service by running the mqsicreateconfigurableservice command.

Before you begin

The integration node named Server1 is created and started.

About this task

The IBM® Integration Toolkit connects to the database CLIENTS and runs discovery so the Graphical Data Mapping editor can use the database definition to visualize the database tables PERSON, ADDRESS, and PHONE.

At run time, the Mapping node uses a JDBC provider configurable service named CLIENTS to obtain the configuration parameters that will enable it to make the connection to the runtime database PCLIENTS that the message map will execute against.

You configure the runtime database resources by defining the JDBC provider configurable service properties. You must set the following properties:
  • databaseName property: You must set its value to be the runtime database name PCLIENTS.
  • databaseSchemaNames property: You must set its value to use at run time the database schema PADDRESSBOOK.
Note: The table names must be the same in the database development environment and in the run time database environment.

The following table lists the database resource names in the development environment, and in the runtime environment:

Table 1. Scenario database resource names
  Development database resource names Runtime database resource names
Database name CLIENTS PCLIENTS
Schema name ADDRESSBOOK PADDRESSBOOK
Tables names PERSON, ADDRESS, PHONE PERSON, ADDRESS, PHONE

Procedure

To configure the JDBC provider configurable service CLIENTS, run the mqsicreateconfigurableservice command:

mqsicreateconfigurableservice Server1 -c JDBCProviders -o CLIENTS -n databaseName,databaseSchemaNames -v PCLIENTS,PADDRESSBOOK

where

Results

A JDBC provider configurable service is available at run time.

What to do next

Secure the JDBC connection. For more information, see Securing the JDBC provider configurable service.


scnmap_02_19_.htm | Last updated 2015-11-25 08:25:30