skip to main content
Corticon Studio: Rule Modeling Guide : Writing Rules to access external data

Try Corticon Now

Writing Rules to access external data

Corticon provides two mechanisms that let you interface your rules with commercial databases:
*Enterprise Data Connector (EDC) — This technique provides access to a single database from a project Vocabulary. You map your Vocabulary to the database and rely on Corticon to retrieve data when needed. EDC makes data access very simple and is a great option when small amounts of data are needed or performance is not paramount. EDC is tightly integrated with rule models, so the functions described in this chapter are how you effectively create queries to the database.
*Advanced Data Connectors (ADC) — This technique provides control over the SQL queries used to retrieve or update data in a database. Using ADC requires more database knowledge but provides benefits such as optimized query performance when retrieving large amounts of data, and the ability to map a vocabulary to multiple data sources. ADC is recommended when performing batch rule processing.
For additional information, see the Corticon Server: Data Integration Guide


CorticonEDC lets you define mappings to a database so that rules can access (query) a database directly, and then retrieve what it needs during execution, thus enriching the information available to the rules, and then writing data to the database when appropriate.
This capability is transparent to the rule modelers so that they are only concerned with getting the rules right, and do not have to get wrapped up in SQL syntax to interface with the EDC database.
This chapter focuses on the aspects of rule modeling that are affected by a defined Corticon Enterprise Data Connector.
The first steps you should take are to follow the procedures in Getting Started with EDC.
* A Scope refresher
* Quick steps for setting up the Cargo sample
* Enabling Database Access for Rules using root-level Entities
* Precondition and Filters as query filters
* Inserting new records in a middle table
* Integrating EDC Datasource data into rule output
* Test yourself questions: Writing rules to access external data