This section describes how dotConnect for Adobe Commerce selects data.

• Retrieving Data
  

  This topic shows a simple example of getting Adobe Commerce data with dotConnect for Adobe Commerce.

• Select Statement Execution
  

  This topic explains how dotConnect for Adobe Commerce selects data.

• SQL Translation
  

  This topics contains the requirements to a SQL Statement, that can be translated to API calls.

• Temporary Cache
  

  This topics describes how dotConnect for Adobe Commerce uses temporary cache when a SELECT statement is executed locally.