Identity Security Cloud - DelimitedFile connector - Question on Automated CSV Generation on Virtual Appliance and Upload to IdentityNow via File Upload Utility

Identity Security Cloud (ISC) ISC Discussion and Questions
, ,
1

Hello everyone,
I’m aware that SailPoint IdentityNow supports direct connectors for integrating a lot of various authoritative sources , and this is generally the recommended approach to avoid managing CSV files manually. However, for a specific use case , I need to implement a flow that generates and updates a CSV file on IdentityNow through the Virtual Appliance, in order to have more control over the process for specific needs that I will not mention here. Below is the flow I am trying to implement.

Desired flow :

1a. LDAP Connection via ldapsearch :
I would like to use the ldapsearch command to query an LDAP server (Active Directory) and generate a CSV file. I’ve confirmed that the ldapsearch command, version 2.6.4, is available on freshly deployed Virtual Appliances. The output from ldapsearch should be processed and saved as a CSV file for use in IdentityNow.

1b.API Call via cURL to External System (Alternative) :
As a second option, I could explore calling an external system’s API using the cURL client to retrieve the necessary data and then generate the CSV. This would give me more flexibility in case the data resides in another system, and I can use the API to directly fetch it in the required format.

  1. Upload to IdentityNow :
    Once the CSV file is generated (either from ldapsearch or external APIs), I want to use the Identity Security Cloud File Upload Utility to upload the CSV file daily to IdentityNow and ensure the data is kept up to date. I found this guide on how to use the utility:
    IdentityNow File Upload Utility.

My questions :

Are both options (previous 1a. and 1b.) viable on the Virtual Appliance? Is there any limitation on using these tools in the Virtual Appliance environment that I should be aware of?

  • Alternatively, is it recommended to use external APIs via cURL to pull the data? If so, has anyone had experience automating this integration into IdentityNow?
  • Is it possible to automate this entire process (i.e. steps 1a. + 2. or steps 1b. + 2) so that it runs daily without manual intervention? I’ve read about scheduling jobs in IdentityNow, but I’m unsure how to integrate these processes with the Upload Utility.

Thank you in advance for any suggestions or experiences you can share!

Kind regards,
Paolo