Developer Guide

Back Next

Data Integration Hub Events View

Use your SQL client to view

Data Integration Hub

events in the

Data Integration Hub

repository.

In your SQL client, the events view resides under the

Data Integration Hub

database, in

DX_VIEW_PUB_SUB_EVENT

The view contains the following columns:

EVENT_ID: ID of the event.
EVENT_TYPE: Type of event, such as publication, subscription, file, and system events.
PUBLICATION_SUBSCRIPTION_NAME: Name of the publication or of the subscription that generated the event.
APPLICATION_NAME: Name of the application that is associated with the publication or of the subscription that generated the event.
TOPIC_NAME: Name of the topic that is associated with the publication or of the subscription that generated the event.
EVENT_STATUS: Status of the event, such as error, complete, and pending events.
EVENT_START_TIME: Date and time when the event started.
EVENT_END_TIME: Date and time when the event ended.
EVENT_DURATION: Duration of the event.
Data Integration Hub
calculates the duration based on
EVENT_START_TIME
and
EVENT_END_TIME
.
SOURCE_SUCCESS_ROWS: Number of rows that
Data Integration Hub
read successfully from the source.
SOURCE_FAILED_ROWS: Number of rows that
Data Integration Hub
failed to read from the source.
TARGET_SUCCESS_ROWS: Number rows that
Data Integration Hub
read successfully from the target.
TARGET_FAILED_ROWS: Number of rows that
Data Integration Hub
failed to read from the target.