Step 1: Connect to the Amazon ECommerce Web Service

SharePoint 2007

The LobSystem object is the top-level container for metadata that describes a particular business application. In XML terms, it is the root node that contains all other metadata objects. It provides authentication and connection string information to the Business Data Catalog. This topic explains how to define the XML for the LOBSystem object to connect to the Amazon Ecommerce Web Service.

The Amazon Ecommerce Web Service uses anonymous authentication. Therefore, in the sample we specify PassThrough authentication, which is easy to use. In this mode, the credentials are passed to the Web service but because the Web service is set up for anonymous access, it ignores the credentials.


The Web service does require a SubscriptionID that you must pass with all requests to the service. You can obtain a SubscriptionID by registering at Amazon's Web site.

Before you write metadata, you must set up your environment. This example assumes you have Microsoft Office SharePoint Server 2007 set up and that you have obtained a valid SubscriptionID from Amazon to use the Web services.

  1. Create a new text file and save it as AWSECommerceService.XML. Location of the file does not matter.

  2. Open the text file for editing in your text editor.

  3. Insert the following XML:

    <?xml version="1.0" encoding="utf-8" standalone="yes"?>
    <LobSystem xmlns:xsi="" xsi:schemaLocation=" BDCMetadata.XSD" Type="WebService" Version="" Name="AWSECommerceService" xmlns="">
        <Property Name="WebServiceProxyNamespace" Type="System.String">AWSECommerceService</Property>
        <Property Name="WsdlFetchAuthenticationMode" Type="System.String">PassThrough</Property>
        <Property Name="WsdlFetchUrl" Type="System.String"></Property>
        <Property Name="WildcardCharacter" Type="System.String">%</Property>
        <!-- The Business Data Catalog uses the Wildcard character specified here with filter parameters.-->
        <LobSystemInstance Name="AWSECommerceService">
            <Property Name="WebServiceAuthenticationMode" Type="System.String">PassThrough</Property>
            <!--Property Name="WebProxyServerConfiguration" Type="System.String">EnterYourProxyServerURL</Property-->
        <!--Enter your entity XML here.-->
  4. Enter your proxy server URL in the WebProxyServerConfiguration property and uncomment the line if you need to. For details, review the comment t.

  5. Save the XML file.

Community Additions