Blog Post

Getting SQL data into SharePoint

Getting SQL data into SharePoint
Sharing SQL data in SharePoint
Sharing SQL data in SharePoint

In March, I was invited to speak at the OKC SQL Users Group and I never got the slide deck posted. So here it is to help get you started.

Session Level:  Beginner SQL and Beginner SharePoint

Session Abstract:  Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing.

  • In this session we will start with the basics of sharing a SQL table as a ‘List’ in Sharepoint.
  • Next we move on to fun stuff of integrating SQL Server Reporting Services integration.
  • Finally we share a PowerPivot analysis built off our SQL data.

For those who asked about the cool Excel PowerPivot charts, go check out the articles and book from Roggie Clark, The SQL Surgeon.

Please be kind with your comments, as this is just the first time I presented on SharePoint. I got great feedback and will continue to add to the session.

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Posts