Operation reports
These reports allow you to view the execution time of ODW imports, and to drill down to detailed information on each SSIS package, for example, the PostProcessing package.
These reports supply a user-friendly way of viewing the history of imports, as well as determining the length of an import, and checking which SSIS packages take the longest time to run.
Reports on-prem
SSIS operation reports
There are three ODW SSIS Operation reports included with the standard installation. They are based on the sysssislog table in the Omada Identity Data Warehouse database.
- Import jobs
- SSIS Import run time
- SSIS Run time
The reports allow you to view the run time of ODW imports and to view detailed information on each SSIS package, for example, the PostProcessing package. The reports show you the history of imports and determine the length of an import and show the SSIS packages that take the longest time to run.
Export operation reports
There are two ODW OISX Export reports included with the standard installation. They are based on the sysssislog and ObjectImportError tables in the Omada Identity Data Warehouse database.
- ES export overview
- ES export failed objects
These reports allow you to view the run time of the export from the Data Warehouse to Enterprise Server and to view detailed information on any failed objects for the latest export.
Using the SQL server’s ‘Disk usage by Table’ function
During the initial load of data, or when you load data from a new source system, you can verify that you have imported the expected amount of data into the tables by looking at the standard report Disk Usage by Table.
Check that the dimension tables, including Account and Identity and the fact tables, including AccountFact and IdentityFact, have been populated.
WOP001 Warehouse Import Overview
This report shows ODW imports within the selected period including run time and processed objects (for example, Identities, Accounts or Resources). The chart shows the imports from the given period, labeled with the import dates, with the bar heights proportional to the import time in seconds.
WOP002 SSIS-Import Run Time
This report shows SSIS packages for an import, including run time and processed objects. The chart shows all the packages imported during a given import, with the bar heights proportional to the package import time in seconds.
This report can be accessed from the Warehouse Import Overview (WOP001) report.
This report links to the SSIS Run Time (WOP003) report.
WOP003 SSIS Run Time
This report shows tasks in an SSIS package including run time.
This report can be accessed directly from SSIS-Import Run Time (WOP002).
WOP001, WOP002, WOP003 fields
| Field | Description |
|---|---|
| Package | The name of the package run. In this report, it will always be Omada ODW Import. This field links to the SSIS-Import Run Time report. |
| Start time | The date and time the import started. |
| End time | The date and time the import ended. |
| Time(s) | The duration of the import, measured in seconds. |
| Objects | Number of objects processed in the import. |
WOP001, WOP002, WOP003 parameters
| Parameter | Description |
|---|---|
| Import start time | The date and time the import started. |
| Import end time | The date and time the import ended. |
WOP004 Warehouse export overview
This report shows ODW exports to Omada within the selected period including run time, exported objects and failing objects.
WOP004 fields
| Field | Description |
|---|---|
| Start time | The date and time the import started. |
| End time | The date and time the import ended. |
| Time(s) | The duration of the import, measured in seconds. |
| Objects | Number of objects processed in the import. |
| Thereof failed | The number of errors. |
WOP004 parameters
| Parameter | Description |
|---|---|
| Export start time | The date and time the export started. |
| Export end time | The date and time the export ended. |
WOP005 Failed objects during ES export on-prem
This report shows failed object from the most recent ODW report to Omada.
The report can be accessed from the Warehouse export overview report (WPO 004).
The report links to the Details for failed objects during ES export report (WPO 006).
WOP005 fields
| Field | Description |
|---|---|
| Object type | Type of object that failed. |
| Source | The source system of the object. |
| Key | The business key of the object. |
| Retried | The number of times the export of this object has been retried. |
| Effective time | The from time used for the report. |
| Error | The error message. |
WOP006 Details for failed objects during ES export on-prem
WOP005 fields
| Field | Description |
|---|---|
| Object type | Type of object that failed. |
| Source | The source system of the object. |
| Key | The business key of the object. |
| Retried | The number of times the export of this object has been retried. |
| Effective time | The from time used for the report. |
| Error | The error message. |