How do I connect to external database from Cflow?

In Cflow, you can connect to an external database using a simple configuration instead of writing complex code. This will help you to connect to your in-house database and pull and push information easily. Follow the steps below to set up the configuration.

In the Control Center, click on the edit icon in a workflow then select the external database menu and click on Add new to create an external database connection.

Workflow edit

If you want to trigger the external database connection when a new form is initiated in Cflow, turn on the toggle Trigger on Form Load.  You can also trigger the function/stored procedure call in the database when a field value is entered. In this case, when a field value is entered in the form, the stored procedure call is triggered.

The following properties must be defined to connect with an external database:

DB Connection Properties:

Database type – The type of database such as SQL Server, MySQL, Oracle, postgreSQL.

Server Name – The name of the external database server where the new database is to reside.

Username – The name of the user account having the right access to the database.

Password – The password for the user account.

Database name – The name of the database.

Procedure Properties:

Procedure Name – The name of the stored procedure to be called from the database to perform a specific action.

Input Parameters – The Input parameters that are passed to the procedure.

Output Parameters – Select the Output Parameters from the list of field values where you want to return the values in a form.

external db

external db output

Leave a Reply

Your email address will not be published. Required fields are marked *