adTempus database queries

Database Model

Download the adTempus 4 database model

This document provides an overview of the adTempus database model for users who wish to query the database directly.

Note that due to the complexity of the database model, getting information out of the database into a useful format can be difficult. Users should consider these alternatives to direct database queries:

• The adTempus API provides complete programmatic access to all adTempus data.
• For reporting, consider the Report Designer included in the adTempus Console, which allows for custom reports built on top of the API.

Direct updates to the adTempus database are not supported except at the direction of a support engineer, and may result in data corruption or unpredictable results. If you need to make programmatic updates to adTempus, use the API.

Sample Queries

Sample queries demonstrating how to retrieve various pieces of information from the adTempus database can be found in the code sample library.