Administer > Transforming, loading, and extracting data > Overview of the mass load utilities
Extract data
To extract data from a database using the massextract utility, specify the data that to extract from the database using an extraction-filter file. The extraction filter that you use depends on the type of data that to extract.
Before you begin
Configure loading utilities
Procedure
- Create an extraction filter. For more information see example of an extraction filter.
- Run the massextract utility. Specify the name of the properties file created in step 1 as the value of the customizer parameter of the massextract utility.
The data extracted from the database is in an XML file. The XML file contains a DTD that defines the data in the file and includes the data extracted.Each database table row is extracted into its own XML tag. Each element of the tag contains the column values for the row. The following example tag is an extracted row from the CATGRPDESC database table:
<catgrpdesc language_id="-1" catgroup_id="51201059000" name="Fancy" shortdescription="short description for Fancy" longdescription="long description for Fancy" published="1" />
- Create 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 running the massextract utility.
- Extraction filter format
An extraction filter is an XML file that defines the data you want to extract from the WebSphere Commerce database.
- Example: Extraction filter
The following example of an extraction filter extracts category and product information from the CATGROUP, CATGRPDESC, CATGRPREL, CATENTRY, CATENTSHIP, OFFER, CATENTREL, CATGPENREL, CATENTDESC, and ATTRVALUE tables.
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
Related reference