460 likes | 560 Views
July 13 th , 2011. SharePoint Integration. Brian Caauwe. Agenda. Introductions Necessary Integrations Break Enhanced Integrations Other Integrations Q & A Wrap-up and Giveaways. User Group Goal / Objectives.
E N D
July 13th, 2011 SharePoint Integration Brian Caauwe
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) WroxPress (www.wrox.com) O’Reilly (www.oreilly.com)
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
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
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 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
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/
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
Quick Intro Brian Caauwe • Senior SharePoint Consultant • Pez Collector / n3rd • @bcaauwe • http://blogs.avtex.com/blogs/bcaauwe
WARNING WARNING Acronyms Glossary Required
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)
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
SQL • Database Engine • SQL Alias • Integration Services (SSIS) Maintenance plans • Remote Blob Store Installation Maintenance
Exchange • Outgoing E-mail SMTP Relay • Incoming E-mail • Calendar Overlay
Data Protection • System Center DPM – Backup and Recovery SCOM – Health and Monitoring SCVMM – Virtualization • Forefront Forefront Protection for SharePoint
Lync • Presence Web Application Settings • Additional Actions • Skills Search • User Profile Images
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
SQL • SSRS - Reporting Services Integrated Mode Report Builder 3.0 Subscriptions Report Viewer web part Content Types
SQL • SSAS - Analysis Services Use with PerformancePoint Dashboard Designer • Dashboards • Scorecards • Reports • KPIs • Filters
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
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 Integration Platforms • Business Connectivity Services • PowerPivot • Great Plains • Commerce Server • CRM • SAP (Duet) • SQL Azure
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
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
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