Previous Topic: Documentation ChangesNext Topic: Datatypes


About Database Schema and Views

This guide contains the database table specifications used by the CA DataMinder product. It is provided to allow customers to develop additional customized database queries. To make the best use of this document, you must be familiar with relational database design and have a thorough understanding of SQL.

Schema Version

This guide is based on the database schema version 3.90 used by CA DataMinder 14.5 (build 3200 and its derivatives).

Schema Diagram

The relationships between all documented tables are shown in a separate schema diagram. You can open .html and .pdf versions of the diagram from the 'D', 'Reference', and 'Database Administrator' pages of the bookshelf.

dlp_database_schema_diagram.html

DLP_DBSchema_Diagram_ENU.pdf

Note: The diagram is also available in the \Bookshelf Files\DBSchema folder of the CA DataMinder bookshelf.

This section contains the following topics:

Datatypes

IDM Columns

CA DataMinder Datatype Mappings