Utilities in database tier for WebSphere Commerce | How massload works
16.4.1 Massload
Overview
The WebSphere Commerce Loader package consists primarily of command utilities for preparing and loading data into a WebSphere Commerce database. You can use the Loader package to load large amounts of data and to update data in your WebSphere Commerce database.
The Loader command utility in this package uses valid and well-formed XML as input to load data into the database. Elements of the XML document map to table names in the database, and element attributes map to columns.
The Loader command utilities allow you to do the following:
- Transform data between a character-delimited variable format and an XML data format.
- Transform XML data into alternate XML formats.
- Generate a DTD based on the target database.
- Generate identifiers for XML elements.
- Load data into the WebSphere Commerce database.
- Extract data from a database as an XML document.
Loader package utilities
Utility Description Text Transformer The Text Transformer transforms data between a character-delimited variable format and an XML data format. XML Transformer The XML Transformer changes, aggregates, and remaps the data in an XML document to alternate XML formats for use by other users or systems as needed. DTD Generator The DTD Generator generates a DTD based on the target database to which your data must conform. This DTD will be used throughout the load process. ID Resolver The ID Resolver is a Loader package command utility that generates identifiers for XML elements with their associated identifiers. Loader The Loader is responsible for populating and updating the WebSphere Commerce database. The Loader is the most common means of loading data into a system. Extractor The Extractor extracts selected subsets of data from a database in the form of XML files. Logger The Loader package command utilities log messages to indicate success, failure, and errors, as well as to provide program trace information.