2020 @SQLSatLA presents: 3 Ways for Getting Data from SharePoint by David Patrick | @Blackline Room

3 Ways for Getting Data from SharePoint : SSIS, Excel and Access by David Patrick (@DavidEPatrick)
Need to report on some data from SharePoint? We will look at three different techniques to pull data from a SharePoint Server. We will start with SSIS and the SharePoint List Source and Destinations. Next, We will use Excel to connect to various SharePoint lists (both online and on premise), and finally We will use Microsoft Access to do the same thing (and throw in the capability to do updates as well). At the end of the talk, We will have three different ways to get data from SharePoint.
Prerequisites: Experience and basic understanding of SharePoint. Basic understanding of SSIS, Access, and Excel.