Running the Extraction tool in the Pre-Extract Mode for Integrated Setups

After you configure the extraction tool files, you can run the extraction tool in the pre-extract mode.

For information about running the tool in the pre-extract mode, see Running the Extraction tool.

Files generated

When you run the extraction tool in the pre-extract mode to extract data for applications in integrated setups, the following files are generated in the output directory of the extraction tool:
Table 1. Files generated
Product name Files generated
Emptoris® Sourcing esp_additional_supplier_business_types.xlsx
Emptoris Contract Management
  • ecm_naics_sic_code.xlsx
  • ecm_additional_phone_types.xlsx
  • ecm_additional_address_types.xlsx
All products
  • RegionMapping.xlsx
  • currency_codes.xlsx
  • data_assessment_log.xlsx
Note: After the files are generated, if you re-run the extraction tool in the pre-extract mode again, the generated files are overwritten. If required, take a backup of the previously generated files before you re-run the tool in the pre-extract mode.

Tasks for formatting data

After you run the extraction tool in the pre-extract mode, you must perform the following tasks:
Table 2. Tasks for pre-extract mode
Task Information is available here
Modify the supplier business types in Emptoris Sourcing by mapping them to the format required for the Emptoris Strategic Supply Management Platform. Business Types for Emptoris Sourcing
Map NAISC and SIC codes in Emptoris Contract Management. NAISC and SIC Codes for Emptoris Contract Management
Note the additional phone types in Emptoris Contract Management. Phone Types for Emptoris Contract Management
Note the additional address types in Emptoris Contract Management. Address Types for Emptoris Contract Management
Map countries and states in integrated setups. Map Countries and States for Emptoris Sourcing
Remove all errors from the data and prepare the data for extraction. Data Assessment for Emptoris Sourcing
You can skip the steps that are not applicable for your setup.