Extracting data

To extract data from a database using the massextract utility, 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.

To extract data:

  1. If the loading utilities has not yet been configured, configure the loading utilities.

  2. Configure the massextract utility.

  3. Create an extraction filter. For more information see example of an extraction filter.

  4. 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"
/>

Related concepts

 

Related Tasks

Related reference