1 / 24

What’s New? – BCS 2013

What’s New? – BCS 2013. Brett Lonsdale. Brett Lonsdale. Co-founder of Lightning Tools One of the hosts on the SharePoint Pod Show Co-organizer of SharePoint Saturday UK Author of SharePoint 2010 Business Connectivity Services

raja
Download Presentation

What’s New? – BCS 2013

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. What’s New? – BCS 2013 Brett Lonsdale

  2. Brett Lonsdale • Co-founder of Lightning Tools • One of the hosts on the SharePoint Pod Show • Co-organizer of SharePoint Saturday UK • Author of SharePoint 2010 Business Connectivity Services • Author of SharePoint 2007 Developers Guide to the Business Data Catalog • Contributing author of many other books inc Admin Companions… • Twitter: @brettlonsdale

  3. The next hour…

  4. High Level View • External Data in SharePoint • External Data in the Client • Authentication Options • Secure Store • Windows Authentication • Revert To Self • Username & Password • Multiple Connectors • SQL • WCF • .NET Assembly • OData

  5. Getting up to Speed • External Lists • Business Data Web Parts • Search • Business Data Column • User Profile Import • External Content Types • Tooling

  6. History Lesson

  7. What’s new?

  8. Excel integration • One way sync with Excel • Used to have to codewith Visual Studio Tools for Office (VSTO)

  9. Demo Syncing an External List with Microsoft Excel 2013

  10. Connecting to External Data • SharePoint Designer • .NET Assembly • SQL Server • WCF Service • Visual Studio 2012 • Anything • OData (New)

  11. OData • Open Data Protocol (Microsoft) • Can use without Microsoft technology • SQL Azure (Supports OData) • Plug Ins for Excel • MySQL, PHP, (OData tools) • GData (Google Equivalent)

  12. CRUD • (Create Read Update Delete) • Querying • Path/Products(1) • Path/Products?filter=name eq ‘value’ • Path/Products?$Select • Path/Products?$Orderby • Path/Products?$top10 • Path/Products(1)?$Expand=Orders • Metadata • Path/Products?$metadata

  13. OData • Open Data Protocol • Exchange Data Over the Web • Return Data • HTTP • JSON • ATOMPUB (ATOM Publishing Protocol) • Service End Point • Get Patch Post Delete

  14. OData

  15. OData & BCS

  16. Deploy ECT’s as an App • No longer need to be Farm Solutions • Easier deployment • Better development environment

  17. Demo Creating and deploying an ECT as an App using OData

  18. Alerts and Events • External List Alerts • Enabled as a Feature • External List Event Receivers • Custom Code • Entity Event Receivers • Custom Code

  19. Demo Enabling Alerts on an External List

  20. External List Event Receivers • Item Added • Item Adding • Item is Updated • Item is Updating • ….

  21. Attach Event Receiver to External List

  22. Remote External Event Receiver • Notification of a change in the underlying data source Data Source SharePoint Notification System http://msdn.microsoft.com/en-us/library/jj164024.aspx

  23. Remote External Event Receiver • BDC Model with EventSubscriberEventUnSubscriber • Determine Underlying Changes (Service) • Receive & Record Subscriptions • SubscriptionID • Delivery Address • Event Type • Entity Name • Post Notifications to REST

  24. The End!

More Related