Audit Tables
The auditing tables are located in the audit schema.
The following table describes the reporting database tables and their descriptions.
| Table | Description |
|---|---|
| ExecutionLog | Describes the top level of auditing that all records update. The status is either running, failed, or succeeded. The reporting version is also listed in the execution log. |
| PackageExecutionLog | Records each package executed. The status is running, failed, succeeded, or rolled back. |
| DataflowExecutionLog | Records each source table to destination/reporting table transformation. |
| ExecutionErrors | Includes detailed information on how many rows are fetched, deleted, updated, and inserted. |
Reports can be created based on these auditing tables to show the data synchronization statistics and the current running status. This information can also be used for performance analysis and tuning.
The following diagram illustrates the relationship between the auditing tables:
