SharePoint BDC - Step By Step
Business Data Catalog, a new feature introduced in MOSS2007, provides an easy way to integrate business data from external database/web services , such as SAP, Oracle, SQL Server, Web Services or Siebel without writing any code. Business Data Catalog comprises a metadata database and an object model that provide a simple, consistent object-oriented programming interface for business logic that lives in the various business applications. To use BDC in MOSS we need to configure SharePoint Shared Service Provider. We can go to SharePoint Central Administration and select Shared Services Administration link. To create a new SSP use the following steps: 1. Click on New SSP 2. Fill in SSP Name [Lets name it "MyDefaultSSP"] and Associated Web Application 3. Select/Fill In Other necessary information based on your Farm settings 4. Click OK If you have multiple SSPs configured, you may change the web application association by selecting Change Association link at the top. After you ha...