Calling a Database From a Process

This section explains how to use a service task to establish a Java Database Connectivity (JDBC) connection to an external database and execute either a stored procedure or an ad-hoc SQL query.

You can use a service task to establish a JDBC connection to an external database and execute a database operation - either a stored procedure, or a SQL query (a SELECT, INSERT, UPDATE or DELETE statement).

Note: See the BPM Installation guide for details of supported database types.
Step Task description For more information, see...
1 (Optional) Define a database connection profile.

Do this if you want to be able to introspect the database at design-time to help you define a SQL query, or automatically generate a business object model class to hold the return value from your database call.

 Defining and Using a Database Connection Profile
2 Configure a system participant to identify the target database. Using a System Participant to Identify the Target Database
3 Configure a service task to i) call the target database and ii) execute either a SQL query or a stored procedure. Configuring a Service Task to Call a Database
4 Map the input and output parameters defined in your database call to corresponding data fields or parameters in the process. Mapping Data Between the Process and the Database
5 When you deploy the project, bind the system participant to a resource instance that identifies the target run-time database.