You can configure a JDBC provider configurable service by running the mqsicreateconfigurableservice command.
The integration node named Server1 is created and started.
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.
The following table lists the database resource names in the development environment, and in the runtime environment:
Development database resource names | Runtime database resource names | |
---|---|---|
Database name | CLIENTS | PCLIENTS |
Schema name | ADDRESSBOOK | PADDRESSBOOK |
Tables names | PERSON, ADDRESS, PHONE | PERSON, ADDRESS, PHONE |
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
A JDBC provider configurable service is available at run time.
Secure the JDBC connection. For more information, see Securing the JDBC provider configurable service.