Using the Loader package utilities

This diagram illustrates the various steps involved in loading and extracting data. This diagram involves:

  1. Transforming data
  2. Loading data
  3. Extracting data

Transforming data

Using the data transformation process, you can transform a CSV file to a WebSphere Commerce XML data file. This involves:

  1. The TextTranformation process transforms the CSV data file to a generic XML file using the TextTransformer utility. A parameter file is used as an input. This parameter file contains the path and file name of the schema file and the output file. The transformation rule is defined in the XMLSchema file. The output of the TextTranformation process will be a generic XML file.
  2. The XMLTranformation process transforms the generic XML to a WebSphere Commerce XML data file using the XMLTransformer utility. This utility uses the XSL rule, the output file name, and the generic XML file generated inthe previous step as input. The XSL rule is applied on the generic XML for transformation. The output will be the WebSphere Commerce XML file that is required for the loading process.

Loading data

The basic loading process comprises, resolving keys and loading data. This involves:

  1. The loader utilities require the WebSphere Commerce .dtd file. If the .dtd file is available, then go to the next step. Otherwise, use the DTDGenerator utility to generate a .dtd file. The DTDGenerator uses a text file that contains the table names for which the description is required and the output .dtd file name. The result will be a .dtd file containing the description of the database tables.
  2. The WebSphere Commerce XML data file (generated when transforming data) needs to be resolved for unique keys. This requires the ID Resolver utility, which uses the .dtd file, the output file name, and the generated WebSphere commerce XML to produce the output XML data file with resolved identifiers.
  3. The data from the resolved XML data file generated in the previous step is loaded into the WebSphere Commerce database using the Massloader utility. This utility uses the resolved XML file as the input and loads the data into the WebSphere commerce database.

Extracting data

The extraction process is used to extract data from the WebSphere Commerce database. This involves:

  1. An extraction filter that contains the SQL to extract data must to be hard coded.
  2. The Massextract utility is used to the extract the data from the WebSphere Commerce database. This utility uses the output file name and the extraction filter defined in the previous step as inputs. The output will be a generic WebSphere Commerce XML data file.

Feedback