Administer > Transforming, loading, and extracting data > Overview of the mass load utilities

Overview of loading store data

After creating the store data, you can choose to package it as a store archive and publish it using Publish wizard or the PublishStore utility. If you do not package the store as a SAR file you can load data assets directly into the WebSphere Commerce Server database using the WebSphere Commerce loading utilities. The loading utilities provides six command-line utilities that you can use to prepare data for loading as well as to load data into the store. These utilities use Extensible Markup Language (XML) data files to manage the information.

The data preparation, loading, and extraction processes that you can perform using the loading utilities are shown in the following figure.

The two processes that are most commonly used to load store data into a WebSphere Commerce Server database are resolving identifiers and loading the data.

• idresgen utility

  This utility generates identifiers for XML elements that require them prior to loading into a database. For information about the idresgen utility, refer to:

  • idresgen utility

  • Resolve identifiers

• massload utility

  This utility loads an XML input file into a target database. For information about this utility, refer to:

  • massload utility

  • Load data

Use the following loading utilities command-line utilities to manage the data:

• dtdgen utility

  This utility creates document type definition (DTD) and schema files for use with the loading utilities. For more information refer to:

  • dtdgen utility

  • Generate a DTD

  • Example of wc.dtd output for the DTD Generate utility

  • Map loading utilities data to a database schema

• massextract utility

  This utility extracts a selected subset of data from a database in the form of an XML file. For more information refer to:

  • massextract utility

  • Extract data

• txttransform utility

  This utility transforms data between a character-delimited variable format and an XML format. For more information refer to:

  • txttransfrom utility

  • Transforming character-delimited variable text to XML

• xmltransform utility

  This utility converts an XML file into an alternative application-specific XML format. For more information refer to:

  • xmltransform utility

  • Transforming XML data

Related concepts

Overview of the mass load utilities

Transforming, loading, and extracting data using the WebSphere Commerce loading utilities

Related tasks

Configure the environment variable setting scripts

+

Search Tips   |   Advanced Search