Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
08/23/2023 10:11 PM - edited 08/23/2023 10:14 PM
Looking for the best option to automatically upload CSVs to a Savynt instance with which to parse with Schema jobs(accounts along with entiltemnets)?
I know API have an upload method to push CSVs into Datafiles.
Is there any other ways to automate this.
Can SFTP connector helps?
if yes could you please elaborate?
Any help would be appreciated.
08/23/2023 10:17 PM
Hi @SumathiSomala ,
You can write script on your source server with SFTP command to copy files to destination Saviynt server. Then schedule that script as per required frequency on source server.
Hope it works.
08/23/2023 10:21 PM
Thanks for quick response @pmahalle
I am new to this could you elaborate more on this?
On which location we have to write the script, and also could you help with the script?
08/24/2023 12:51 AM
@pmahalle are you referring to this?
FILES_TO_GET
[
{
"eic_dest_dir": "DataFiles",
"src_dir": "/home/data/",
"file_list": [
"file1.csv",
"file2.txt"
]
},
{
"eic_dest_dir": "SchemaFiles",
"src_dir": "/home/sav/",
"regex_list": [
"^.*\\.sav"
]
}
]
08/24/2023 12:22 AM
Do we need to integrate SFTP connector with Saviynt to achieve this?
08/24/2023 12:52 AM - edited 08/24/2023 12:53 AM
Hi @SumathiSomala ,
What is your source server linux or windows from where you want to copy files to Saviynt?
08/24/2023 12:55 AM
we are planning to use SFTP to automate the CSV files (files contains accounts along with entitlements) into Saviynt.
08/29/2023 04:55 AM - edited 08/29/2023 04:56 AM
What is your source server linux or windows from where you want to copy files to Saviynt?
Source server is windows