Is there a way to read data from a Sharepoint List?

Reply
New Contributor
Posts: 2

Is there a way to read data from a Sharepoint List?

We collect data from the organisation with Sharepoint Lists. Now we are reporting in Excel and there is Excel a connection to the Sharepoint server. I want to use the Sharepoint data in SAS and want to read it with SAS/EG.

Does anybody know a (easy) way to build this?

Trusted Advisor
Posts: 3,215

Re: Is there a way to read data from a Sharepoint List?

Posted in reply to bendejong

Nothing documented for accessing SharePoint.

But excel does. Than if that is an odbc  connection you could do that in the same way.

The mail-outlook list is also accessible in that approach. 

---->-- ja karman --<-----
Super User
Posts: 23,683

Re: Is there a way to read data from a Sharepoint List?

Posted in reply to bendejong

In SharePoint you can export a List to Excel, which becomes a live link, if you tell it to update appropriately.

We then set up SAS to read this excel spreadsheet.

A bit roundabout but works fine.

New Contributor
Posts: 2

Re: Is there a way to read data from a Sharepoint List?

Hi Reeza,

Your suggestion is coming close to the solution I am using now. I have made a connection with an Access database. In Acces you can import a Lists directly. When the lists are updatet in Sharepoint I don't need to open the database first, but I can collect the updatet data via my SAS/EG project.

This is not what I wanted, because I want to collect the data direct with SAS/EG from the Sharepoint List. It is now an extra step.

Trusted Advisor
Posts: 3,215

Re: Is there a way to read data from a Sharepoint List?

Posted in reply to bendejong

I did some googling on "odbc connection sharepoint list", found a lot like:

Add a database as a data source - SharePoint Designer (data from SQL to sharepoint,  Microsoft)

SharePoint List Connection Type (SSRS) (data from sharepoint to SQL, Microsoft)

SharePoint connection strings - ConnectionStrings.com (connectionstrings)

---->-- ja karman --<-----
New Contributor
Posts: 4

Re: Is there a way to read data from a Sharepoint List?

I found this http://www.sas.com/content/dam/SAS/en_ca/User%20Group%20Presentations/Winnipeg-User-Group/HarryDroog... talking about how to access sharepoint from SAS. I hope it helps.

New Contributor
Posts: 4

Re: Is there a way to read data from a Sharepoint List?

Posted in reply to fkrimmelbein

Awesome, thanks that does help

Ask a Question
Discussion stats
  • 6 replies
  • 6517 views
  • 0 likes
  • 4 in conversation