Downloaded 58 times
Uploaded byCorey Roth
Surfacing Your External Data using BCS in SharePoint 2013 - Dev Connections 2013
This document summarizes a presentation about surfacing external data using Business Connectivity Services (BCS) in SharePoint 2013. The presentation was intended to be delivered by Fabian Williams and Corey Roth but Fabian became ill with chicken pox. As a result, Corey Roth focused the presentation more on BCS and search aspects. The presentation covered BCS overview, configuring search with BCS, customizing search for BCS, and building a search app.
Surfacing Your External Data using BCS in SharePoint 2013 - Dev Connections 2013
- 1. Surfacing your ExternalData using BCS in SharePoint 2013 Fabian Williams SharePoint Architect Planet Technologies, Inc. @fabianwilliams Corey Roth Principal Architect Infusion @coreyroth
- 2. SESSION TITLE COREY ROTH Transplant to Houston, TX Principal Architect at Infusion Development SP2 Apps for SharePoint 2013 Four-timeMicrosoft Specializing www.devconnections.com SharePoint MVP in ECM, Search, and apps 2
- 3. SESSION TITLE WHERE ISFABIAN? www.devconnections.com 3
- 4. SESSION TITLE FABIAN HASCHICKEN POX! www.devconnections.com 4
- 5. SESSION TITLE FABIAN WILLIAMS • SharePointArchitect at Planet Technologies in the Federal IW Practice • SharePoint Community Activist • • SharePoint Saturday Speaker • • International Speaker MS SharePoint Conference Speaker Avid/Incessant Blogger/Tweeter/Social Media Menace • • • @fabianwilliams http://www.sharepointfabian.com/blog Send him a tweet wishing him to get well soon! www.devconnections.com 5
- 6. SESSION TITLE SOME CHANGES… No Fabian = no alerts Talk will focus more on BCS and search aspects now Feel free to leave…no hard feelings www.devconnections.com 6
- 7. SESSION TITLE AGENDA BCS Overview Configuring Search with BCS Customizing Search for BCS Search www.devconnections.com App 7
- 8. SESSION TITLE WHY DOI CARE? Line of Business integration is a great often unused SharePoint feature Use SharePoint to search custom applications instead of writing your own Allows global enterprise-wide search across SharePoint and applications www.devconnections.com 8
- 9. SESSION TITLE BUSINESS CONNECTIVITYSERVICES (BCS) www.devconnections.com 9
- 10.
- 11. SESSION TITLE SUMMARY OFWHAT’S IN BCS www.devconnections.com 11
- 12. SESSION TITLE LIMITATIONS AFFECTINGBCS www.devconnections.com 12
- 13. SESSION TITLE EXTERNAL CONTENTTYPES www.devconnections.com 13
- 14.
- 15. SESSION TITLE BCS WITHSEARCH Create models with SPD or Visual Studio Be sure to configure a profile page site in BCS Be sure and set Title column www.devconnections.com 15
- 16.
- 17.
- 18. SESSION TITLE CONFIGURING SEARCHWITH BCS Content source Source – used to index BCS Full crawl required every time schema is changed No security trimming by default Default content access account needs permissions to: Database (read only) BCS (Execute / Select in Clients) www.devconnections.com 18
- 19. SESSION TITLE SEARCH SCHEMA Defines what search can crawl, query, and refine on Crawled properties – discovered during crawl Managed 2013 level properties – usable by search - Defined at tenant, site collection, and site More granular and configurable in 2013 www.devconnections.com 19
- 20. SESSION TITLE SEARCH SCHEMAWITH BCS Table columns mapped to crawled properties Map crawled properties to managed properties to: Display values in search results Query against values Configure refinement www.devconnections.com 20
- 21. SESSION TITLE MANAGED PROPERTIES- ATTRIBUTES Searchable – included in full-text index Queryable – can be queried specifically Retrievable – can be displayed in search results Refinable – used in refinement panel Sortable – built-in now! Safe – displayed for anonymous users Complete Matching – requires exact match www.devconnections.com 21
- 22. SESSION TITLE DEMO Search configurationwith BCS www.devconnections.com 22
- 23. SESSION TITLE DISPLAY TEMPLATES Customize Allows results how individual search results look BCS table columns to be shown in search Use managed properties marked with Retrievable Managed www.devconnections.com as HTML snippets in Design Manager 23
- 24.
- 25. SESSION TITLE DEMO Searching externalcontent in SharePoint www.devconnections.com 25
- 26. SESSION TITLE BUILDING ASEARCH APP www.devconnections.com 26
- 27. SESSION TITLE QUERYING SEARCH New Search REST API added Available at /_api/search/query Use querytext parameter to query Enclose query in single quotes Example Test http://server/_api/search/query?querytext=’SharePoint’ directly in the browser www.devconnections.com 27
- 28. SESSION TITLE REST +JAVASCRIPT Assemble REST API URL Include path to REST API Use KQL in querytext parameter Use $.ajax() to execute query Include Headers: { “Accept”: “application/json; odata=verbose” } Retrieve search results from: data.d.query.PrimaryQueryResult.RelevantResults.Table.Ro ws.results www.devconnections.com 28
- 29. SESSION TITLE REST +JAVASCRIPT CODE www.devconnections.com 29
- 30. SESSION TITLE SEARCH APP Use JavaScript and REST API to search our BCS source Result BCS source used to pre-filter results for www.devconnections.com 30
- 31. SESSION TITLE DEMO Building anapp to search external data www.devconnections.com 31
- 32. SESSION TITLE RECAP BCS Overview Configuring Search with BCS Customizing Search for BCS Search www.devconnections.com App 32
- 33. SESSION TITLE RESOURCES Search withREST and JavaScript http://bit.ly/16LmtDj BCS and Subscriptions http://bit.ly/14ysPHe www.devconnections.com 33
- 34.