SharePoint Integration Strategies & Updates

1. July 13th, 2011 SharePoint Integration Brian Caauwe

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

3. 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

4. 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) WroxPress (www.wrox.com) O’Reilly (www.oreilly.com)

5. www.SharePointMN.com • Website for user group • SharePoint resource documents • SharePoint resource links • RSS Feeds • Meeting Schedule • Past User Group Presentations • info@sharepointmn.com www.sharepointmn.com

6. 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

7. 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

8. News and Stuff SharePoint 2010 SP1 Released http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?pID=984Install June 2011 Cumulative Update after install! Office 365 Launch! http://www.Office365.com June 2011 MNSPUG presentation: “Office 365 & Hosted Solutions - SharePoint in the Cloud” SharePoint Adoption Kit http://sharepoint.microsoft.com/iusesharepoint/Pages/get-the-kit.aspx Promote SharePoint within your organization

9. Local and Online Events ScarePoint Saturday – October 29th (tentative) http://www.sharepointsaturday.org/twincities/default.aspxNormandale College– Bloomington, MN Microsoft Webcast Calendar of Events http://www.microsoft.com/events/webcasts/calendar/monthview.aspx#filter SharePoint ShopTalk (Online) – Every Thursday @ 11:30 AM http://sharepointshoptalk.blogspot.com/

10. Conferences SharePoint Saturday – The Conference – Aug 11-13th, 2011 http://www.spstc.org/Pages/default.aspx Washington, DC Microsoft SharePoint Conference – Oct 3-6th, 2011 http://www.MSSharePointConference.com Anaheim, CA

11. Giveaways!

12. Presenters

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

14. WARNING WARNING Acronyms Glossary Required

15. Acronyms

16. Necessary Integrations

17. 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)

18. Active Directory - Demo

19. 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

20. Office Web Application - Demo

21. SQL • Database Engine • SQL Alias • Integration Services (SSIS) Maintenance plans • Remote Blob Store Installation Maintenance

22. SQL Server - Demo

23. Exchange • Outgoing E-mail SMTP Relay • Incoming E-mail • Calendar Overlay

24. Exchange - Demo

25. Data Protection • System Center DPM – Backup and Recovery SCOM – Health and Monitoring SCVMM – Virtualization • Forefront Forefront Protection for SharePoint

26. Data Protection - Demo

27. Break

28. Enhanced Integrations

29. Lync • Presence Web Application Settings • Additional Actions • Skills Search • User Profile Images

30. Lync - Demo

31. 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

32. External Connections - Demo

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

34. SSRS - Demo

35. SQL • SSAS - Analysis Services Use with PerformancePoint Dashboard Designer • Dashboards • Scorecards • Reports • KPIs • Filters

36. SSAS - Demo

37. 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

38. TFS - Demo

39. 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

40. Other Integrations

41. Other Integration Platforms • Business Connectivity Services • PowerPivot • Great Plains • Commerce Server • CRM • SAP (Duet) • SQL Azure

42. Q & A

43. References • 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

44. References • 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-and-sharepoint-2010-part-1.aspx • Configuring incoming email in SharePoint 2010 with Exchange http://sharepointgeorge.com/2010/configuring-incoming-email-sharepoint-2010/ • Work with multiple Exchange and SharePoint calendars in one SharePoint calendar http://office.microsoft.com/en-us/sharepoint-foundation-help/work-with-multiple-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

45. References • 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={72C1C85B-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

46. Thanks for coming!