Delimited File - Automated Aggregation

Identity Security Cloud (ISC) ISC Discussion and Questions
1

Hi all,

We have 10 sources to connect with IDN as read only using Delimited File connector. I was wondering, by any chance, can we aggregate users (import accounts) automated? Currently, If I am not wrong, only manual import option is available. We can’t also read accounts from an FTP. What would be the best practice to implement this requirement in this case?

Thanks in advamce!

2

Hi Sahin,

Please check this post.

This might be helpful for your use-case.

1 Like
3

Hey @sahincelik
Unlike in IIQ, we use File Upload Utility in IDN to schedule and import delimited files.
Ensure all the delimited files are available in a location where File Upload Utility has access to fetch.

1 Like
4

Hi @antony_petson ,
In order for the files to be in a location that the file upload utility can access, is there any script that we can use which refreshes the file everyday or is it a manual upload everyday?

2 Likes
5

You can schedule a task scheduler job to run the File Upload Utility using jar command and you can ask the application team to drop delimited files daily.
Using powershell script or any other scripting language, you can move the files once uploaded using tool.

6

Got it . Thank you for the response !!

7

HI @Prashanth0707,

If it is feasible then you can try SQL Loader connector as well, where you can connect to a location like SharePoint and configure the scheduled aggregation in SailPoint.

Integrating SailPoint with SQL Loader

Thanks,
Nikhlesh

8

Please refer to this post POST /api/source/loadAccounts - #199 by tdelorge-mmb
It has different examples of Python scripts and powershell scripts which can be used to achieve this use-case.

1 Like
9

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