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. You can extract data into an CSV or XML output file. You can then use the Data Load utility to load the ouput file into stores in other environments, such as for copying data into multiple stores or setting up multiple test environments.

Before you begin

Ensure that you review and follow the Data Extract utility best practices.

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
  • Commerce Composer objects, such as widgets, layouts, layout templates, and pages
  • Marketing objects, such as activities. e-Marketing Spots, content, campaigns, attachments, and customer segments
These files are in the following directory and subdirectories:
  • AIXLinuxWC_installdir/samples/DataExtract
  • WindowsWC_installdir\samples\DataExtract
  • WebSphere Commerce DeveloperWCDE_installdir\samples\DataExtract
Notes:
  • The sample files for extracting marketing, promotions, and Commerce Composer objects configure the utility to use an SQL-based extraction process.
  • The DataExtract directory also includes sample files for extracting catalog and configuration data for use with . These files cannot be used when you configure the utility to use an SQL-based extraction process. If you want to extract data for use with , you must use a business logic-based extraction process. For more information, see Data extraction utility for dynamic recommendations in.
  • The Data Extract utility extracts data for only a single store during an extract operation. You can specify the identifier for the store to extract data from when you configure the environment configuration file.

Procedure