SQLTeam.com | Weblogs | Forums

Is it possible to query a SQL server AND a local or sharepoint file?

Hello

Is it possible to query a SQL server AND a local or sharepoint file at the same time?

Thanks!

question for you, when you access your SharePoint using this url what do you see?

http://your.sharepoint/folder.where.your.data.resides/_vti_bin/ListData.svc

I get:

Request Error

The server encountered an error processing the request. See server logs for more details.

your option might be to extract the data/list from sharepoint as csv to the SQL server as csv and read it from SQL Server. Or import via ssis or powershell or python the sharepoint file into sql server and join to that data with your other tables.

I am not sure if there is an ODBC for Sharepoint you could use to read data off of your SP.

We extract data from sharepoint via powershell and into our DW to creare PowerBi heat map dashboards.