Let us try to solve a real-time business case where bridge is used to access a MySQL database inside a private network. 

Zylker Corp maintains all their data in a MySQL database inside their secure private network. They use Qntrl for automating different workflows. In one such workflow—Leave Approval, they are looking to retrieve the employees' remaining leave balance for the current year and display it in Qntrl. If the leave balance is sufficient, the card will be sent to the employee’s manager for approval. Else, if the leave balance is nil or less than the requested number of leaves, the card must be automatically rejected.

Also, once the leave is approved in Qntrl, the remaining leave balance must be updated in the client’s MySql database as well, thus maintaining uniform data throughout.

Step 4: Create a Connection

1. Orchestly.job.ALL
   
2. Orchestly.message.CREATE
   
3. Orchestly.message.UPDATE

The Function has to be executed 'on-create' stage of a card by configuring in Business Rule.

Here’s the sample code to update employee details to SQL database:

1. leave_days = daysBetween(from_date,to_date);
2. remaining_days = remaining_leaves.toLong() - leave_days +1;
3. params = Map();
4. data = '{"task_name": "db_dml_task","credential": {"name": "mssql1"},"task_details": {"database": "Employee","db_query": {"update":["UPDATE Employee set Remaining_leaves = ' + "'" + remaining_days + "'" + ' where Employee_id =' + "'" + emp_id + "'" + '"]},"port": 1433,"query_timeout": 10000,"host": "localhost","sql_type": 3,"connection_timeout": 10000}}';
5. params.put("data",data);
6. resp = invokeurl
7. [
8. //Upadte org name and message ID here
9. url :" https://core.qntrl.com/blueprint/api/<org-name>/message/<message_ID>"
10. type :POST
11. parameters:params
12. connection:"<connection_name>"
13. ];
14. info resp;
15. job_params = Map();
16. job_params.put("<parameter-for-custom-field-remaining leaves>",remaining_days);
17. r = invokeurl
18. [
19. //Upadte org name here
20. url :" https://core.qntrl.com/blueprint/api/<org-name>/job/" + job_id
21. type :POST
22. parameters:job_params
23. connection:"<connection_name>"
24. ];
25. info r;