Hello Community,
I am working on a use case where I need to provision specific identities (some attributes) from SailPoint Identity Security Cloud to a CSV file located on my SFTP server for further import.
I would appreciate your guidance on the best approach to achieve this, as I am unsure whether to use the SQL Loader Connector or a JDBC Provision Rule. Additionally, I need clarification on how to trigger manual provisioning in this scenario.
Questions:
SQL Loader vs JDBC Provision Rule:
• Is it sufficient to define an INSERT SQL query in the SQL Loader Connector’s UI (as described in doc)?
• If additional logic is required, how can I implement and attach a JDBC Provision Rule to the connector? Are there examples available for such use cases?
Manual Provisioning Trigger:
• How can I manually trigger provisioning for an identity when the connector is standalone (not connected to authoritative source)? I’ve tried to imitate the role trick, but it didn’t work out.
Are there any best practices for my case?
Thank you for your assistance!