Workflow to load delimited files automatically

We have requirement where we store delimited file in some server and now we want to load that data automatically into delimited source through workflow. Help us how to achieve this through workflow

The SailPoint File Upload Utility provides a way for SailPoint cloud customers to upload files to the cloud automatically, for automatic account and entitlement aggregations.File Upload Utility

Alternatively to the File Upload Utility, you could also use the SQL Loader Connector. We use it to load CSV files and it allows us to schedule the aggregations within the GUI.

SQL Loader Documentation

thank you! one thing is the link of file upload utility looks highly intellectual, can I get some good steps

Hi @shaffusailpoint !

The documentation is detailed so I’d definitely take some time to read it. The required options are especially important, but the optional ones can be useful.

Generally speaking, what we’ve done is use a server where the flat files will be loaded, then you can create a script (PowerShell for example), that will utilize the flat file utility. You have to have Java installed on the server, and you can utilize a task scheduler to run the script. You can also do things like rename the files, move them to an archive, etc.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.