Configure the business object configuration file

The business object configuration file defines how to load the data into the database. In this file, you specify the implementation classes for our Data Reader, Business Object Builder, and Business Object Mediator components. You also specify the attributes and properties for these components.

About this task

Sample business object configuration files are provided for different component objects within the component-specific directories in the following directory:

• (Linux) utilities_root/samples/DataLoad

• (Developer) WCDE_installdir/samples/DataLoad

Procedure

1. Create a copy of a sample wc-loader-object.xml file and rename the file. For example, copy the wc-loader-catalog.xml file within the Catalog component directory.

2. Open the new business object configuration file for editing.

3. Specify your data reader implementation class.

   1. Find the <_config:DataReader> element.

   2. Set the className attribute value. The value of this attribute specifies the class name for the data reader. We can specify the provided class,

      • CSVReader

      • XmlReader

      However, if you customize the data reader, we can specify your implementation class. For more information about configuring the data reader, see:

      • Configure the CSV data reader

      • Configure the XML data reader

      For example, the following snippet configures the data reader:

      <_config:DataLoader 
        className="com.ibm.commerce.foundation.dataload.BusinessObjectLoader" >
        <_config:DataReader 
          className="com.ibm.commerce.foundation.dataload.datareader.CSVReader" 
          firstLineIsHeader="true" useHeaderAsColumnName="true" >
      </_config:DataReader>

4. Specify your business object builder class.

   1. Find the <_config:BusinessObjectBuilder> element.

   2. Set the className attribute value. The value of this attribute specifies the class name for the business object builder. The two implementation classes provided are:

      • BaseBusinessObjectBuilder for component-based business objects

      • TableObjectBuilder for table-based objects

      For more information about configuring these business object builders, see

      • Configure the component business object builder

      • Configure the table object builder

5. Optional: Configure the Data Load utility to exclude any columns that you do not want the utility to load data into or change. To exclude columns, we can define a column exclusion list within the <_config:DataLoader> element. See Configure a column exclusion list.

6. Save and close the file. As an example, the following snippet configures the business object configuration file for loading attribute dictionary attribute allowed value data:

   <?xml version="1.0" encoding="UTF-8"?>
   <_config:DataloadBusinessObjectConfiguration 
   	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   	xsi:schemaLocation="http://www.ibm.com/xmlns/prod/commerce/foundation/config ../../../../
          xml/config/xsd/wc-dataload-businessobject.xsd" 
   	xmlns:_config="http://www.ibm.com/xmlns/prod/commerce/foundation/config">
    
     <_config:DataLoader className="com.ibm.commerce.foundation.dataload.BusinessObjectLoader" >
       <_config:DataReader className="com.ibm.commerce.foundation.dataload.datareader.CSVReader"
         firstLineIsHeader="true" useHeaderAsColumnName="true" >
       <_config:property name="keyColumns" value="Identifier,ValueIdentifier" />
       </_config:DataReader>
       <_config:BusinessObjectBuilder 
         className="com.ibm.commerce.foundation.dataload.businessobjectbuilder.BaseBusinessObjectBuilder" 
         packageName="com.ibm.commerce.catalog.facade.datatypes.CatalogPackage" 
         dataObjectType="AttributeDictionaryAttributeType" >
         <_config:DataMapping>
         <_config:mapping xpath="AttributeIdentifier/ExternalIdentifier/Identifier" 
           value="Identifier" />
         <_config:mapping xpath="AttributeIdentifier/UniqueID" value="AttributeUniqueId" />
         <_config:mapping xpath="AllowedValue/identifier" value="ValueIdentifier" />
         <_config:mapping xpath="AllowedValue/displaySequence" value="Sequence" />
         <_config:mapping xpath="AllowedValue/Value" value="Value" />
         <_config:mapping xpath="AllowedValue/ExtendedValue/ValueUsage" value="1" 
           valueFrom="Fixed" />
         <_config:mapping xpath="AllowedValue/ExtendedValue/AttributeValueField1" 
           value="AttributeValueField1" />
         <_config:mapping xpath="AllowedValue/ExtendedValue/AttributeValueField2" 
           value="AttributeValueField2" />
         <_config:mapping xpath="AllowedValue/ExtendedValue/AttributeValueField3" 
           value="AttributeValueField3" />
         <_config:mapping xpath="AllowedValue/ExtendedValue/Image1" value="Image1" />
         <_config:mapping xpath="AllowedValue/ExtendedValue/Image2" value="Image2" />
         <_config:mapping xpath="AllowedValue/ExtendedValue/Field1" value="Field1" />
         <_config:mapping xpath="AllowedValue/ExtendedValue/Field2" value="Field2" />
         <_config:mapping xpath="AllowedValue/ExtendedValue/Field3" value="Field3" />
         <_config:mapping xpath="AllowedValue/language" value="Language" />
         <_config:mapping xpath="AllowedValue/language" value="LanguageId" />
         <_config:mapping xpath="" value="Delete" deleteValue="1" />
         </_config:DataMapping>
         <_config:BusinessObjectMediator 
           className="com.ibm.commerce.catalog.dataload.mediator.AttributeDictionaryAttributeMediator" 
           componentId="com.ibm.commerce.catalog" >
           <_config:property name="allowChangeAttributeType" value="true" />
           <_config:property name="validateAttribute" value="true" />
         </_config:BusinessObjectMediator>
       </_config:BusinessObjectBuilder>
     </_config:DataLoader>
   </_config:DataloadBusinessObjectConfiguration>

Previous topic: Configure the data load environment settings
Next topic: Configure the data load order