Data tables

The primary aspect of a system's data model is a set of data tables. Each data table consists of a set of data columns. Together, these tables and columns structure the collected data.

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 type of resource 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. (Resource types also typically correspond to the functions available in the system's Mappings—at least for systems that support target contexts. See Sources and targets.)

  • Each column within those tables corresponds to a single attribute of that resource type. For example, a user's email address or a group's unique identifier.

  • Each row corresponds to a single instance of that resource 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 a custom connector for a proprietary system.