ビジネスデータカタログ (Business Data Catalog) のサンプル 【RTM 日本語版】

環境:
Office SharePoint Server 2007 (RTM) 日本語


こんにちは。


SQL Server 2005 のサンプルデータベースである AdventureWorksDW データベースを使って動作するビジネスデータカタログの RTM 版 (日本語版) のサンプルを添付しておきます。


Beta 2 TR の時にあった ExactMatch が無くなっているので、ご注意ください。 


==================================================


<?xml version=”1.0″ encoding=”shift_jis” standalone=”yes”?>
<LobSystem
  xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance
  xsi:schemaLocation=”http://schemas.microsoft.com/office/sps/2005/bdcMetadata BDCMetadata.xsd”
  Type=”Database”
  Version=”1.0.1.1″
  Name=”AdventureWorksDW”
  xmlns=”http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog“>
  <LobSystemInstances>
    <LobSystemInstance Name=”AdventureWorksDW”>
      <Properties>
        <Property Name=”AuthenticationMode” Type=”System.String”>PassThrough</Property>
        <Property Name=”DatabaseAccessProvider” Type=”System.String”>SqlServer</Property>
        <Property Name=”RdbConnection Data Source” Type=”System.String”>tsmatsuz11OfficeServers</Property>
        <Property Name=”RdbConnection Initial Catalog” Type=”System.String”>AdventureWorksDW</Property>
        <Property Name=”RdbConnection Integrated Security” Type=”System.String”>SSPI</Property>
        <Property Name=”RdbConnection Pooling” Type=”System.String”>false</Property>
      </Properties>
    </LobSystemInstance>
  </LobSystemInstances>
  <Entities>
    <Entity EstimatedInstanceCount=”1000″ Name=”Part”>
      <Properties>
        <Property Name=”__BdcTitle” Type=”System.String”>PartName</Property>
        <Property Name=”Title” Type=”System.String”>PartName</Property>
      </Properties>
      <Identifiers>
        <Identifier Name=”PartKey” TypeName=”System.Int32″ />
      </Identifiers>
      <Methods>
        <Method Name=”PartFinder”>
          <Properties>
            <Property Name=”RdbCommandText” Type=”System.String”>
              SELECT distinct p.*
              FROM
              Part p
              inner join product_part pp on p.PartKey = pp.PartKey
              inner join Product prod on pp.ProductKey = prod.ProductKey
              WHERE
              (p.PartKey &gt;= @MinPartKey) AND
              (p.PartKey &lt;= @MaxPartKey) AND
              (prod.ProductCode LIKE @ProductCode)
              </Property>
            <Property Name=”RdbCommandType” Type=”System.Data.CommandType,System.Data,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b77a5c561934e089″>Text</Property>
          </Properties>
          <FilterDescriptors>
            <FilterDescriptor Type=”Wildcard” Name=”ByProductCode”>
              <Properties>
                <Property Name=”UsedForDisambiguation” Type=”System.Boolean”>true</Property>
              </Properties>
            </FilterDescriptor>
            <FilterDescriptor Type=”Comparison” Name=”Key” />
          </FilterDescriptors>
          <Parameters>
            <Parameter Direction=”In” Name=”@MinPartKey”>
              <TypeDescriptor Name=”MinPartKey” TypeName=”System.Int32″ IdentifierName=”PartKey” AssociatedFilter=”Key”>
                <DefaultValues>
                  <DefaultValue MethodInstanceName=”PartFinderInstance” Type=”System.Int32″>0</DefaultValue>
                  <DefaultValue MethodInstanceName=”PartSpecificFinderInstance” Type=”System.Int32″>0</DefaultValue>
                </DefaultValues>
              </TypeDescriptor>
            </Parameter>
            <Parameter Direction=”In” Name=”@MaxPartKey”>
              <TypeDescriptor Name=”MaxPartKey” TypeName=”System.Int32″ IdentifierName=”PartKey” AssociatedFilter=”Key”>
                <DefaultValues>
                  <DefaultValue MethodInstanceName=”PartFinderInstance” Type=”System.Int32″>9999999</DefaultValue>
                  <DefaultValue MethodInstanceName=”PartSpecificFinderInstance” Type=”System.Int32″>9999999</DefaultValue>
                </DefaultValues>
              </TypeDescriptor>
            </Parameter>
            <Parameter Direction=”In” Name=”@ProductCode”>
              <TypeDescriptor Name=”ProductCode” TypeName=”System.String” AssociatedFilter=”ByProductCode”>
                <DefaultValues>
                  <DefaultValue MethodInstanceName=”PartFinderInstance” Type=”System.String”>%</DefaultValue>
                  <DefaultValue MethodInstanceName=”PartSpecificFinderInstance” Type=”System.String”>%</DefaultValue>
                </DefaultValues>
              </TypeDescriptor>
            </Parameter>
            <Parameter Name=”Parts” Direction=”Return”>
              <TypeDescriptor Name=”Parts” TypeName=”System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″ IsCollection=”true”>
                <TypeDescriptors>
                  <TypeDescriptor Name=”Part” TypeName=”System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″>
                    <TypeDescriptors>
                      <TypeDescriptor Name=”PartKey” TypeName=”System.Int32″ IdentifierName=”PartKey”>
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID=”1041″>部品番号</LocalizedDisplayName>
                        </LocalizedDisplayNames>
                        <Properties>
                          <Property Name=”DisplayByDefault” Type=”System.Boolean”>true</Property>
                        </Properties>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName=”System.String” Name=”PartCode”>
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID=”1041″>部品コード</LocalizedDisplayName>
                        </LocalizedDisplayNames>
                        <Properties>
                          <Property Name=”DisplayByDefault” Type=”System.Boolean”>true</Property>
                        </Properties>
                      </TypeDescriptor>
                      <TypeDescriptor Name=”PartName” TypeName=”System.String”>
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID=”1041″>部品名</LocalizedDisplayName>
                        </LocalizedDisplayNames>
                        <Properties>
                          <Property Name=”DisplayByDefault” Type=”System.Boolean”>true</Property>
                        </Properties>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName=”System.Int16″ Name=”ReorderPoint”>
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID=”1041″>再注文</LocalizedDisplayName>
                        </LocalizedDisplayNames>
                        <Properties>
                          <Property Name=”DisplayByDefault” Type=”System.Boolean”>true</Property>
                        </Properties>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName=”System.Int32″ Name=”Inventory”>
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID=”1041″>インベントリー</LocalizedDisplayName>
                        </LocalizedDisplayNames>
                        <Properties>
                          <Property Name=”DisplayByDefault” Type=”System.Boolean”>true</Property>
                        </Properties>
                      </TypeDescriptor>
                    </TypeDescriptors>
                  </TypeDescriptor>
                </TypeDescriptors>
              </TypeDescriptor>
            </Parameter>
            </Parameters>
            <MethodInstances>
              <MethodInstance Name=”PartFinderInstance” Type=”Finder” ReturnParameterName=”Parts” />
              <MethodInstance Name=”PartSpecificFinderInstance” Type=”SpecificFinder” ReturnParameterName=”Parts” />
            </MethodInstances>
        </Method>
      </Methods>
      <Actions>
        <Action Name=”注文をおこなう” Position=”1″ IsOpenedInNewWindow=”true” Url=”http://tsmatsuz11/sites/officedemo/_layouts/FormServer.aspx?XsnLocation=http://tsmatsuz11/sites/officedemo/FormServerTemplates/TestForm1[1].xsn&amp;SaveLocation=http://tsmatsuz11/sites/officedemo/DocLib2&amp;openin=browser&amp;PartCode={0}” ImageUrl=””>
          <ActionParameters>
            <ActionParameter Name=”PartCode” Index=”0″ />
          </ActionParameters>
        </Action>
      </Actions>
    </Entity>
    <Entity EstimatedInstanceCount=”10000″ Name=”Product”>
      <Properties>
        <Property Name=”Title” Type=”System.String”>ProductName</Property>
      </Properties>
      <Identifiers>
        <Identifier TypeName=”System.Int32″ Name=”ProductKey” />
      </Identifiers>
      <Methods>
        <Method Name=”GetProducts”>
          <Properties>
            <Property Name=”RdbCommandText” Type=”System.String”>
              select * from
              product
              where
              ProductCode like @productCode and
              ProductName like @productName and
              ProductKey &lt;= @maxProductKey and
              ProductKey &gt;= @minProductKey
            </Property>
            <Property Name=”RdbCommandType” Type=”System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″>Text</Property>
          </Properties>
          <FilterDescriptors>
            <FilterDescriptor Type=”Wildcard” Name=”ByName”>
              <Properties>
                <Property Name=”UsedForDisambiguation” Type=”System.Boolean”>true</Property>
              </Properties>
            </FilterDescriptor>
            <FilterDescriptor Type=”Wildcard” Name=”ByCode” />
            <FilterDescriptor Type=”Comparison” Name=”ByID” />
          </FilterDescriptors>
          <Parameters>
            <Parameter Direction=”In” Name=”@minProductKey”>
              <TypeDescriptor TypeName=”System.Int32″ IdentifierName=”ProductKey” AssociatedFilter=”ByID” Name=”minProductKey”>
                <DefaultValues>
                  <DefaultValue MethodInstanceName=”ProductFinderInstance” Type=”System.Int32″>0</DefaultValue>
                  <DefaultValue MethodInstanceName=”ProductSpecificFinderInstance” Type=”System.Int32″>0</DefaultValue>
                </DefaultValues>
              </TypeDescriptor>
            </Parameter>
            <Parameter Direction=”In” Name=”@maxProductKey”>
              <TypeDescriptor TypeName=”System.Int32″ IdentifierName=”ProductKey” AssociatedFilter=”ByID” Name=”maxProductKey”>
                <DefaultValues>
                  <DefaultValue MethodInstanceName=”ProductFinderInstance” Type=”System.Int32″>99999999</DefaultValue>
                  <DefaultValue MethodInstanceName=”ProductSpecificFinderInstance” Type=”System.Int32″>99999999</DefaultValue>
                </DefaultValues>
              </TypeDescriptor>
            </Parameter>
            <Parameter Direction=”In” Name=”@productName”>
              <TypeDescriptor TypeName=”System.String” AssociatedFilter=”ByName” Name=”ProductName”>
                <DefaultValues>
                  <DefaultValue MethodInstanceName=”ProductFinderInstance” Type=”System.String”>%</DefaultValue>
                  <DefaultValue MethodInstanceName=”ProductSpecificFinderInstance” Type=”System.String”>%</DefaultValue>
                </DefaultValues>
              </TypeDescriptor>
            </Parameter>
            <Parameter Direction=”In” Name=”@productCode”>
              <TypeDescriptor TypeName=”System.String” AssociatedFilter=”ByCode” Name=”ProductCode”>
                <DefaultValues>
                  <DefaultValue MethodInstanceName=”ProductFinderInstance” Type=”System.String”>%</DefaultValue>
                  <DefaultValue MethodInstanceName=”ProductSpecificFinderInstance” Type=”System.String”>%</DefaultValue>
                </DefaultValues>
              </TypeDescriptor>
            </Parameter>
            <Parameter Direction=”Return” Name=”Products”>
              <TypeDescriptor TypeName=”System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″ IsCollection=”true” Name=”ProductDataReader”>
                <TypeDescriptors>
                  <TypeDescriptor TypeName=”System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″ Name=”ProductDataRecord”>
                    <TypeDescriptors>
                      <TypeDescriptor TypeName=”System.Int32″ IdentifierName=”ProductKey” Name=”ProductKey”>
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID=”1041″>製品番号</LocalizedDisplayName>
                        </LocalizedDisplayNames>
                        <Properties>
                          <Property Name=”DisplayByDefault” Type=”System.Boolean”>false</Property>
                        </Properties>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName=”System.String” Name=”ProductCode”>
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID=”1041″>製品コード</LocalizedDisplayName>
                        </LocalizedDisplayNames>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName=”System.String” Name=”ProductName”>
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID=”1041″>製品名</LocalizedDisplayName>
                        </LocalizedDisplayNames>
                        <Properties>
                          <Property Name=”DisplayByDefault” Type=”System.Boolean”>true</Property>
                        </Properties>
                      </TypeDescriptor>
                    </TypeDescriptors>
                  </TypeDescriptor>
                </TypeDescriptors>
              </TypeDescriptor>
            </Parameter>
          </Parameters>
          <MethodInstances>
            <MethodInstance Type=”Finder” ReturnParameterName=”Products” Name=”ProductFinderInstance” />
            <MethodInstance Type=”SpecificFinder” ReturnParameterName=”Products” Name=”ProductSpecificFinderInstance” />
          </MethodInstances>
        </Method>
        <Method Name=”GetPartsForProduct”>
          <Properties>
            <Property Name=”RdbCommandText” Type=”System.String”>
              SELECT distinct p.*
              FROM
              Part p
              inner join product_part pp on p.PartKey = pp.PartKey
              inner join Product prod on pp.ProductKey = prod.ProductKey
              WHERE
              prod.ProductKey LIKE @ProductKey
            </Property>
            <Property Name=”RdbCommandType” Type=”System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″>Text</Property>
          </Properties>
          <Parameters>
            <Parameter Direction=”In” Name=”@productKey”>
              <TypeDescriptor TypeName=”System.Int32″ IdentifierName=”ProductKey” Name=”ProductKey” />
            </Parameter>
            <Parameter Direction=”Return” Name=”Parts”>
              <TypeDescriptor TypeName=”System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″ IsCollection=”true” Name=”PartDataReader”>
                <TypeDescriptors>
                  <TypeDescriptor TypeName=”System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″ Name=”PartDataRecord”>
                    <TypeDescriptors>
                      <TypeDescriptor TypeName=”System.Int32″ IdentifierEntityName=”Part” IdentifierName=”PartKey” Name=”PartKey”>
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID=”1041″>部品番号</LocalizedDisplayName>
                        </LocalizedDisplayNames>
                        <Properties>
                          <Property Name=”DisplayByDefault” Type=”System.Boolean”>false</Property>
                        </Properties>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName=”System.String” Name=”PartCode”>
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID=”1041″>部品コード</LocalizedDisplayName>
                        </LocalizedDisplayNames>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName=”System.String” Name=”PartName”>
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID=”1041″>部品名</LocalizedDisplayName>
                        </LocalizedDisplayNames>
                        <Properties>
                          <Property Name=”DisplayByDefault” Type=”System.Boolean”>true</Property>
                        </Properties>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName=”System.Int16″ Name=”ReorderPoint”>
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID=”1041″>再注文</LocalizedDisplayName>
                        </LocalizedDisplayNames>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName=”System.Int32″ Name=”Inventory”>
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID=”1041″>インベントリー</LocalizedDisplayName>
                        </LocalizedDisplayNames>
                      </TypeDescriptor>
                    </TypeDescriptors>
                  </TypeDescriptor>
                </TypeDescriptors>
              </TypeDescriptor>
            </Parameter>
          </Parameters>
        </Method>
      </Methods>
    </Entity>
  </Entities>
  <Associations>
    <Association AssociationMethodEntityName=”Product” AssociationMethodName=”GetPartsForProduct” AssociationMethodReturnParameterName=”Parts” Name=”ProductsToParts” IsCached=”true”>
      <SourceEntity Name=”Product” />
      <DestinationEntity Name=”Part” />
    </Association>
  </Associations>
</LobSystem>


=========================================================================


 

AdventureWorksDW_Sample.xml

Advertisements

One thought on “ビジネスデータカタログ (Business Data Catalog) のサンプル 【RTM 日本語版】

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s