SharePoint’s Business Connectivity Service (BCS) is intended to provide SharePoint access to a variety of data sources to include:
- SQL Server
- WCF Service
- REST Service Connection
- XML file connection
Business Connectivity Services works.
- BCS Definitions are based on ‘operations’, Create, Read Item, Read List, Update and Delete
- BCS allows you to work directly with data stored in an external system or database
- Authentication can be done directly using User authentication or the SharePoint Secured Store Service can be used to authenticate with a specific account
- Information can be one-way (view only) or two-way (add, update & delete)
- BCS data sources can be ‘associated’ to one another to create ‘relationships’ – One-to-Many, One-to-One, etc.
- BCS Connections can be made using SharePoint Designer (easiest) or through Visual Studio
- BCS ‘definitions’ can be exported and imported across sites
- BCS is based on the “Business Data Catalog” and uses BDC definitions to access “line of business” (LOB) data.
- WCF provides the most flexibility and control of data and is best when multiple data sources must be combined to create the desired view
Step 1: Configure the BCS on following link steps.
Step 2: Ctreate external list in following link stephttp://www.codeproject.com/Articles/683749/Implementing-Business-Data-Connectivity-in-SharePo
Sometime following error occurred in the BCS:
There are no addresses available for this application.
Go to Central Administration --> Application Management --> Under Service ApplicationsClick Manage services on server. Start business data connectivity service.IIS Reset.
An error has occurred in the providers configured from this site collection
Solution:Execute the following powershell commands:
Set-SPBusinessDataCatalogThrottleConfig -Identity $BCSThrottle -Maximum 1000000 -Default 20000
$BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $bcs