SharePoint, Business Data Connectivity

Learning about SharePoint BDC, that is an standard functionality that is there in the server, but that the configuration and its start-up is not free in terms of effort.

1.- BDC service provides a means for storing and securing external content types and related objects. An external content type defines the following:

  • A set of fields of data, such as “building”, “room”, “connection”
  • The operations for interacting with the data’s external system, such as read, write, and create. There are so much options here.
  • The connectivity information that lets solutions that use the external content type connect to the external system.

2.-External content types are stored in a dedicated database that is part of the BDC service.

3.- To guarantee a secure connection, credential sets for the external systems are created. These credential sets are associated with identities of individuals or with group identities. All these data is stored in a secure database that belongs formally to the Secure Store Service.

To have BDC enabled into your MOSS server, you have to:

  • Activate BDC
  • Grant Access to BDC
  • Define the External sources you want to connect
  • Define and create the external content type
  • Create the Connection to SQL-Server

Note: to be able to configure the BDC you need to be granted as SharePoint Farm Administrator.

These are the basics, I’m not an expert for sure, but I need to understand what is behind.

Leave a Comment