Introduced in Feature Pack 2

Preprocessing the search index data

Introduced in Feature Pack 2 In this lesson, the search index data is preprocessed to prepare your WebSphere Commerce data for indexing. The preprocess utility extracts and flattens WebSphere Commerce data and then outputs the data into a set of temporary tables inside the WebSphere Commerce database. The data in the temporary tables is then used by the index building utility in the next lesson to populate the data into Solr indexes using Solr's Data Import Handler (DIH).

About this task

Procedure

  1. WebSphere Commerce DeveloperStop the WebSphere Commerce server.
  2. Navigate to the following directory:
    • WC_installdir/bin
    • WebSphere Commerce DeveloperWCDE_installdir\bin
  3. Run the preprocessing utility:
    • SolarisLinuxAIXdi-preprocess.sh WC_installdir/instances/instance_name/search/pre-processConfig/MC_masterCatalogId/target_db
    • Windowsdi-preprocess.bat WC_installdir/instances/instance_name/search/pre-processConfig/MC_masterCatalogId/target_db
    • WebSphere Commerce Developerdi-preprocess.bat WCDE_installdir\search\pre-processConfig\MC_masterCatalogId\development_db
  4. Query the TI_RATING table to confirm that the ratings are populated.

Results