Steps to Enable Real-Time Indexing for a Search Definition

To ensure that the real-time indexing process runs smoothly, PeopleSoft suggests the following sequence of steps.

  1. On the Configure Real Time Indexing page,

    1. Select the Enable Real Time Indexing check box.

    2. Verify that the metadata is populated correctly and ensure that you specify the required trigger records.

    3. Save the real-time indexing configuration.

    4. Create the trigger.

  2. Run incremental index for the search index for data synchronization. Perform this step to index records that were added before real-time indexing was initialized.

The selected search definition is now configured for real-time indexing. When data is inserted, modified, or deleted in the database for the search index, a SQL trigger runs to initiate real-time indexing of data in the search engine.

Alternatively, you can enable or disable Real-Time Indexing (RTI) and manage SQL trigger script execution using Application Configuration Management (ACM) RTI plug-in. For more information and detailed configuration steps, refer to the section Automated Configuration Management: Configuring Properties for RTI.

Note:

Search definitions with queries using set operators like UNION, INTERSECTION etc. are not supported for real-time indexing. Real-time indexing requires equivalent queries without set operators.