EventTableType

In event-table mode, applications add rows to an event table. On each synchronize cycle, the connector runs a query (specified by the SQL parameter) to extract documents from the table, processes the documents that are returned, and then deletes the rows that it has processed.

This parameter specifies the type of operation to perform on each returned document:

  • add - add a new document to the index.
  • update - update an existing document. This option supports both metadata and content changes. If the content has changed the connector performs an ingest-replace.
  • remove - delete an existing document.

To perform all of these operations, set up a separate fetch task for each operation.

Type: String
Default: add
Required: No
Configuration Section: TaskName or FetchTasks
Example: EventTableType=remove
See Also:

SQL

DeleteEventSQL