Schema Reference
The application schema is used to configure the objects returned from a connector.
Note
-
The Account Schema tab is used to define the attributes for each object type in the application being configured. The schema attributes can be defined as Entitlement or Multi-Valued. Refer to Managing Source Account Schemas for more information.
-
The schema attributes that are not present by default must be defined as strings if not specified.
The Informatica connector uses the following default correlation and object configurations.
Default Account Schema
Each source supports a variety of details, or attributes, about each user who has an account, such as their name, email address, manager name, and location.
The set of account attributes each source stores and how they're organized is known as the account's schema. To best represent your data, you can configure sources to use an account schema matching the one you use in the external connector. Refer to Managing Source Account Schemas for more information.
Default Account ID
SailPoint requires that certain attributes remain in your configuration. These attributes are referred to as account IDs.
Caution
Changing the attribute marked as the account ID after aggregating accounts can result in duplicate accounts being created. To avoid this, either reset the accounts on this source before editing the account ID attribute or edit the account ID attribute before aggregating accounts.
To resolve issues caused by changing account IDs, reconfigure them to their default values.
The following table lists the default account IDs for this connector:
| Account ID | Schema Object Type |
|---|---|
| id | User |
Default Account Attributes
The Informatica connector supports the following default account schema attributes and customer configurable attributes. The attributes must be defined as strings if not specified.
| Attribute Name | Description |
|---|---|
| id | Unique identifier of the user |
| orgId | ID of the organization the user belongs to |
| createdBy | User who created the user account |
| updatedBy | User who last updated the user account |
| createTime | Date and time the user was created |
| updateTime | Date and time the user was last updated |
| userName | Username for the user account |
| firstName | First name of the user |
| lastName | Last name of the user |
| description | Description of the user |
| title | Job title of the user |
| phone | Phone number of the user |
| Email address of the user | |
| state | Current state of the user account |
| timeZoneId | Time zone associated with the user |
| maxLoginAttempts | Maximum allowed login attempts before account lock |
| authentication | Indicates whether SAML-based single sign-on is enabled |
| forcePasswordChange | Indicates whether the user must reset the password on first login |
| lastLoginTime | Date and time of the user's last login |
| lastLoginMode | Login method used |
| roles_id | Role ID assigned to the user |
| roleName | Name of the assigned role |
| groups_id | User group ID assigned to the user |
| userGroupName | Name of the user group |
Default Entitlement Attributes
Entitlement attributes define the entitlements, such as groups or roles, that can be assigned to the managed system's user accounts. Refer to Managing Entitlements for more information.
Caution
Changing the attribute marked as the Entitlement ID after aggregating accounts or entitlements can result in duplicate entitlements being created, or access profiles and roles breaking. To avoid this, edit the entitlement schema before performing any aggregations.
Default Group Attributes
The Informatica connector also supports groups. The following attributes must be configured on the managed system and in the SailPoint source schema to manage groups.
| Attribute Name | Description |
|---|---|
| id | Unique ID of the user group |
| orgId | ID of the organization associated with the user |
| createdBy | User who created the user group |
| updatedBy | User who last updated the user group |
| createTime | Date and time the user group was created |
| updateTime | Date and time the user group was last updated |
| userGroupName | Name of the user group |
| description | Description of the user group |
| roles_id | Role ID associated with the user group |
| roles_roleName | Name of the role associated with the user group |
| roles_description | Description of the role |
| roles_displayName | Display name of the role shown in the UI |
| roles_displayDescription | Role description displayed in the UI |
Default Role Attributes
The Informatica connector supports roles. The following attributes must be configured on the managed system and in the SailPoint source schema to manage roles.
| Attribute Name | Description |
|---|---|
| id | Unique ID for the role |
| orgId | ID of the organization associated with the role |
| createdBy | User who created the role |
| updatedBy | User who last updated the role |
| createTime | Date and time the role was created |
| updateTime | Date and time the role was last updated |
| roleName | Name of the role |
| description | Description of the role |
| displayName | Role name displayed in the UI |
| displayDescription | Role description displayed in the UI |
| systemRole | Indicates whether the role is system-defined |
| status | Indicates whether the role is active or expired |
| privileges_id | Unique ID of the privilege |
| privileges_name | Name of the privilege |
| privileges_description | Description of the privilege |
| privileges_service | Informatica service that uses the privilege |
| privileges_status | Status of the privilege |