We’re working on a SailPoint IdentityIQ integration where the target system only supports user management via batch file processing. Unfortunately, there’s no out-of-the-box connector available, and the system doesn’t expose REST/SOAP APIs — the only interface is via a CSV file drop, which the target’s internal utility processes periodically.
Please advise on the best practise.
Do you require provisioning to the CSV or will manual provisioning (via manual work items or service desk type integration) achieve your requirements?
If you require direct provisioning to a CSV file, you could try using the SQLLoader connector. This connector utilizes CSV file(s) as database tables. You can use provisioning rules with SQL statements to update existing records or insert new records similar to a JDBC connector.
Another approach is that you can use IntegrationConfig in SailPoint IIQ. Write your logic for inserting data in the Java class. Whenever some raises a request, you can add the data in the SQL file present in a network drive.