The ODBC data collector is used to import assets and collect data from the Open Database Connectivity (ODBC) compliant databases. For example, you maintain an Oracle database that stores asset details of various Oracle computers, which you can import using an ODBC data collector. In Control Compliance Suite, you must configure a CCS Manager as an ODBC data collector.
The ODBC data collector is equipped to import assets of predefined platforms or custom platforms and also collect data for the assets. The data collector interprets data only if the database table or view names and the column names are defined in a specific format.
The end-to-end sequence to import assets and collect data using the ODBC data collector is as follows:
Identify the assets for which data is to be collected using the ODBC data collector.
Assets belonging to either the predefined platforms or custom platforms can be imported.
Create ODBC compliant database, which contain the assets that you want to import and their data. The ODBC compliant database tables or view names and the column names must be of the defined format for easy interpretation by the Control Compliance Suite for asset import or data collection.
If the database table or column names are not as per the naming convention, then you can manually map them through a dialog box.
Register a CCS Manager as the ODBC data collector through the Edit Settings dialog box.
Configure the CCS Manager as the ODBC data collector.
Import the assets through the Create or Edit Asset Import Job wizard.