skip to main content
Corticon Server: Data Integration Guide : Getting Started with ADC : Overview of the Advanced Data Connector

Try Corticon Now

Overview of the Advanced Data Connector

ADC functions as a service callout that accesses data as a step in a Ruleflow. They are based on Corticon Extensions -- ones that you might create yourself, as described in Corticon Extensions Guide -- that are packaged opaquely for ADC Datasource read/write functions through SQL queries stored in the database.
To use ADC:
1. Map your vocabulary to a database - In the Corticon vocabulary editor, map the entities, attributes, and associations that tell ADC how to construct entities and associations for data retrieved from the database and how to save data when storing to the database.
2. Define parameterized SQL statements for the queries - You have full control over these queries. They can be parameterized so that substitutions can be performed at runtime. To make these statements easy to manage, they are also stored in a database--the same database or a database separate from the data to be queried.
3. Add the ADC callout to a Ruleflow - In the Corticon Ruleflow editor, when you add a Service Call-out to a Ruleflow, you configure it to identify the queries to be performed by selecting one of the SQL statements you have defined. To make this easier, you can give the SQL statements logical names.
When all steps are completed you are ready to deploy your Ruleflow or test it in the Corticon tester. When ADC runs, it performs substitutions into the statement to access data. For queries, ADC constructs entities, sets attributes, and defines associations using the Vocabulary mapping. For inserts, ADC uses the mapping data for storing to the database.
You can use multiple instance of ADC in a Ruleflow. A typical use case would be to have an instance at the start of a Ruleflow to retrieve data and one later in the Ruleflow to save data.