Connecting SQL Loader to Files on Sharepoint File Store

Identity Security Cloud (ISC) ISC Discussion and Questions
, ,
1

We have a number of SQL Loader sources at the moment which access files on a DFS File Share. This is being decommissioned, and we’re looking to move these files into Sharepoint.

So far I’ve tried setting up one source - I’ve moved the CSV source file into a Sharepoint document location, ensured the Sailpoint account specified in the Source setup has access to the Sharepoint site, ensured the file is accessilbe, and ensured the file is correct.

The “Data Files URL” string I have is similar to the below (redacted a bit for obvious reasons) :

jdbc:csv:/https://companyname.sharepoint.com/:x:/r/sites/SiteName/Shared%20Documents/

The Account SQL Query ends with “From ” and is the same SQL we’re using to read the flat file from the file store at the minute.

image
image615×403 15 KB

I think this is the standard “Cannot Read File” error.

I’ve read that for IIS the file needs to be in wwwroot but I dont know if there is any specific requirement for files stored in Sharepoint.

Any guidance or documentation links you can provide are appreciated.

Not dug into the logs yet but can grab these if you think it will provide some insight.

2

Do you have an extra / before https here?

3

I did, yes, but removed it. Still get the same error without it.

4

Are you able to access the CSV file in a browser using this URL followed by the csv file name like
https://companyname.sharepoint.com/:x:/r/sites/SiteName/Shared%20Documents/accounts.csv

I think it’s the access issue

5

I can access it from my own account in a web browser, Sailpoint is using a service account but with the same permissions as my account, so the access should be exactly the same.

6

Since it’s going out to SharePoint.com…and the SQL Loader is a VA-based connector, can the VA access https://login.microsoftonline.com for authentication?

Don’t think you can fetch a file from SharePoint like this… The connector wouldn’t understand the authentication mechanism.

7

That might well be the issue. I’d hoped as long as the user account Sailpoint was using was given access to the file that it would be able to read that file.