Business Connectivity Services (BCS)
Business
Connectivity Services (BCS) is a set of components that enable you to work with
data that resides outside of SharePoint. The BCS enables you to support the
full range of create, retrieve, update, delete, and query (CRUDQ) data
operations on external data sources from SharePoint and from Office client applications.
We can also connect to database using web
service, or data that is published as an OData source or any other types of
external data. Business Connectivity Services
(BCS) does this through out-of-the box or custom
connectors.
External Content Types in BCS
The external
content type is a core concept of Business Connectivity Services (BCS). Used
throughout the functionality and services offered by BCS, external content
types are reusable metadata descriptions of connectivity information and data
definitions plus the behaviors you want to apply to a certain category of
external data.
External content
types enable you to manage and reuse the metadata and behaviors of a business
entity, such as a customer or order from a central location, and enable users
to interact with that external data and processes in a more meaningful way.
More details on content types in BCS see External
content types in SharePoint 2013.
Follow the steps to Connect with SQL External Data
Source
1. Open the
SharePoint Designer 2013:
2. Provide URL of Site to Open:
3. Provide Credentials to open the site:
4. Create the new external content type
and here provide the name of the content type
5. Click on the link text "Click
here to discover the external data source operations:
6. Click on the "Add
Connection", we can create a new connection by selecting any like .NET
Type, SQL Server, WCF Service.
7. Selected SQL server, and enter the
Server credentials:
8. Now, see all the tables and views from the
database.
9. Following option to create operations
against the database:
10. Click on the Next button:
11. Parameters Configurations:
12. Options for Filter parameters
Configuration:
13. Now add new External List,
Click on the "External List":
14. Select the Site and click OK:
15. Provide the list name and click OK:
16. Refresh the SharePoint site, see the
external list here and click on the list:
We got error message here "Access denied by
Business Connectivity."
Solution for Access denied by Business
Connectivity Error
17. SharePoint central admin, click on the
Manage service application:
18. Click on the Business Data
Connectivity Service:
19. Set the permission for list:
20. Click OK button after setting the
permissions:
21. Refresh the site this will work. If error
message like Login failed for user "NT AUTHORITY\ANONYMOUS LOGON".
Following way to resolve the “NT AUTHORITY\ANONYMOUS LOGON" Error
22. Change the connection properties, the
Authentication mode selects the value
"BDC Identity"
.
23. Open SharePoint Management Shell and run
following
$bdc = Get-SPServiceApplication |
where {$_ -match “Business Data Connectivity
Service”}
$bdc.RevertToSelfAllowed = $true
$bdc.Update();
Now it will work.
24. If still error as following:
Following way to resolve the errors
25. Open SharePoint Management Shell and run
the following -
$bcs = Get-SPServiceApplicationProxy |
where{$_.GetType().FullName
-eq
(‘Microsoft.SharePoint.BusinessData.SharedService.’ +
‘BdcServiceApplicationProxy’)}
$BCSThrottle =
Get-SPBusinessDataCatalogThrottleConfig -Scope database
-ThrottleType items -ServiceApplicationProxy $bcs
Set-SPBusinessDataCatalogThrottleConfig -Identity
$BCSThrottle -Maximum 1000000 -Default 20000
Finally it will work.
Thank you very
much
Fahadullah Karimi
SharePoint Specialist
Next Post| Configure Business Data Connectivity Service in SharePoint 2013 | Custom Search Apps Using REST API in SharePoint 2013 |
No comments:
Post a Comment