Create Profile / Provisioning Policy
When Identity Security Cloud provisions new accounts to a SQL Loader source, it uses the attributes on the Create Profile page as instructions or a template for what to include in the account. This page is also referred to as the provisioning policy. You can create profile based on the data files.
Important
The SQL Loader source does not generate an out-of-box Create Profile page. This page describes the configuration of the default Create Profile. However, SailPoint recommends that you work with Services to define a Create Profile specific to your company's needs.
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.