skip to main content
Corticon Server: Data Integration Guide : Advanced ADC Topics : Configuring ADC : Configuring ADC writes
 

Try Corticon Now
Configuring ADC writes
The database schema that ADC writes use is illustrated in the following diagram.
A core operation that ADC performs is updating data using the CORTICON_ADC_WRITE table. Each CORTICON_ADC_WRITE row instance can use a different Datasource.
Figure 372. Database Schema for Corticon ADC Write Service Callouts
Note: The schema notes in the following tables are brief. For more details about a column name, see Configuration details
Table 42. CORTICON_ADC_WRITE Table
Column Name : DataType
Note
ID : Integer
The Primary Key for the Table which then gets propagated down to each CORTICON_ADC_WRITE_DEFS record.
NAME : String
The logical name to associate with this CORTICON_ADC_WRITE. This is the name that will be specified in a Ruleflow Service Call-out's Runtime Properties tab as the Query Name.
Table 43. CORTICON_ADC_WRITE_DEFS Table
The CORTICON_ADC_READ_DEFS and CORTICON_ADC_WRITE_DEFS Tables are the key Tables for ADC. These Tables contain the most pertinent information for the ADC to perform its duties.
Column Name : DataType
Note
ID : Integer
The Primary Key for the Table
WRITE_ID : Integer
Foreign Key back to CORTICON_ADC_WRITE.ID column. There can be many CORTICON_ADC_WRITE_DEFS associated with a CORTICON_ADC_WRITE record.
SEQUENCE : Integer
The integer value that specifies the order of execution of each CORTICON_ADC_WRITE_DEFS within a given CORTICON_ADC_WRITE_ID when several CORTICON_ADC_WRITE_DEFS are associated with a CORTICON_ADC_WRITE record.
SQL : String
SQL Statement used as a template for this CORTICON_ADC_WRITE_DEFS operation.
PRIMARY_ENTITY : String
The Entity name that will be used to look up all instances of this Entity type from working memory in which variable substitution will be applied to the SQL statement to create one INSERT or UPDATE statement per Entity instance.
ENABLE : String (true or false)
Suppresses or allows the CORTICON_ADC_WRITE_DEFS to execute. If this value is null or any value other than false, the default value is true.
Note: For more about the format of Corticon's queries, see How Corticon is expressed in SQL.