Feature Pack 8

Configuring and running the Data Extract utility

You can configure and run the Data Extract utility from a command-line utility to extract data for a store from the WebSphere Commerce database into an output CSV or XML file. You can then use the Data Load utility to load the generated file into stores in other environments, such as for copying data into multiple stores or setting up multiple test environments.

Note: The following procedure and topics configure the utility to use an SQL-based extraction process for extracting data. If you want to extract catalog data for use with IBM Product Recommendations, you must use a business logic-based extraction process. For more information about configuring the utility to extract data for use with IBM Product Recommendations, see Data extraction utility for dynamic recommendations in IBM Product Recommendations.

Before you begin

About this task

To run the Data Extract utility, you need to configure the utility to identify your environment settings and identify the data to extract. Sample configuration files are provided for you to edit and use to quickly configure the utility to extract the following types of objects:
  • Promotions
  • Feature Pack 8Commerce Composer objects, such as widgets, layouts, layout templates, and pages
    Note: You must apply the interim fixes for APAR JR53438.fep and APAR JR53438.fp to add the support for extracting these objects to your WebSphere Commerce instance.
  • Feature Pack 8Marketing objects, such as activities. e-Marketing Spots, content, campaigns, attachments, and customer segments
    Note: You must apply the interim fixes for APAR JR53438.fep and APAR JR53438.fp to add the support for extracting these objects to your WebSphere Commerce instance.
These sample files are in the following directory and subdirectories:
  • SolarisLinuxAIXWC_installdir/components/foundation/samples/DataExtract
  • WindowsWC_installdir\components\foundation\samples\DataExtract
  • WebSphere Commerce DeveloperWCDE_installdir\components\foundation\samples\DataExtract
Note: The Data Extract utility extracts data for only a single store in single extract operation. You can specify the store identifier in the environment configuration file.

Procedure