Overview of loading store data
After you create your 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 by using the WebSphere Commerce mass load utilities. The mass load utilities provide six command-line utilities that you can use to prepare data for loading as well as to load data into your store. These utilities use Extensible Markup Language (XML) data files to manage the information.
The massload utility
is deprecated for WebSphere Commerce Version 7 Feature Pack 6. The
Data Load utility is the recommended command-line loading utility.
If you are currently using the mass load utility, you are recommended
to switch to the Data Load utility to load your CSV and XML input
files into your target database. If your system contains scheduled
and automated processes that use massload, it is recommended that
you update these processes to use the Data Load utility. Other WebSphere
Commerce utilities that use the massload utility, such as the acpload
utility, continue to use the massload utility in WebSphere Commerce
Version 7 Feature Pack 6. If you have business reasons to continue
using the massload utility, you can continue to use this utility.
For more information about the Data Load utility, see Overview of the Data Load utility.
You can switch to the Data Load utility by using the TableObjectMediator to
load your data when no business object mediator exists for the data
that you are loading. For more about the TableObjectMediator formation,
see Data Load utility table-based mediator and builder.
The data preparation, loading, and extraction processes that you can perform by 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 before data is loaded into a database. For information about the idresgen utility, see:
- massload utility This utility loads an XML input file into a target database. For information about this utility, see:
You can use the following loading utilities command-line utilities to manage your data:
- dtdgen utility This utility creates document type definition (DTD) and schema files for use with the loading utilities. For more information, see the following topics:
- massextract utility This utility extracts a selected subset of data from a database in the form of an XML file. For more information, see the following topics:
- txttransform utilityThis utility transforms data between a character-delimited variable format and an XML format. For more information, see the following topics:
- xmltransform utility This utility converts an XML file into an alternative application-specific XML format. For more information, see the following topics: