Understanding Real Time Indexing in Enterprise Components

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

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

PeopleSoft delivers search definitions that you can implement for RTI. PeopleSoft Enterprise Components plans to deliver more search definitions for RTI in the future.

RTI can be used on search definitions listed in this table when the minimum tools release is in effect for the respective application update image.

Warning! PeopleSoft recommends that you do not implement RTI for other delivered search definitions. PeopleSoft Enterprise Components does not certify RTI for search definitions other than those listed in this table.

Search Definition

Minimum PeopleTools Release

Application Update Image

EP_EOCC_TRK_ANALYTICS_INSIGHT

8.62

HCM Image 53

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. On the search page that appears, enter the search definition (from the list above) in the Index Name field and select Search. Select the correct row from the search results.

    2. On the next page where the selected search definition is displayed, select the Enable Real Time Indexing check box.

  3. Save the page.

  4. 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.

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

    Warning! Any time a change is made to the RTI configuration using the Configure Real Time Indexing page, or using PeopleCode in the application class, and whether or not a new trigger is generated and applied, the process scheduler must be restarted. If you do not restart the process scheduler, real time indexing may not pick up the changes and could fail to index your data.

For additional information about configuring Real Time Indexing, see PeopleTools: Search Technology, "Administering Real Time Indexing."