Pick a csv file from a windows source

[amishra97 (Abhinav Mishra)]

Hello Everyone,

We are establishing an automated process to place a CSV file in a specific location on a Windows server.

The data about accounts and entitlements will be in the csv file.

How can the IDN be set up to load the data in IDN by selecting the CSV file?

Note==> It is possible to store the CSV file in a shared/mapped location in windows server.
I tried setting up the SQL loader for it, but it is not recognized by the idn.

Also we don’t want to use file upload utility.

[jmutschlerProtiviti (Jason Mutschler)]

The file upload utility would be the best tool to accomplish this task. For context could you provide a reasoning for wanting to avoid the file upload utility?

File Upload Utility Documentation:
https://community.sailpoint.com/t5/Professional-Services/IdentityNow-File-Upload-Utility/ta-p/76392

[amishra97 (Abhinav Mishra)]

Thanks @jmutschlerProtiviti for the response above.
I was waiting for someone to response.

The reason we don’t want to use FUU is, the API it uses will going to be deprecated in few days. I can’t propose this solution to client as it also don’t do any kind of encryption.

I tried configuring SQL loader after storing the file in the mapped location, but it does not appear to work.

https://documentation.sailpoint.com/connectors/sql_loader/help/integrating_sql_loader/account_connection_settings.html

[shaileeM (Shailee Mehta)]

Hi @amishra97 ,

You can try the SQL loader connector with the Data Files URL value as -

jdbc:csv:ftp://<windows server IP>/path/to/csv_file

Driver Class as -

com.hxtt.sql.text.TextDriver

Additional Connection Parameters as -

_CSV_Header=true

[iamology (Nithesh Rao)]

SQLLoader can connect to ftp, http or smb URLs. But I don’t think it can connect to a shared or mapped drive