skip to main content
Corticon Server: Data Integration Guide : Getting Started with Multiple Database Connectivity : Test the rules when writing to multiple databases

Try Corticon Now

Test the rules when writing to multiple databases

In the database, the approval status is being evaluated but it is not being entered into the database, as shown:
On the Ruleflow canvas, click on the Save Approvals Service Call-out on the canvas. Its Query Name is UpdateTreatment whose query SQL is:
UPDATE Treatment SET approved={Treatment.approved} WHERE treatmentId={Treatment.treatmentId}
When you run the Testsheet, the approval values are written to the database for patient treatments, as shown:

Where to now?

The flow of this document leads to Deploying projects that use data integration, an important preparation for Getting Started with Batch. Beyond that, the material focuses less on the samples by using various configurations to present advanced topics.