Learn your way! Get started

SharePoint 2013 Developer, Part 14 of 15: BCS

with expert Tim McCarthy

Watch trailer

Course at a glance

Included in these subscriptions:

  • Dev & IT Pro Video
  • Dev & IT Pro Power Pack

Release date 3/23/2014
Level Advanced
Runtime 1h 20m
Closed captioning Included
Transcript Included
eBooks / courseware Included
Hands-on labs N/A
Sample code Included
Exams Included

Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

Course description

The main capability of Business Connectivity Services (BCS) in SharePoint 2013 is to expose line of business (LOB) data as external content types. Once defined, then then BCS allows the creation of lists that use the external content types which then have all of the rich goodness of standard SharePoint lists. The external data can be anything from database sources to WCF web services or even OData REST web services. After this course, you will understand the nuances of BCS and how to create external content types using both SharePoint Designer 2013 and Visual Studio 2013. You will also learn how to consume WCF web services as well as REST web services that use the OData protocol.


This course assumes that students have some Web development background and some experience using Visual Studio 2012.

Learning Paths

This course will help you prepare for the following certifications and exams:
MCSD: SharePoint Applications
70-489: Developing Microsoft SharePoint Server 2013 Advanced Solutions
70-488: Developing Microsoft SharePoint Server 2013 Core Solutions

This course is part of the following LearnNowOnline SuccessPaths™:
SharePoint 2013 Developer

Meet the expert

Tim McCarthy is a senior solutions architect with Perficient who designs and builds highly scalable, layered web, desktop, and mobile applications utilizing the latest Microsoft platforms and technologies.

Course outline

Business Connectivity Services

Business Connectivity Services (12:49)
  • Introduction (00:19)
  • Business Connectivity Service (02:31)
  • What BCS Does (02:10)
  • Concepts (01:55)
  • Security/Connection Management (01:56)
  • Demo: Looking at Secure Store (03:46)
  • Summary (00:09)
Tooling (35:29)
  • Introduction (00:18)
  • Tooling (00:29)
  • Tooling-cont- (02:41)
  • Demo: Creating External Conte (13:25)
  • Adding Behavior (02:08)
  • Adding Behavior-cont- (00:44)
  • Demo: Adding Behavior (04:36)
  • Filters (02:23)
  • External Data Column (01:14)
  • Demo: Adding external data (06:14)
  • Search and Profile Pages (00:50)
  • Summary (00:23)
VisualStudio (10:16)
  • Introduction (00:15)
  • Business Data Connectivity Model (01:01)
  • Migrating Declarative Models (00:53)
  • Demo: Creating Visual Studio (07:53)
  • Summary (00:13)
Consuming Web Pages (21:51)
  • Introduction (00:15)
  • Consuming Web Services (01:06)
  • REST API (01:53)
  • REST API (cont) (00:44)
  • OData Protocol (00:49)
  • Consuming OData Sources (01:32)
  • Rest and OData Demo (04:56)
  • connect OData Demo (cont.) (04:20)
  • connect BCD model Demo (cont.) (05:57)
  • Summary (00:14)