Database Activity

Process Designer provides a Database Activity node for accessing data from the database. You can configure the connection type and the command for interacting with DB like insert, update, select or delete data. Follow the below steps to configure your database activity.

First, create the Input/Output process parameter

Drag and drop the Database node into your process flow. This example shows a process with only database activity. So, drop your database node between the start and end node and then link it between the Start node and the End node

Double click on the Database node to open the configurations panel.

Click the BusinessObject tab and choose the Business Object from the list for input and output

Click the Database parameter tab. Users can set the database connection either using JNDI or JDBC connection setting.

• JNDI

• JDBC

Map the Activity parameter to the Database parameter for input and output.

Save the process.

You can now test the flow using the Simulator Utility

• Enter the value of the input (using double quote) to get output then click Start.

• Database node access data from the database and display the queried data on the screen.