Corticon Decision Services can connect to a database to perform read, write, and delete operations on it. If your Decision Service needs to access a database, your role as a Corticon integration developer is to enable database access. There are three techniques for Corticon database integration.

• Enterprise Data Connector (EDC) where data loads are moderate and tight integration with rules in an intuitive and friendly way is preferred.
• Advanced Data Connectors (ADC) that enable connection to multiple databases to access stored SQL queries through service call-outs.
• Batch Processing that let you use stored SQL queries to chunk large data flows and persist responses in a database.

This tutorial uses EDC. To get started, you need to perform two tasks:

• Map a Vocabulary to a database in Corticon Studio in one of two ways:
  • Create a database schema from an existing Vocabulary
  • Map an existing Vocabulary to an existing database schema
• Configure database access properties during deployment in Corticon Server.

In this tutorial, you will learn how to perform these tasks.

This tutorial is designed for hands-on use. We recommend that you install Corticon Studio, and then follow the instructions and illustrations in the tutorial. This tutorial is based on Corticon 6.3.