If it possible to change the file name which IdentityNow is reading from / provisioning to based on the day of the month?
Our goal is to use the SQL Loader connector to be able to read data from and provision to a .txt file on a nightly basis. The file name, however, must follow a naming convention which changes each day to support an existing technical process. As a result, we need to be able to adjust the name of the file based on the day of the month (e.g., on Oct 01, the file is D01_Employees.txt, and on Oct 02 the file name is D02_Employees.txt .
I’m not aware of an “easy” way to do this within the connector itself, but what we’ve done previously is use a PowerShell script running via the Windows Task Scheduler to be a basic file renamer/archiver. Basically the script kicks off once an hour and looks for a predefined set of filenames for various sources that match a configured naming scheme. If it finds a file it creates an archive/backup based on a defined format (i.e. sourceName+date) and then creates a copy with the standard filename the connector is configured for.
This allows us to use a configuration file with the PowerShell script for basic renames and we can deal with daily files generated by other sources.