Home
User Guide
The information contained in this section applies to IBM WebSphere Commerce Version 7.0.0.9 and Feautre Pack 8. The documentation also applies to all subsequent releases and modifications until otherwise indicated in new editions.
Administering
Transforming, loading, and extracting data
WebSphere Commerce provides multiple utilities for preparing and loading data into a WebSphere Commerce database. The loading utilities are flexible and you can continue to use these utilities when you customize the WebSphere Commerce schema.
Mass load utilities
The mass load utilities provide an efficient way to load large amount of data. However, the new enhanced business object based loading utility (the Data Load utility) is the recommended loading utility.
Extracting data
To extract data from a database using the massextract utility, you must specify the data that you want to extract from the database using an extraction-filter file. The extraction filter that you use depends on the type of data that you want to extract.
Creating an extraction filter
An extraction filter is an XML file that defines the data you want to extract from the WebSphere Commerce database. You must create an extraction filter before you run the massextract utility.

Creating an extraction filter

An extraction filter is an XML file that defines the data you want to extract from the WebSphere Commerce database. You must create an extraction filter before you run the massextract utility.

Procedure

Develop SQL queries for the data you want to extract from the WebSphere Commerce database.
Create an XML file to contain the SQL queries that follows the extraction filter format. Refer to Extraction filter format for more information.