Supported Features

Note
Before you can use any of the following items marked with an asterisk (*), SailPoint must activate the feature for your site.

The SailPoint connector for SQL Loader supports the following features:

  • Load accounts

  • *Provision accounts

  • *Access Certifications (certification of entitlements connected to accounts)

  • *Password management

Note
The SQL Loader source may cause intermittent timeouts during aggregation and provisioning operations for all supported protocols.

For more information on features, refer to Identity Security Cloud Source Features.

Caution

When configuring aggregation or provisioning queries that include a condition or a JOIN action, the column specified in the condition or JOIN cannot contain more than 19 characters. If the column has more than 19 characters, the query may return incomplete results.

For example:

  • SELECT t.id, t.name, u.group FROM ProvisioningUser t,ProvisioningUserGroupAssignment u where t.id=u.id

    Where the column for calculating the condition is id. If this column contains a value with a length of more than 19 characters, the queries may return incomplete results.

  • SELECT u.MAIL_ADDRESS as MAIL_ADDRESS, u.ROLE_SPECIALISM as ROLE_SPECIALISM, ug.GROUP_NAME as groups FROM Users u LEFT OUTER JOIN UsersGroups ug ON u.MAIL_ADDRESS = ug.MAIL_ADDRESS ORDER BY MAIL_ADDRESS

    Where the JOIN column is MAIL_ADDRESS. If this column contains a value with a length of more than 19 characters, the queries may return incomplete results.

Concurrent provisioning operations may fail in any situation where multiple concurrent processes are trying to edit it at the same time. This is a limitation of the end repository being a flat file that does not have active processing on its end. It lacks the capability to multithread and resolve write access conflicts.