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 340. Sample Rulesheet for EDC database examples
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.