SharePoint 2013 Developer, Part 14 of 15: BCS

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.

Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.

Prerequisites

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

Meet the expert

Tim McCarthy

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. His expertise covers a wide range of Microsoft technologies including SharePoint/Office 365, Office Apps, Windows Phone, Windows 8, Azure, .NET Framework (ASP.NET, VSTO, Workflow, WCF, WPF), SQL Server, Active Directory, MS Exchange development, and Service Oriented Architecture (SOA) applications. Tim holds multiple Microsoft certifications and is a former Microsoft MVP in Solutions Architecture. He is the author of several books, has developed presentations for the Microsoft Developer Network (MSDN), and has written articles for SQL Server Magazine and Windows and .NET Magazine. He has been a featured speaker at conferences, user groups, and code camps worldwide. Before becoming an application developer, Tim was an officer in the United States Marine Corps.

Video Runtime

80 Minutes

Time to complete

220 Minutes

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)