Skip to content

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 Sybase (SAP ASE) 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
native_identity Account
native_identity Group
native_identity Database Groups

Default Account Attributes

The Sybase (SAP ASE) 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
name Login user name.
server_user_id Server User ID.
default_database Default database. For example: master
default_language Default language. For example: us_english
full_name Full name of login user.
create_date Date on which login user is created.
password_chg_date Date on which password got changed.
last_login_date Last login date of the user.
native_identity An attribute which acts like a primary key during aggregation. This is an Account ID which must not be changed.
status Status of login user, such as enable/disable.
roles Roles associated with login user.
database_groups Database groups.
password_expiration_interval Password Expiration Interval frequency in days
expire_login Expire Login of the system.
password_expired Password has expired for user.
aliases Aliases associated with login user.

Custom Attributes

Perform the following to support the custom attributes:

  1. Click Add attribute button to add the custom attribute name in the schema.

  2. Add the following lines in the application debug page:

    <entry key = "customAttribute" >
    <value>
       <List>
           <String>custom1</String>
           <String>custom2</String>
       </List>
    </value>
</entry>

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 Sybase (SAP ASE) connector also supports groups. The following attributes must be configured on the managed system and in the SailPoint source schema to manage groups.

Group Object Type = Groups

Attribute Name Description
server_role_id ID of the server Role.
native_identity An attribute which acts like a primary key during aggregation. This is an Account ID which must not be changed.
name Name of the Role.
password_chg_date Date on which password got changed.
member_roles Roles which are present under the hierarchy of the main role.

Group Object Type = Database Groups

Attribute Name Description
Group_name Database Group Name.
native_identity An attribute which acts like a primary key during aggregation. This is an Account ID which must not be changed.
Group_id Database Group ID.

Documentation Feedback

Feedback is provided as an informational resource only and does not form part of SailPoint’s official product documentation. SailPoint does not warrant or make any guarantees about the feedback (including without limitation as to its accuracy, relevance, or reliability). All feedback is subject to the terms set forth at https://developer.sailpoint.com/discuss/tos.