Overview of Business Connectivity Services in SharePoint 2013
Overview of Business Connectivity Services in SharePoint 2013
Description:
Hi every one, today i am going to explain about BCS ( Business Connectivity Services ) concept. Here my concept is i have data into database table . i want to retrieve the data from the database into a SharePoint list using BCS
Go to the sql server machine and open the sql server.
Create a new database name called
"BCS_DB"
Create a Table and Columns like
"BSC_Sample"
Go to the SharePoint server machine and open the
SharePoint designer.
And then click the
"External Content Type" and then Click on External content new in the ribbon
click on external data resources Link button to
connect the data base server
Click on
Add connection button
Then We will get one popup to select the
Data Source Type
Here Enter the
Database server name and
Database name .
Here we can see our Database name and Tables.
right click on the table.select the option called
Create all operations
We can check what are the operations are going to perform to a particular table and click on
Next button
Please check the
Map to Identifier Check box to identify the Column and Click on
Finish Button
now our table is ready to use in our SharePoint server
Create a ShrePoint list . click on
create lists & Form button in ribbon tag
Enter the list name and click
ok Button
Click on Save Button or
Ctrl + S.
Then go to the SharePoint site and check the Added List
We may get This type of error for Access Denied.
To solve this problem we have to add the permissions in central admin like below .
Click on
Manage Service application
And Click on BCS Service
Select the Created External System Name and click on
set Object permissions Button into the Ribbon
Add the who one have Full permissions on the site and click on add Button and then Select the Check boxes And Click on
Ok Button
And then We might be face this problem also Because of Authentication mode
Go to the SharePoint designer and select the out Service
here we can see our
External system Name or
Edit the connection Properties, if you click that one popup will open.
Here we have column called
authentication made . by default User Identity value selected .
we have to change as a
BDC Identity
Then other new error message displayed says – meta data object has a property with name ‘AuthenticationMode’ and value ‘RevertToSelf’ etc….
We have to first enable BCS model to accept “RevertToSelf” as one of the authentication modes.
The “ReverToSelfAllowed” property is set to false by default. to change true i ran below
power shell script in management shell.
$bdc = Get-SPServiceApplication | where {$_ -match “Business Data Connectivity Service”};
$bdc.RevertToSelfAllowed = $true;
$bdc.Update();
Then Finally we can see the output . To fetch the data from the database.