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

See information about the latest product version

Creating a Database Service

Use the Database Service editor to create a Database Service that can be used in a message flow to automatically configure connectivity to a database.

Before you start:

A Database Service defines the interaction between IBM® Integration Bus and a database. For more information, see Database Service.
Verify with your system administrator what the ODBC data source name (DSN) is for your runtime environment. If no ODBC DSN exists, arrange for one to be defined. For more information, see Enabling ODBC connections to the databases.

Note: A Database Service has the following limitations:

It can be used only with a Compute node.
It can interact only with a DB2® database.
Each Database Service can support operations only on a single table in your database.

Create a Database Service in the Database Service editor. The Database Service editor combines metadata that is discovered from a database definition file (.dbm file), with information supplied by a flow developer, to create a Database Service definition that contains the information that is required for the database interaction.

Each Database Service can interact only with one database, and can support service operations only on a single table in the database. Use the Database Service editor to define the service operations that are required. Create one Database Service for each database table you must interact with.

To create a Database Service, complete the following steps:

Open the Database Service editor by using one of the following methods:
- Click File > New > Database Service.
- If no files are open in the editor view, the Quick Starts wizards are shown; click Start by discovering a service, and from the Discover from list select Database.
Specify names for the library and the service, and click Finish. The Database Service editor is displayed.
Complete the Database Service editor panels.
- Database Definition: Discover the database definition by using one of the following methods:
  - Specify the name of an existing database artifact to import (.dbm file).
  - Click New to create a new database definition file for the database.
  Note: Ensure that the ODBC data source name (DSN) that is automatically generated, matches the runtime environment ODBC DSN for the database. For more information, see Configuring databases.
- Select Resources: Select a table on which you want to expose operations.
- Service Operations: Add the required SELECT, UPDATE, INSERT, or DELETE service operations.
- Service Interface: Review a summary of the logical interface and service operations that you defined.
- Summary: Review the service structure and the list of artifacts that the Database Service editor created.
  Note: Use the breadcrumb navigation at the top of the Database Service editor to edit the Database Service definition as required.
A Database Service is created and is shown in the editor. You can expand the service in the Application Development view to view its operations and associated resources.
Note: In the Integration Development perspective the Problems view will display the following message:
```
WS-I BP 1.1: (BP2402) The service does not contain any binding that uses a SOAP 1.1 binding.
```
This is a standard WSDL validation message that can be ignored, as the Database Service does not use a SOAP binding. Alternatively, to turn off the WS-I compliance checking, click Window > Preferences > General > Service Policies, then under Profile Compliance select WS-I BP 1.1 + SSBP 1.0 and set the compliance level to Ignore compliance.

Next:

Use the Database Service with a message flow node. For more information, see Using a Database Service in a message flow.

bc46205_.htm |

Last updated Friday, 21 July 2017