Provisioning
The SQL Loader connector supports provisioning, allowing you to create and manage accounts and entitlements in SQL Loader directly from SailPoint.
Prerequisite: Your system is configured for provisioning.
When SailPoint provisions new accounts to the source, it uses the attributes on the Create Account page as instructions or a template for what to include in the account. This page is also referred to as the provisioning policy.
When new access is granted on a source where a user does not already have an account, SailPoint automatically includes account creation in the provisioning. This applies whether provisioning is started from an access request or from an automated role or lifecycle state assignment.
For direct-connect sources, SailPoint automatically creates the account from this configuration. If the source is not configured as a direct-connect source, SailPoint creates and assigns a provisioning task to the source owner and includes the values for the source owner to use in manually creating the account.
Important
This section describes the default Create Account configuration. SailPoint recommends that you work with Services to define a provisioning configuration specific to your company's needs. Be sure to verify large changes to the provisioning policy before implementation. Failure to do so might cause provisioning to fail.
Insert Query Example for Provisioning
For example, the Employee.CSV file has columns: userid, email, Fullname, and department. In the example, EMPLOYEE is the .csv file (EMPLOYEE.CSV) that the SQL Loader source accesses.
insert into EMPLOYEE (userid,email,Fullname,department) values ('01','testjohn@testmail.com','John','HR')
Best Practices
- To insert a record in a file having only the headers but no record, add a new line character after the header.
- For Provisioning Rules template and examples, refer to the Identity Security Cloud Rule Guide - JDBC Provisioning Rule document.
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.