Transcript Module 9 - SharePoint Practice

Microsoft Official Course
®
Module 9
Working with Business Connectivity
Services
Module Overview
• Business Connectivity Services in SharePoint 2013
• Creating BDC Models in SharePoint Designer
• Creating BDC Models in Visual Studio 2012
Lesson 1: Business Connectivity Services in
SharePoint 2013
• Overview of Business Connectivity Services
• BDC Model Files and Schema
• Introduction to External Content Types
• Introduction to External Systems
• Consuming External Data
Overview of Business Connectivity Services
BDC Model Files and Schema
BDC Model Files and Schema 2
BDC Model Files and Schema 3
BDC Model Files and Schema 4
• Sample method used to retrieve a single item:
<Method IsStatic="false" Name="DimEmployeeReadItem">
<Properties>
<Property Name="RdbCommandType">Text</Property>
<Property Name="RdbCommandText" Type="System.String">SELECT
[EmployeeKey], [FirstName], [LastName] FROM [dbo].[DimEmployee] WHERE
[EmployeeKey] = @EmployeeKey</Property>
<Property Name="BackEndObjectType"
Type="System.String">SqlServerTable</Property>
<Property Name="BackEndObject"
Type="System.String">DimEmployee</Property>
<Property Name="Schema" Type="System.String">dbo</Property>
</Properties>
<AccessControlList>…</AccessControlList>
<Parameters>…</Parameters>
<MethodInstances>…</MethodInstances>
</Method>
Introduction to External Content Types
• CRUDQ operations
• Create
• Finder
• SpecificFinder
• Update
• Delete
• Scope
• Farm
• App
Introduction to External Systems
• Define connections to external data sources
• Types of connections
• SQL Server
• WCF Services
• OData Services
• .NET Assembly
Consuming External Data
• External lists
• Column in custom list
• Business Data Web Parts
• Business Data List
• Business Data Related List
• Business Data Item
• Business Data Item Builder
• Business Data Action
• Business Data Connectivity Filter
Lesson 2: Creating BDC Models in SharePoint
Designer
• Configuring External System Connections
• Implementing External Content Types
• Configuring Actions and Profile Pages
• Creating External Lists
• Demonstration: Creating and Consuming an
External Content Type
Configuring External System Connections
• Connection Types
• WCF Service
• SQL Server
• .NET Type
• Authentication
• User’s Identity
• BDC Identity
• Impersonated Windows Identity
• Impersonated Custom Identity
Implementing External Content Types
• Operations
• ReadItem (Specific
Finder)
• ReadList (Finder)
• Create
• Update
• Delete
• Identifiers
• Associations
• Forward
• Reverse
Filters
Limit
Page Number
Comparison
Timestamp
Wildcard
Parameters
Input
Output
Configuring Actions and Profile Pages
• Profile Pages
• Display information for an item
• Uses the Business Data Item Builder web part
• Displays data from all associations
• Actions
• mailto:{0}
• http://www.bing.com/maps/?v=2&where={0},{1},{2},{3}
Creating External Lists
• SharePoint Designer
• SharePoint site
Demonstration: Creating and Consuming an
External Content Type
In this demonstration you will see how to:
• Create a secure store target application to
connect to external data sources
• Create an external content type in SharePoint
Designer
• Create an external list in SharePoint Designer
• Set permissions on an external content type in
Central Administration
• Browse data in an external list
Lesson 3: Creating BDC Models in Visual Studio
2012
• Using the BDC Model Designer
• Connecting to OData Sources
• Creating App-Scoped BDC Models
• Creating External Lists from App-Scoped BDC
Models
• Configuring Apps to Display External Lists
Using the BDC Model Designer
Using the BDC Model Designer 2
Connecting to OData Sources
Creating App-Scoped BDC Models
• Authentication modes
• PassThrough
• RevertToSelf
• Windows Credentials
• Credentials
• Digest Credentials
• OData Extension Provider
• App Deployment
• From Visual Studio (testing and development)
• From the public app store
• From the organization’s app catalog
Creating External Lists from App-Scoped BDC
Models
• Automatically created by OData connector
• Manually created by editing element.xml for a
custom list instance
<?xml version="1.0" encoding="utf-8"?>
<Elements xmlns="http://schemas.microsoft.com/sharepoint/">
<ListInstance Url="Lists/Territories" Description="Territories"
OnQuickLaunch="TRUE" Title="Territories">
<DataSource>
<Property Name="LobSystemInstance" Value="ContosoODataSurce" />
<Property Name="EntityNamespace" Value="NorthwindModel" />
<Property Name="Entity" Value="Territories" />
<Property Name="SpecificFinder" Value="ReadSpecificTerritory" />
<Property Name="MetadataCatalogFileName"
Value="BDCMetadata.bdcm" />
</DataSource>
</ListInstance>
</Elements>
Configuring Apps to Display External Lists
• AppManifest.xml
• Default.aspx
• User navigation
Lab: Working with Business Connectivity Services
• Exercise 1: Creating Farm-Scoped External Content
Types
• Exercise 2: Creating App-Scoped External Content
Types
Lab Scenario
Contoso has a database named ContosoRetailDW
that contains data used for sales analysis and
inventory management. Management want to
enable users from the Sales department to view a
list of regions in which Contoso conducts
business, and the associated customers in each of
these regions from a SharePoint site.
Your task is to create a farm-scoped BDC Model to
access data from the ContosoRetailDW database,
you will deploy the BDC model, and test the
model by creating sample pages to display a list of
Lab Scenario
regions with a corresponding list of customers.
In addition, management want to enable better
overview of the product inventory to selected parts
of the business. The IT department has developed
an OData web service to expose parts of the
database that are used for inventory management.
You will develop an App that includes a second
BDC model, by using the OData web service, that
enables users to interact with the inventory
management system through external lists in
SharePoint. The IT department will
Lab Scenario
• distribute the App to relevant departments within
the business.
Lab Review
• You need to create an external content type to expose
data from a SQL Server database. The content type must
be used in multiple Web Applications within your
SharePoint farm. What type of external content type would
you create? What tool would you use to create the ECT
with the least amount of coding effort?
• You need to create an external content type to expose
data from a custom data source. The custom data source
uses a binary file format documented by the developers
that created it. What tools would you use to create the
ECT?
• You need to create an external content type to expose
data from an OData service created by another developer.
What type of ECT would you create?
Module Review and Takeaways