Microflow Designer provides a Database 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. This example shows a flow with only a database node. 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 to get output then click Start.
Database node access data from the database and display the queried data on the screen
