Creating Business Data Connectivity Service using SharePoint Designer 2010


Open SQL Server 2008 and create a database named BCSForSharePoint2010.

  • Create a new table named Trips as follows:

    Module6_video04_BCS_SPD_01.png

  • Data entry:

    Module6_video04_BCS_SPD_02 (1).png

Open SharePoint Designer 2010

        Module6_video04_BCS_SPD_03.png

  • Open to port your site:

    Module6_video04_BCS_SPD_04.png

  • Sign in SPD

    Module6_video04_BCS_SPD_05.png

  • You wait a moment:

    Module6_video04_BCS_SPD_06.png

  • Navigation Menu | Site Objects you select External Content Types

    Module6_video04_BCS_SPD_07.png

  • interface as follows

    Module6_video04_BCS_SPD_08.png

  • External Content Types you create by selecting the Icon External Content Types

    Module6_video04_BCS_SPD_09.png

  • initial interface is as follows:

    Module6_video04_BCS_SPD_10.png

  • Do you click on the link below to define datasource

    Module6_video04_BCS_SPD_11.png

  • then new interface Connection | choose Add Connection

    Module6_video04_BCS_SPD_12.png

  • dialog box appears | select SQL Server

    Module6_video04_BCS_SPD_13.png

  • In the SQL Server Connection:

    -Database Server: the name of your server
    -Database Name: the name of your database
    -All to the following default

    Module6_video04_BCS_SPD_14.png

  • While you wait a moment for a connection

    Module6_video04_BCS_SPD_15.png

  • After successful connection, the interface is as follows:

    Module6_video04_BCS_SPD_16.png

  • You must click on the table Trips, which is the action you choose to Create All Operations

    Module6_video04_BCS_SPD_17.png

  • Click on Next

    Module6_video04_BCS_SPD_18.png

  • The selected columns appear to show up SharePoint List:

    -TripID: Mapt to check the Properties window and check Show Print Picker Identifier

    Module6_video04_BCS_SPD_19.png

    -Destination: In the Properties window check Show Picker

    Module6_video04_BCS_SPD_20.png

    -The other columns you also check Show Print Picker

  • you do, you click Finish

    Module6_video04_BCS_SPD_21.png

  • After the task to display the column you select Icon Creates List & Form as follows:

    Module6_video04_BCS_SPD_22.png

  • dialog box appears; select Yes

    Module6_video04_BCS_SPD_23.png

  • Do you wait to save the configuration program

    Module6_video04_BCS_SPD_24.png

  • A dialog box appears; click OK

    Module6_video04_BCS_SPD_25.png

  • Back to the list site you choose:

    Module6_video04_BCS_SPD_26.png

  • Select List Trips

    Module6_video04_BCS_SPD_27.png

  • You will see the error occurs because users can not be added to services

    Module6_video04_BCS_SPD_28.png

    Fix: reference link (
     http://blogs.msdn.com/b/ericwhite/archive/2010/ 06/11/access-denied-by-business-data-connectivity.aspx )

  • Open Central Administration and select Manage service applications

    Module6_video04_BCS_SPD_29.png

  • You choose Data Connectivity Business Service

    Module6_video04_BCS_SPD_30.png

  • external content type you choose and select Icon Set Object Permissions

    Module6_video04_BCS_SPD_31.png

  • Add user and you choose the permissions for that user

    Module6_video04_BCS_SPD_32.png

  • Back to Site | Press F5 to refresh page error following results:

    Module6_video04_BCS_SPD_33.png

  • You can Edit Item

    Module6_video04_BCS_SPD_34.png

  • Edit and Save

    Module6_video04_BCS_SPD_35.png

  • Edit Item was

    Module6_video04_BCS_SPD_36.png

  • SQL Server Back to the original value has not changed, click Execute SQL Icon

    Module6_video04_BCS_SPD_37.png

  • See the results in SQL Edit

    Module6_video04_BCS_SPD_38.png

  • So you've finished creating the Business Data Connectivity Service.