Loading extension tables

Use the data load utility to load UserData into custom extension tables in your database. There are two ways to load data into custom extension tables:

  • Map the extension table data to the logic noun UserData fields. If you need to extend the logic noun in your tool or you need to generate custom SDO extensions, use this method.
  • Use the TableObjectBuilder and TableObjectMediator to load data directly into the custom extension table. If you did not customize your tool or you did not generate custom SDO extensions, use this method.

The following procedure shows you how to load data into custom extension table using the first method.

Procedure

  1. Run the Data Service Layer wizard in your development environment.
  2. Package the generated physical SDOs into a JAR file and deploy it to the utilities_root/ext/lib directory of your runtime environment.
  3. Deploy the extension configuration directory generated by the Data Service Layer wizard into the utilities_root/instances/instance_name/xml/config directory of your runtime environment. The generated extension configuration directory is located in the workspace_dir/WC/xml/config directory.
  4. In your runtime environment, open the business object configuration file for the associated business objects you want to load.
  5. Add the appropriate mappings inside the <_config:DataMapping> element. For example, the following snippet shows the customization of the CatalogEntry noun to support warranty information: 
    <_cat:CatalogEntry catalogEntryTypeCode="ProductBean">
      <_cat:CatalogEntryIdentifier>
        <_wcf:UniqueID>10251</_wcf:UniqueID>
        <_wcf:ExternalIdentifier ownerID="7000000000000000101">
        <_wcf:PartNumber>FULO-01</_wcf:PartNumber>
        </_wcf:ExternalIdentifier>
      </_cat:CatalogEntryIdentifier>
      <_cat:Description language="-1">
        <_cat:Attributes name="careinstruction">Warranty care instructions.</_cat:Attributes>
      </_cat:Description>
      <_wcf:UserData>
        <_wcf:UserDataField name="warterm">30</_wcf:UserDataField>
        <_wcf:UserDataField name="wartype">LIMITED</_wcf:UserDataField>
      </_wcf:UserData>
</_cat:CatalogEntry>

    The catalog entry mediator supports loading custom catalog entry UserData using the catalog entry mediator. You do not need to create a custom mediator to support UserData.

    Add the following code in the business object configuration file to map the warranty user data:

    <_config:mapping xpath="UserData/UserDataField/warterm" value="WarrantyTerm" />
<_config:mapping xpath="UserData/UserDataField/wartype" value="WarrantyType" />
<_config:mapping xpath="Description/Attributes/careinstruction" value="CareInstruction"  />
  6. Save and close the file.
  7. Run the Data Load utility.