1 / 41

sharepointmn

Welcome to the Minnesota SharePoint User Group. July 14 th , 2010 Introducing the BCS. Raymond Mitchell. Meeting # 67. http://www.sharepointmn.com. Agenda. Introductions BCS Break A little more BCS Q & A. http://www.sharepointmn.com. User Group Goal / Objectives.

andrew
Download Presentation

sharepointmn

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Welcome to the Minnesota SharePoint User Group July 14th, 2010 Introducing the BCS Raymond Mitchell • Meeting # 67 http://www.sharepointmn.com

  2. Agenda • Introductions • BCS • Break • A little more BCS • Q & A http://www.sharepointmn.com

  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 http://www.sharepointmn.com

  4. Introductions – MNSPUG Sponsors Inetium (www.inetium.com) Technology consulting company Microsoft Gold Certified Partner Practice area focused on SharePoint Benchmark Learning (www.benchmarklearning.com) Microsoft Gold Certified Partner Training on many technologies Microsoft (www.microsoft.com) http://www.sharepointmn.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 http://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: @MNSPUG and #MNSPUG http://www.sharepointmn.com

  7. Upcoming Schedule Next Meeting Aug 11th9:00 AM to 11:30 AM Microsoft’s Bloomington Office Topic: Solution Showcase: Composite Application for Knowledge Management Check www.sharepointmn.com for updates! Ongoing Schedule 2nd Wednesday of every month 9:00 to 11:30 am Microsoft’s Bloomington Office http://www.sharepointmn.com

  8. Local Events SharePoint Saturday – October 2, 2010 *FREE*http://www.sharepointsaturday.org/twincities/default.aspxUniversity of Minnesota – East Bank, Twin Cities Campus http://www.sharepointmn.com

  9. Conferences • Best Practices Conference – August 24-27, 2010 • http://www.bestpracticesconference.comWashington, D.C. • SPTechCon – SharePoint Technology Conference – October 20-22, 2010 • http://www.benchmarklearning.com/techfuse.aspxBoston, MA • No SharePoint Conference this year… October 3-6, 2011 • http://www.mssharepointconference.com http://www.sharepointmn.com

  10. Announcements Outlook Social Connector Provider for Facebook http://www.microsoft.com/downloads/details.aspx?FamilyID=ce8b7517-234c-48a1-a655-324a88893b02&displaylang=en http://www.sharepointmn.com

  11. Introducing the BCS http://www.sharepointmn.com

  12. What is the BCS? Business Connectivity Services Evolution of the 2007 Business Data Catalog Framework for surfacing LOB data in SharePoint and Office http://www.sharepointmn.com

  13. BCS in SharePoint Server 2010 BCS Profile Import Sites Business Connectivity Services Composites Communities Insights Content Search BCS Search

  14. BCS Improvements Read AND Write capabilities Integration with office Offline capabilities Client Data Cache Tools! http://www.sharepointmn.com

  15. What do I need for BCS? Included in SharePoint Foundation Extended support in SharePoint Server: Profile Page External Data Search Secure Store Service SharePoint Server Enterprise: Office Client Integration Business Data Web Parts http://www.sharepointmn.com

  16. BCS SharePoint Integration External Lists Search External Data Columns Web Parts User Profiles Importer Custom Solutions Workflow Business Data Connectivity Services (BDC) Meta Data Store External data http://www.sharepointmn.com

  17. BCS Components External Systems Connection to a LOB System: Web Service Database .NET Type BDC Model (big, ugly XML file) Reference to the Entities and connection properties Can import into Visual Studio External Content Type Entity definition http://www.sharepointmn.com

  18. BCS Components Entity Definition: Fields and mappings Operations Associations Actions ECT Operations: Create Read Item Read List Update Delete http://www.sharepointmn.com

  19. BCS Components LOB System BDC DB Connector BCS Meta Data Store External System BDC Model External Content - Type Operations http://www.sharepointmn.com

  20. Demo 1 • Create an ECT http://www.sharepointmn.com

  21. BCS and Lists External Data Columns Added via the browser (similar to lookup fields) External Lists Added via SharePoint Designer http://www.sharepointmn.com

  22. Demo 2 • Add an External Data Column (via browser) • Add an External List (via SPD) http://www.sharepointmn.com

  23. BCS Web Parts Business Data Item Display a single BCS Entity Business Data Item Builder Get a BCS Entity based on a parameter Business Data List Get a list of BCS Entities Business Data Related List Display a related list of BCS Entities Business Data Connectivity Filter Provides filter data from BCS Entities Business Data Actions Displays a list of related actions for a BCS Entity http://www.sharepointmn.com

  24. Demo 3 • Build a UI for BDC Model using the BCS Web Parts http://www.sharepointmn.com

  25. BCS Actions Create parameterized URL “commands” for BCS entities Scenarios: Link to an existing LOB application page External service that takes a parameter Search engine Mapping application Custom ASPX page deployed to create custom visualization http://www.sharepointmn.com

  26. Demo 4 • Build a custom BCS Action http://www.sharepointmn.com

  27. Break 5-10 minutes

  28. BCS Search / Profile Pages Parameterized profile page created for each entity Search configured to index profile page Essentially indexes your LOB system Web Part Pages = Customizable http://www.sharepointmn.com

  29. Demo 5 • Configure and customize a profile page • Configure Search for BCS http://www.sharepointmn.com

  30. BCS Office Integration Word Use “Quick Parts” to configure BCS Data Columns Present LOB data in Word documents and templates http://www.sharepointmn.com

  31. Demo 6 • Create a word template that utilizes Quick Parts & BCS Data http://www.sharepointmn.com

  32. BCS Outlook Integration Connect an External List to OUTLOOK ECT must be configured/mapped to an Office Item Type Creates a ClickOnce application that is installed in Outlook BCS Client Runtime and Cache Configured so the client talks directly to the LOB system (doesn’t proxy through SharePoint Server) Create an “Outlook Declarative Solution” XML configuration for custom Task Panes in Outlook Walkthroughs available in the SDK http://www.sharepointmn.com

  33. Demo 7 • Connect an external list to Outlook http://www.sharepointmn.com

  34. BCS Associations Configure relationships between ECTs Limited with SharePoint Designer: Associations must be made in the correct order Advanced Associations are not supported http://www.sharepointmn.com

  35. BCS + PowerShell Can use PowerShell to work with the BCS Object Model BCS Cmdlets Get-Command –noun SP*BusinessData* http://www.sharepointmn.com

  36. BCS Custom Solutions Client and Server Object Model Client Cache for Offline VSTO for custom Office Extensions BCS connectivity in Excel http://www.sharepointmn.com

  37. SDK Don’t forget about the SharePoint Server 2010 SDK: http://www.microsoft.com/downloads/details.aspx?FamilyID=f0c9daf3-4c54-45ed-9bde-7b4d83a8f26f&displaylang=en http://www.sharepointmn.com

  38. Demo 8 • AdventureWorks2008 .NET Assembly Sample http://www.sharepointmn.com

  39. Q & A http://www.sharepointmn.com

  40. References BCS Team Blog: http://blogs.msdn.com/b/bcs/ SharePoint 2010 SDK: Download: http://www.microsoft.com/downloads/details.aspx?FamilyID=f0c9daf3-4c54-45ed-9bde-7b4d83a8f26f&displaylang=en View:http://msdn.microsoft.com/en-us/library/ee557253.aspx BCS Resource Center (MSDN) http://msdn.microsoft.com/en-us/sharepoint/ff660755.aspx http://www.sharepointmn.com

  41. Thanks for coming! http://www.sharepointmn.com

More Related