Creating an ODBC database table for predefined asset types
In Control Compliance Suite, the ODBC databases can be used to store asset information for asset import and data collection by the infrastructure. The assets are imported into the databases using the ODBC data collector, which also performs the data collection. You can store information of predefined asset types in the ODBC databases and configure an ODBC data collector to import the assets. The ODBC data collector interprets data that is stored in the database tables only if the table or view and column names are of a specific format.
Identify the internal names of the predefined platforms and their entities.
The predefined platforms and their internal names are as follows:
In the console, go to Manage > Assets > Asset System.
On the right-hand side table pane of the Asset System view, select a predefined asset type from the Display drop-down box.
From the taskbar select .
The ODBC headers for the selected predefined asset type must be used for the database table or view names.
Navigate to the ODBC database and create the table or view names as per the entities of the predefined platform.
The predefined asset types are defined same as the entities of the predefined platform.
For example, for the Windows platform, the predefined asset type is of the same name as the entity, Windows Directory. The table or view name format of the database is a combination of the internal name of the platform and the entity name such as, WntDirectory. The table or view name format for the Common platform is also, WntDirectory.
In the ODBC database, create table column names same as the asset-specific and common field names of the predefined asset type.
For example, for the predefined asset type, Windows Directory, the table column names are, Domain Name, Directory Name, Machine Name, Confidentiality, Integrity, and so on.
Import the assets of the predefined asset type through the Create or Edit Asset Import Job wizard.
Ensure that you select ODBC data collector in the wizard to import the assets from the ODBC database tables.
Imported Document ID: HOWTO75604
Subscribing will provide email updates when this Article is updated. Login is required.