{"id":389,"date":"2013-04-10T15:16:23","date_gmt":"2013-04-10T20:16:23","guid":{"rendered":"http:\/\/www.cognitiveinfo.com\/?p=389"},"modified":"2013-04-10T15:16:23","modified_gmt":"2013-04-10T20:16:23","slug":"getting-sql-data-into-sharepoint","status":"publish","type":"post","link":"http:\/\/cognitiveinfo.com\/?p=389","title":{"rendered":"Getting SQL data into SharePoint"},"content":{"rendered":"<figure id=\"attachment_390\" aria-describedby=\"caption-attachment-390\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-medium wp-image-390\" alt=\"Sharing SQL data in SharePoint\" src=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/04\/Allen-SharingInSharepoint-300x168.jpg\" width=\"300\" height=\"168\" \/><figcaption id=\"caption-attachment-390\" class=\"wp-caption-text\">Sharing SQL data in SharePoint<\/figcaption><\/figure>\n<p>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.<\/p>\n<p><iframe style=\"border: 1px solid #CCC; border-width: 1px 1px 0; margin-bottom: 5px;\" src=\"http:\/\/www.slideshare.net\/slideshow\/embed_code\/18565419\" height=\"356\" width=\"427\" allowfullscreen=\"\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<div style=\"margin-bottom: 5px;\"><strong> <a title=\"Sharing SQL data in SharePoint\" href=\"http:\/\/www.slideshare.net\/cognitivebi\/sql-to-share-point\" target=\"_blank\" rel=\"noopener\">Sharing SQL data in SharePoint<\/a> <\/strong> from <strong><a href=\"http:\/\/www.slideshare.net\/cognitivebi\" target=\"_blank\" rel=\"noopener\">Allen Smith<\/a><\/strong><\/div>\n<p>Session Level:\u00a0 Beginner SQL and Beginner SharePoint<\/p>\n<p>Session Abstract:\u00a0 Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing.<\/p>\n<ul>\n<li>In this session we will start with the basics of sharing a SQL table as a &#8216;List&#8217; in Sharepoint.<\/li>\n<li>Next we move on to fun stuff of integrating SQL Server Reporting Services integration.<\/li>\n<li>Finally we share a PowerPivot analysis built off our SQL data.<\/li>\n<\/ul>\n<p>For those who asked about the cool Excel PowerPivot charts, go check out the articles and book from Roggie Clark, <a href=\"http:\/\/www.thesqlsurgeon.com\/tss_company_founder.shtml\" target=\"_blank\" rel=\"noopener\">The SQL Surgeon<\/a>.<\/p>\n<p>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.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 data in Sharepoint.<\/p>\n","protected":false},"author":2,"featured_media":390,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,8],"tags":[54,72,88,92,93,102],"class_list":["post-389","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bidw-projects","category-microsoftsql","tag-excel","tag-powerpivot","tag-sharepoint","tag-sql-2008-r2","tag-sql-2012","tag-ssrs"],"_links":{"self":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/389","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=389"}],"version-history":[{"count":0,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/389\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/"}],"wp:attachment":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=389"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}