480 likes | 631 Views
June 13 th , 2012. 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
June 13th, 2012 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… Post Job Posting on the Jobs Discussion page http://www.linkedin.com/groups?gid=1878792 • Twitter tags - @MNSPUG and #MNSPUG
Upcoming Schedule • Next Meeting July 11th 9:00 AM to 11:30 AM Microsoft Technology Center Check www.SharePointMN.com for updates! MNSPUG and MN UC User Group – Lync and SharePoint , Better Together! • Ongoing Schedule 2nd Wednesday of every month 9:00 to 11:30 am Microsoft Technical Center - Edina
Local and Online Events 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/ SharePoint Legal Users Group – 3rd Thursday @ 12:00 to 1:00 p.m. http://sharepointmnlegal.com Minnesota Developers SharePoint Users Group – 4th Wednesday@ 8:30 to 10:30 a.m. http://mndevspug.com Microsoft SharePoint Conference 2012 – 4thNovember 12 – 15, 2012 Las Vegas, Nevada http://www.mssharepointconference.com/Pages/default.aspx Anything Else?
We Want You! • MN SharePoint User Group looking for speakers You know something about SharePoint Someone you know, knows something about SharePoint Speak about something you implemented • Email: info@sharepointmn.com Name Contact Information Background Information Subjects comfortable talking about
Surveys & Giveaways! Congratulations! Jenny Jacobson Treasure Island Resort & Casino
Quick Intro Brian Caauwe • Senior SharePoint Consultant • Pez Collector / n3rd • @bcaauwe • http://blog.avtex.com/author/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 • SharePoint Workspace
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 • Outlook Web App Web Parts
Windows PowerShell • More than just SharePoint Registry Access Other .NET Assemblies More and More Cmdlets coming shipped out of the box • SharePoint 2010 Management Shell New command line tool deprecating STSADM Run “As Administrator” Registers Microsoft.SharePoint.PowerShell ExecutionPolicy sets to RemoteSigned Uses the SharePoint Object Model
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
CRM • List Components for SharePoint 2010 View documents stored in SP from CRM Sandbox Solution • Business Connectivity Services Generator Tool Uses web services for CRUD capabilities
Other Integration Platforms • Business Connectivity Services • PowerPivot • Power View • Great Plains • Commerce Server • 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 • Microsoft CRM 2011 List Component for SharePoint 2010 http://www.microsoft.com/en-us/download/details.aspx?id=5283
Last But Not Least • Please Fill Out Evaluations • Drawings for Giveaways • Today’s Presenter: Brian Caauwe