Corticon's Advanced Data Connector (ADC) provides an alternative to Corticon’s Enterprise Data Connector (EDC) for accessing database data. It provides greater control over the query and insert statements that are used. This is beneficial when you need finer control for performance or need to retrieve large amounts of data, as is the case in batch processing. With ADC you define a mapping of your vocabulary to a database, define queries, and control when queries are performed to retrieve data.

Here is a video overview of the data access with ADC:

To load the ADC sample:

In Corticon Studio, choose the menu item Help > Samples. Select the Advanced Sample ADC Database Connectivity, and then click Done. Follow the Import dialog to bring the sample into your workspace.

Note: ADC is different from EDC in a few ways. If you are following along after walking through "Getting started with EDC," there are a few things to reset to make this section flow smoothly:
  • In Corticon Studio, choose File > Close All.
  • In the database table Treatments, either reset all the approved values to Null, or just delete and recreate the database

See more topics on ADC usage in the section Advanced ADC topics.