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.