Understanding the Indexing (Extract-Transform-Load) Process

Objective

After completing this lesson, you will be able to configure and perform the Extract-Transform-Load process to import type-system data into the Solr Engine​.

Indexing: What and How

The Solr-based search approach is implemented in SAP Commerce Cloud's Search & Navigation module. Before using the Solr search engine to query data, it is essential to configure the data intended for search operations.

This involves the indexing process, commonly called the extract, transform, and load (ELT) process, which prepares the data for searching. But what precisely does this involve, and how is it implemented and configured in SAP Commerce Cloud? Let’s explore.

The critical indexing process within the Search & Navigation module was explored, which prepares the essential data for searching. Each phase of the ETL process was explained, detailing its implementation and application in the context of SAP Commerce Cloud. Key highlights include:

  • Extract: Retrieves data from the underlying database.
  • Transform: Modifies and standardizes the extracted data into a format that the search engine understands.
  • Load: Imports data and extra data processors into the search engine.

Also, how to configure and customize each step to meet specific business needs was covered.​

Log in to track your progress & complete quizzes