Native Indexing Strategy

Using the Native indexing strategy Sana retrieves product and customer changes from the SAP database view. You can create a view in your SAP database to store product and customer changes there. You can use this approach for any SAP database supported by Sana. In this manual Microsoft SQL database is used as an example.

The Native indexing strategy uses a database cursor with Native SQL. It uses a direct database call producing a significant performance improvement. Native SQL allows you to use database-specific SQL statements in an ABAP program. This means that you can use database tables that are not administered by ABAP dictionary, and therefore integrate data that is not a part of the SAP system.

To use the Native indexing strategy, you must follow the steps below.

Create a Database View for CDHDR Table

Step 1: Log in to your SAP database and check if you have permissions to create a view.

Step 2: Select your database and create a query for it. You must create a view in your SAP database with the same fields as in your CDHDR SAP table.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
create view [dev].[cdhdr_vw1] as
SELECT [MANDANT]
   ,[OBJECTCLAS]
   ,[OBJECTID]
   ,[CHANGENR]
   ,[USERNAME]
   ,[UDATE]
   ,[UTIME]
   ,[TCODE]
   ,[PLANCHNGNR]
   ,[ACT_CHNGNO]
   ,[WAS_PLANND]
   ,[CHANGE_IND]
   ,[LANGU]
   ,[VERSION]
  FROM [dev].[CDHDR];

Step 3: Check if the database view has been created and populated with data.

Enable Native Indexing in SAP

Step 1: In SAP open the Webstore Optimization window either from the main window of the Sana Commerce solution (/n/sanaecom/webstore), or by calling the transaction /n/sanaecom/optimize.

Step 2: Select the Native indexing strategy and enter the name of the database view you created.