Data tables

The primary aspect of a system's data model is a set of data tables. Each data table consists of columns and rows that structure the data. Data is collected during Collection and stored in the Vault.

To get started, Choose tables to collect and then Choose columns to collect.

Tables, columns, and rows represent the following:

  • Each table represents a single object type in the external system. For example, the Active Directory connector supports four resource types: users, groups, group memberships, and OUs. These are the four data tables available for collection for any Active Directory system. Object types also correspond to the functions available in the system's Mappings (at least for target systems).

  • Each column represents a single attribute of the object type. For example, a user's email address or a group's unique identifier.

  • Each row corresponds to a single instance of the object type. For example, a user or a group.

A system's data tables are defined in its underlying connector, outside of the NIM studio. See Connectors. For officially-supported systems, data tables are already defined for you. All you have to do is choose which ones to collect. You only need to define data tables yourself if you're creating Custom connectors for proprietary systems.