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 begin
- 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.
- 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.
About this task
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.
Procedure
What to do next
Use the Database Service with a message flow node. For more information, see Using a Database Service in a message flow.