Data checks are used to validate the quality of industry-model data. They consist of a set of predefined SQL checks that can be executed both manually and automatically.
Creation of Data Check
In Autodesk Infrastructure Administrator, go to Industry model > Data checker.
Define an object check by pressing the button.
- Creating/deleting/editing/importing/exporting data checks
- Name of the data check
- Higher-layer group for the tree-like structuring of several data checks
- SQL query of the data check (note: the FID must always be returned as a query)
- Enables/disables the data check for use
- “Module name” is used to structure data checks for plugins
Result for the use case (see screenshot above)
Scheduling Data Check
In Autodesk Infrastructure Administrator, go to Industry model > Data checker. In addition to the "General" tab, there is - only in Oracle databases - the "Scheduled" tab.
On this tab, you create a new schedule for an object check by pressing the button.
For the scheduled data check, you can specify on which weekdays and at what time the checks should be carried out. Finally, the results of the data checks are sent to a predefined email address.
Update Data Checks
The data checks are very difficult to update automatically because of the way they are stored in the database.
A newly created workspace always contains the current standard NET data checks.
In existing workspaces, the standard NET data checks are newly created if all existing data checks are deleted before the structure update.