Accessing databases from message flows
Create and configure message flows to access databases.
Before you begin
Complete the following tasks:
Read the following concept topic:
Check which databases are supported on which
platform, and if any restrictions apply:
About this task
You can access a database from a message flow
in two ways:
- You can design a message flow that responds to events generated by the database.
- After a flow has already started, you can access the database to read or update information in it. Information from the database can be used to enhance or influence the operation of the message flow.
You can access a database from a message flow by using the following nodes:
- Compute
- Database
- DatabaseInput
- DatabaseRetrieve
- DatabaseRoute
- Filter
- JavaCompute
- Mapping
For more details about these nodes, and how to configure them in message flows, see Built-in nodes.
If you want the actions that the message flow takes against the database to be coordinated with other actions, configure the message flow to support global coordination of transactions. For information about how to complete this task, see Configuring transactionality for message flows.
To access a database from a message flow:
Procedure
Results
Note: You can also access a database from a message
flow by using the Database Service. For more
information, see Using a Database Service in a message flow.