meeting # 80 welcome to the minnesota sharepoint user group july 13 th, 2011 sharepoint integration

Meeting # 80http://www.sharepointmn.com

Welcome to the Minnesota SharePoint

User Group

http://www.sharepointmn.com

July 13th, 2011

SharePoint Integration

Brian Caauwe

Meeting # 80http://www.sharepointmn.comhttp://www.sharepointmn.com

Agenda

• Introductions• Necessary Integrations• Break• Enhanced Integrations• Other Integrations• Q & A• Wrap-up and Giveaways


User Group Goal / Objectives

Develop and support a local community focused on Microsoft SharePoint Technologies

• Educate user group members about SharePoint Technologies• Transfer knowledge within the community• Communicate best practices• Introduce new products / solutions


Introductions – MNSPUG Sponsors

Avtex (www.avtex.com) • Technology consulting company• Practice area focused on SharePoint

Benchmark Learning (www.benchmarklearning.com)• Training on many technologies

Microsoft (www.microsoft.com)

Wrox Press (www.wrox.com) O’Reilly (www.oreilly.com)

http://www.avtex.com/

http://www.newhorizonsmn.com/

http://www.microsoft.com/

http://www.wrox.com/

http://www.oreilly.com/


www.SharePointMN.com

• Website for user group• SharePoint resource documents• SharePoint resource links• RSS Feeds • Meeting Schedule• Past User Group Presentations

• [email protected] www.sharepointmn.com

http://www.sharepointmn.com/

mailto:[email protected]



Social Networking• Linked In group – The most interactive… includes job postings…

http://www.linkedin.com/groups?gid=1878792

• Facebook group

http://www.facebook.com/home.php?#/group.php?gid=27333305456

• Twitter tags - @MNSPUG and #MNSPUG

http://www.linkedin.com/groups?gid=1878792

http://www.facebook.com/home.php?#/group.php?gid=27333305456


Upcoming Schedule• Next Meeting

• August 10h 9:00 AM to 11:30 AM

• Microsoft’s Bloomington Office

• Topic: TBD

Check www.SharePointMN.com for updates!

• Ongoing Schedule• 2nd Wednesday of every month

• 9:00 to 11:30 am

• Microsoft’s Bloomington Office



News and StuffSharePoint 2010 SP1 Releasedhttp://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?pID=984Install June 2011 Cumulative Update after install!

Office 365 Launch!http://www.Office365.comJune 2011 MNSPUG presentation: “Office 365 & Hosted Solutions - SharePoint in the Cloud”

SharePoint Adoption Kithttp://sharepoint.microsoft.com/iusesharepoint/Pages/get-the-kit.aspxPromote SharePoint within your organization

http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?pID=984

http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?pID=984

http://www.office365.com/

http://sharepoint.microsoft.com/iusesharepoint/Pages/get-the-kit.aspx

http://sharepoint.microsoft.com/iusesharepoint/Pages/get-the-kit.aspx

http://www.microsoft.com/en-us/office365/online-software.aspx


Local and Online EventsScarePoint Saturday – October 29th (tentative)http://www.sharepointsaturday.org/twincities/default.aspx Normandale College– Bloomington, MN

Microsoft Webcast Calendar of Eventshttp://www.microsoft.com/events/webcasts/calendar/monthview.aspx#filter

SharePoint ShopTalk (Online) – Every Thursday @ 11:30 AMhttp://sharepointshoptalk.blogspot.com/

http://www.sharepointsaturday.org/twincities/default.aspx

http://www.sharepointsaturday.org/twincities/default.aspx

http://www.microsoft.com/events/webcasts/calendar/monthview.aspx#filter

http://www.microsoft.com/events/webcasts/calendar/monthview.aspx#filter

http://sharepointshoptalk.blogspot.com/

http://sharepointshoptalk.blogspot.com/


ConferencesSharePoint Saturday – The Conference – Aug 11-13th, 2011http://www.spstc.org/Pages/default.aspx Washington, DC

Microsoft SharePoint Conference – Oct 3-6th, 2011http://www.MSSharePointConference.comAnaheim, CA

http://www.spstc.org/Pages/default.aspx

http://www.spstc.org/Pages/default.aspx

http://www.mssharepointconference.com/


Giveaways!


Presenters


Quick Intro

Brian Caauwe• Senior SharePoint Consultant• Pez Collector / n3rd• @bcaauwe• http://blogs.avtex.com/blogs/bcaauwe

http://blogs.avtex.com/blogs/bcaauwe


WARNING WARNING

Acronyms Glossary Required


AcronymsAD DS Active Directory SQL SQL Server

AD FS Active Directory Federation Services SSRS SQL Server Reporting Services

AD RMS Rights Management Services SSAS SQL Server Analysis Services

SPN Service Principal Name SSIS SQL Server Integration Services

GPO Group Policy Object SCOM System Center Operations Manager

NTLM NT LAN Manager SCVVM System Center Virtualization Machine Manager

FBA Forms Based Authentication DPM Data Protection Manager

DNS Domain Name System RBS Remote Blob Store

ISA Internet Security and Acceleration TFS Team Foundation Server

TMG Threat Management Gateway OWA Office Web Applications

UAG Unified Access Gateway SMTP Simple Mail Transfer Protocol

SSL Secure Socket Layer BCS Business Connectivity Services

SSO Single Sign-On AAM Alternate Access Mapping


Necessary Integrations


Active Directory• Users and Groups

• Security groups vs. Distribution Lists• Managed Accounts• Permissions

• DNS• A (HOST) records vs. CNAME records

• Kerberos• Service Principal Names• ADSI Edit / SetSPN

• User Profile Sync• Permissions• Import AND Export

• Group Policy• Local Intranet Zone• Block / Track installations

• RMS: Rights Management• Office Documents• PDF Documents (add-on)


Active Directory - Demo


Office

• Office Client• Best: 2010• Whitepaper: http://go.microsoft.com/fwlink/?LinkId=209803

• Office Web Applications• Separate Installation• Office Professional Plus

• View and Edit in Browser• Internet Explorer, Safari, Firefox

• Co-Authoring• Client: Word, PowerPoint, OneNote

• Browser: Excel, OneNote

http://go.microsoft.com/fwlink/?LinkId=209803



Office Web Application - Demo


SQL

• Database Engine• SQL Alias• Integration Services (SSIS)

• Maintenance plans• Remote Blob Store

• Installation• Maintenance


SQL Server - Demo


Exchange

• Outgoing E-mail• SMTP Relay

• Incoming E-mail• Calendar Overlay


Exchange - Demo


Data Protection

• System Center• DPM – Backup and Recovery• SCOM – Health and Monitoring• SCVMM – Virtualization

• Forefront• Forefront Protection for SharePoint


Data Protection - Demo


Break


Enhanced Integrations


Lync

• Presence• Web Application Settings

• Additional Actions

• Skills Search• User Profile Images


Lync - Demo


External Connections• ISA / TMG

• Listeners• Firewall Policy• HTTP Filtering• SSO• Reverse Proxy• Default Domain• SSL• Custom Login Pages

• UAG• Required for Windows Phone 7

• Other Authentication• FBA• ADFS• Live ID


External Connections - Demo


SQL

• SSRS - Reporting Services• Integrated Mode• Report Builder 3.0• Subscriptions• Report Viewer web part• Content Types


SSRS - Demo


SQL

• SSAS - Analysis Services• Use with PerformancePoint• Dashboard Designer

• Dashboards• Scorecards• Reports• KPIs• Filters


SSAS - Demo


Team Foundation Server

• Additional Installation• Either on stand alone server or SharePoint Server• Extensions for SharePoint Products

• Does NOT work with claims• Web Interface and Visual Studio

• Bugs and Task tracking


TFS - Demo


Project Server

• Additional Installation• Service Application

• Multiple databases• Can be upgraded from 2007

• Project Web Access• Separate site collection• Provisioning takes a while

• Manage Permissions• Totally separate than SharePoint• Have to add everyone individually


Other Integrations


Other Integration Platforms

• Business Connectivity Services• PowerPivot• Great Plains• Commerce Server• CRM• SAP (Duet)• SQL Azure

Meeting # 80http://www.sharepointmn.comhttp://www.sharepointmn.com Meeting # 80

Q & A


• Configuring Kerberos Authentication for SharePoint 2010 Products• http

://www.microsoft.com/downloads/details.aspx?FamilyID=1a794fb5-77d0-475c-8738-ea04d3de1147

• Configure profile synchronization (SharePoint Server 2010)• http://technet.microsoft.com/en-us/library/ee721049.aspx

• Track or block SharePoint Server 2010 installations• http://technet.microsoft.com/en-us/library/ff730261.aspx

• AD RMS Supported Files• http://

blogs.msdn.com/b/rms/archive/2010/03/12/ad-rms-supported-files.aspx

• Business Productivity at Its Best: Office 2010 and SharePoint 2010 Better Together• http://go.microsoft.com/fwlink/?LinkId=209803

References

http://www.microsoft.com/downloads/details.aspx?FamilyID=1a794fb5-77d0-475c-8738-ea04d3de1147



http://technet.microsoft.com/en-us/library/ee721049.aspx

http://technet.microsoft.com/en-us/library/ff730261.aspx

http://blogs.msdn.com/b/rms/archive/2010/03/12/ad-rms-supported-files.aspx






• Database maintenance for SharePoint Server 2010• http://technet.microsoft.com/en-us/library/cc262731.aspx

• Install and configure RBS (SharePoint Server 2010)• http://technet.microsoft.com/en-us/library/ee748631.aspx

• Remote Blob Store (RBS) and SharePoint 2010 – Part 1• http://blogs.avtex.com/blogs/bcaauwe/archive/2011/04/15/remote-blob-store-rbs-an

d-sharepoint-2010-part-1.aspx

• Configuring incoming email in SharePoint 2010 with Exchange• http://sharepointgeorge.com/2010/configuring-incoming-email-sharepoint-201

0/

• Work with multiple Exchange and SharePoint calendars in one SharePoint calendar• http://office.microsoft.com/en-us/sharepoint-foundation-help/work-with-multi

ple-exchange-and-sharepoint-calendars-in-one-sharepoint-calendar-HA101777171.aspx

• SharePoint 2010 Products Management Pack for SCOM 2007• http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=4419

References

http://technet.microsoft.com/en-us/library/cc262731.aspx

http://technet.microsoft.com/en-us/library/ee748631.aspx

http://blogs.avtex.com/blogs/bcaauwe/archive/2011/04/15/remote-blob-store-rbs-and-sharepoint-2010-part-1.aspx

http://blogs.avtex.com/blogs/bcaauwe/archive/2011/04/15/remote-blob-store-rbs-and-sharepoint-2010-part-1.aspx

http://sharepointgeorge.com/2010/configuring-incoming-email-sharepoint-2010/


http://office.microsoft.com/en-us/sharepoint-foundation-help/work-with-multiple-exchange-and-sharepoint-calendars-in-one-sharepoint-calendar-HA101777171.aspx



http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=4419




• Lync 2010 Integration• http://technet.microsoft.com/en-us/library/gg398806.aspx

• What ever SharePoint administrator needs to know about AAM• http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?PageType=4&ListId={72C1C85

B-1D2D-4A4A-90DE-CA74A7808184}&pID=804

• Creating a custom Forefront TMG 2010 FBA logon page• http://

richardkok.wordpress.com/2010/10/22/creating-a-custom-forefront-tmg-2010-owa-fba-logon-page

• Configuring Reporting Services for SharePoint 2010 Integration• http://sharepointgeorge.com/2010/configuring-incoming-email-sharepoint-20

• Data warehousing, OLAP and Analysis Services for SharePoint 2010• http://technet.microsoft.com/en-us/library/ff696762.aspx

• Deployment for Project Server 2010• http://technet.microsoft.com/en-us/library/cc197280.aspx

References

http://technet.microsoft.com/en-us/library/gg398806.aspx

http://technet.microsoft.com/en-us/library/gg398806.aspx

http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?PageType=4&ListId=%7B72C1C85B-1D2D-4A4A-90DE-CA74A7808184%7D&pID=804



http://richardkok.wordpress.com/2010/10/22/creating-a-custom-forefront-tmg-2010-owa-fba-logon-page

http://richardkok.wordpress.com/2010/10/22/creating-a-custom-forefront-tmg-2010-owa-fba-logon-page






Meeting # 80http://www.sharepointmn.comhttp://www.sharepointmn.com Meeting # 80

Thanks for coming!

meeting # 80 welcome to the minnesota sharepoint user group july 13 th, 2011 sharepoint integration

Documents

tentative http

facebook group http

job postings http

mnspug slide

stuff sharepoint

conferences sharepoint

sharepoint shoptalk

ca slide