skip to main content
Corticon Server: Data Integration Guide : Advanced EDC Topics : How data from an EDC Datasource integrates into rule output
 

Try Corticon Now

How data from an EDC Datasource integrates into rule output

An EDC connector enables interaction with its connected database, its Datasource, to read and write data from rule executions. Without database connectivity, Decision Service execution takes data in the request payload, modifies it through rules, and then returns the data in the response. When EDC is used, the Datasource can enrich the data in the request, and can store result in the database. The following sections show separately the effects in read-only and read-update scenarios. Included in these examples are variations that use the Extend to Database feature to further enrich results.
To enable adequate complexity, the scenarios use data provided and the familiar Cargo.ecore Vocabulary:.
The sample Rulesheet is defined as shown:
Figure 330. Sample Rulesheet for EDC database examples
The Datasource data in this section was established in a Microsoft SQL Server 2014 installation as described in the topic Quick steps for setting up the Cargo sample
Note: If you are just getting started, see the EDC tutorial, Modeling Progress Corticon Rules to Access a Database using EDC. While not precisely the setup used for the examples in this chapter, you will get a detailed walkthrough where the Datasource is Microsoft SQL Server 2014.
* When Datasource access is Read Only
* When Datasource access is Read/Update