System data mapping

This page describes how data retrieved from the source service is mapped into records generated by the connector.

For each record type, the following information is reported:

• the property name exposed by the connector;
• the path from which the value is obtained in the source service;
• any additional note regarding transformations, enrichments or special behaviours.

Each record mapping section is titled {Source Object Name} ({_type}), combining the object name used by the source service with the internal record type produced by the connector.

Common properties

Each entry returned by an LDAP query becomes a record. The record contains one property for each attribute returned by the search, named after the LDAP attribute. The properties below are shared by all the record types.

Property name	Source path	Notes
_type		The Record type of the query that returned the entry.
key	dn (default)	Value of the attribute set as Key attribute in the query.
displayName	displayName	The display name of the object. It is usually the combination of first name, middle initial and last name.
sAMAccountName	sAMAccountName	The logon name.
cn	cn	The name that represents the object.
name	name	The Relative Distinguished Name (RDN) of the object.
description	description	The description of the object.
telephoneNumber	telephoneNumber	The primary telephone number.
distinguishedName	dn	Value of dn; if not present, value of distinguishedName.
uid	uid	The user ID.
canonicalName	canonicalName	The name of the object in canonical format.
memberOf	memberOf	The distinguished names of the groups the object belongs to.
managedObjects	managedObjects	The list of objects managed by the object.
objectCategory	objectCategory	The object class name used to group objects of this or derived classes.
objectClass	objectClass	The list of classes from which the class of the object is derived.
objectGUID	objectGUID	The unique identifier of the object.
objectSid	objectSid	The security identifier (SID) of the object.
objectVersion	objectVersion	The version number of the object.
sAMAccountType	sAMAccountType	Information about the account type of the object.
whenChanged	whenChanged	The date when the object was last changed. The LDAP value (yyyyMMddHHmmss.SX) is converted to an ISO date.
whenCreated	whenCreated	The date when the object was created. The LDAP value (yyyyMMddHHmmss.SX) is converted to an ISO date.

Notes

• Attributes with an empty value are read as empty.
• When an attribute has more than one value, the values are joined in a single value in the form [value1, value2].
• All the attributes returned by the query are read; only the properties listed in this page are imported by the standard bus descriptor. The attributes returned by a query can be restricted with the Returning attributes option.

User (user)

An entry of the directory that represents a user account. The record also contains all the common properties.

Property name	Source path	Notes
mail	mail	The email address.
active	userAccountControl	Calculated: true if the ACCOUNTDISABLE flag (bit value 2) of userAccountControl is not set. Not set when userAccountControl is not returned.
userPrincipalName	userPrincipalName	The User Principal Name (UPN).
personalTitle	personalTitle	The title of the user.
givenName	givenName	The given name (first name).
sn	sn	The family name (last name).
initials	initials	The initials of the parts of the full name.
homePhone	homePhone	The main home phone number.
mobile	mobile	The primary mobile phone number.
ipPhone	ipPhone	The TCP/IP address of the phone.
facsimileTelephoneNumber	facsimileTelephoneNumber	The business fax number.
company	company	The company name.
department	department	The department in which the user works.
division	division	The division of the user.
o	o	The name of the company or organization.
ou	ou	The name of the organizational unit.
physicalDeliveryOfficeName	physicalDeliveryOfficeName	The office location.
manager	manager	The distinguished name of the manager of the user.
assistent	assistent	The distinguished name of the administrative assistant of the user.
title	title	The job title.
employeeId	employeeId	The ID of the employee.
employeeNumber	employeeNumber	The employee number.
c	c	The country/region of the address.
st	st	The state or province of the address.
l	l	The locality (town or city) of the address.
street	street	The street address.
postalAddress	postalAddress	The mailing address.
postalCode	postalCode	The postal or zip code.
accountExpires	accountExpires	The date when the account expires. The LDAP value (100-nanosecond intervals since 1601-01-01) is converted to an ISO date; the values 0 and 9223372036854775807 (never expires) are read as empty.
gidNumber	gidNumber	The integer that identifies the primary group in the administrative domain.
rid	rid	The relative identifier.
primaryGroupID	primaryGroupID	The relative identifier (RID) of the primary group of the user.
userAccountControl	userAccountControl	The flags that control the behavior of the account.
homeDirectory	homeDirectory	The home directory of the account.
homeDrive	homeDrive	The drive letter to which the path in homeDirectory is mapped.
info	info	The comments on the user.

Group (group)

An entry of the directory that represents a group. The record also contains all the common properties.

Property name	Source path	Notes
mail	mail	The email address of the group.
managedBy	managedBy	The distinguished name of the user assigned to manage the group.
groupType	groupType	The flags that define the type and scope of the group.
gidNumber	gidNumber	The integer that uniquely identifies the group in the administrative domain.
rid	rid	The relative identifier.
member	member	The list of the users that belong to the group.
info	info	The comments on the group.

OU (ou)

An entry of the directory that represents an organizational unit. The record also contains all the common properties.

Property name	Source path	Notes
ou	ou	The name of the organizational unit.
managedBy	managedBy	The distinguished name of the user assigned to manage the unit.
physicalDeliveryOfficeName	physicalDeliveryOfficeName	The office location of the unit.
facsimileTelephoneNumber	facsimileTelephoneNumber	The business fax number.
c	c	The country/region of the address.
st	st	The state or province of the address.
l	l	The locality (town or city) of the address.
street	street	The street address.
postalAddress	postalAddress	The mailing address.
postalCode	postalCode	The postal or zip code.