Understanding Real Time Indexing in ELM

Real Time Indexing (RTI) uses DirectTransfer methods to transmit search indexing data directly from PeopleSoft batch servers to Elasticsearch. It is performed in near real-time by indexing the data as soon as it is saved.

For additional information about DirectTransfer, see PeopleSoft PeopleTools, Search Technology, "Administering PeopleSoft Search Framework and Using Direct Transfer".

PeopleSoft delivers search definitions that you can implement for RTI.

RTI can be used on these Search Definitions as long as the minimum tools release is in effect.

Warning! Oracle recommends that you do not implement RTI for any other search definition in the PeopleSoft application at this time. The PeopleSoft system does not support RTI for any other search definition other than those listed in this table.

Search Definition

Minimum PeopleTools Release

ELM Update Image

LM_ACT_ENRLMNTS

8.59.13

N/A

LM_DR_LEARNING

8.59.13

N/A

LM_DR_RGSTNS

8.59.13

N/A

LM_PRG_RGSTNS

8.59.13

N/A

LS_LM_ACT_CI_FL

8.59.13

Image 23

LS_LM_OBJV

8.59.13

N/A

LS_LM_PRG_FL

8.59.13

Image 23

To build Real Time Indexes:

  1. Perform a full index build of the indexes that you will use.

    This allows a baseline index for RTI to add records.

  2. Enable RTI on the search definition using the Configure Real Time Indexing page (PeopleTools > Search Framework > Real Time Indexing > Configure Real Time Indexing).

    1. Enter the search definition (from the list above) in the filter box.

    2. Select the Enable check box and save.

  3. Download the trigger sql for your database environment using the Trigger SQL link.

    MSS, DB2 z/OS, and Oracle are supported.

    Note: When you click the link, trigger SQL is generated for each supported database platform. Based on the browser you use, you may receive a prompt to Save the file or Cancel. Click Cancel if the prompt is for a Database platform that is different from what you use, and the next database platform’s SQL is generated.

  4. Provide the trigger to your database administrator to apply to the database.

For additional information about configuring Real Time Indexing, see PeopleTools, Development Tools, Search Technology, "Administering PeopleSoft Search Framework", Using Real Time Indexing.