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