TDV Adapter for Act-On

Build 24.0.9060

Data Model

The ActOn Adapter models entities in the ActOn API as tables, views, and stored procedures. These are defined in schema files, which are simple, text-based configuration files.
Lists in ActOn are exposed as views with the convention List_ListName. For each list there is another view List_ListName_Score where you can see the score of the people in the list.
Same logic for Segments in ActOn, they are exposed as views as Segment_SegmentName. And have an equivalent view Segment_SegmentName_Score.
Any changes you make to your ActOn account, such as adding a new list, adding new columns, or changing the data type of a column, will immediately be reflected
when you connect using the driver.

Using Query Processing

The adapter offloads as much of the SELECT statement processing as possible to the ActOn APIs and then processes the rest of the query within the adapter. The following sections document API limitations and requirements.

Views

Views are tables that cannot be modified. Typically, read-only data are shown as views.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060