Show TOC

Performing Real-Time Indexing for DataSource-Based ConnectorsLocate this document in the navigation structure


If you use SAP HANA or SAP BW Accelerator, real-time indexing means that data is available for close to real-time analysis. Real-time indexing for DataSource-based connectors can be performed both for DataSources for which the application writes the delta directly to the delta queue (push) and for DataSources for which the delta is only written to the delta queue when requested (pull).


The DataSource must support real time.


Start Real-Time Indexing

If you want to use real-time indexing for a DataSource-based connector, proceed as follows:

  1. Select the connector in the Administration Cockpit and choose Start of the navigation path Actions Next navigation step Schedule Indexing End of the navigation path.

  2. To start real-time indexing, select the Start Immediately and Indexing in Real Time checkboxes and press OK.

    More information about scheduling real-time indexing: Starting Indexing of Connectors


  1. Once real-time indexing has been set, a daemon process is scheduled in the delta queue (known as the ODQ daemon). If the daemon process is already scheduled, it adds the subscriptions in question to the process. A request is opened for the subscription. This request will stay open for at least 24 hours.

    In the Delta Queue Monitor, the subscription and the request are displayed with the RT (object is in real-time mode) flag.

  2. The ODQ daemon is a periodic background job that has the following tasks:

    • Extraction

      The job checks whether a subscription running in real-time mode requires a pull, meaning that extraction has to be performed. If this is the case, the job writes the data to the delta queue. This is done using selection via a delta-specifying field, normally a time stamp.

    • Notification

      The job checks for changes in the subscriber's queue and notifies the subscriber if any are found.


      Notifications are only sent if the subscriber type requires this, for example, subscriber type Search and Analysis.

    In the default setting, the job is scheduled with a period of 15 minutes and a takt cycle of 15 seconds. This means that the background job is completed and a new one started every 15 minutes. The job checks in 15 second cycles whether extractions need to be performed and notifications sent to subscribers.

  3. With the notification, the ODQ daemon starts the indexing job - if not started already - or makes the indexing job restart if previously interrupted.

    More information about the indexing job: Controlling Real-Time Indexing

  4. The indexing jobs reads the data from the delta queue and writes it to the SAP HANA database or to the BWA.

Monitor Real-Time Indexing

Monitor the ODQ Dämon and Requests in Real-Time Mode

In the Delta Queue Monitor (transaction ODQMON) you can monitor the ODQ daemon and requests in real-time mode:

  • To monitor requests, restrict the information displayed in the monitor to Only Real Time in the Request Selection field:

    • Requests that are currently being processed by the daemon process are displayed with status Extraction running.

    • Requests that are not being processed by the daemon process any more and are now closed are displayed with status Confirmed and are included in the delta queue reorganisation.

  • To monitor the ODQ daemon, choose Start of the navigation path Goto Next navigation step Real Time Daemon End of the navigation path in the monitor.

    More information: Monitoring and Scheduling Daemon Processes for Real-Time Processing

Monitor Indexing Job

In the Administration Cockpit, the Last Indexing column in the connector overview shows you when data was last written to the SAP HANA database or to BWA. By choosing Start of the navigation path System Settings Next navigation step Manage Indexing in Real Time End of the navigation path, you can monitor the indexing job.

More information: Controlling Real-Time Indexing

Stop Real-Time Indexing

To stop real-time indexing, proceed as follows:

  1. Select the connector in the Administration Cockpit and choose Start of the navigation path Actions Next navigation step Schedule Indexing End of the navigation path.

  2. To stop real-time indexing, deselect the Indexing in Real Time checkbox, select the Start Immediately checkbox and press OK.