Configuring the CSV data collector

The CSV data collector collects data from the CSV files, which contains data that is exported from any custom application. In Control Compliance Suite, any DPS that is registered to a site can be configured as a CSV data collector. You can configure a DPS as a CSV data collector either from the Grid View or from the Map View of the console.

The CSV file stores data in the comma-separated format. The CSV file must be placed in a network share path of the computer that hosts the DPS. The CSV data collector is configured to fetch data from the CSV file. You must ensure that the data is arranged in a specific format in the CSV file, which is easily interpreted by Control Compliance Suite.

See Creating a CSV file .

Note:

If a CSV file is shared on a DPS collector computer, then ensure that the user has either log on locally or log on as a batch job permission. This permission is required for the CSV data collector of both the single setup and distributed setup modes. The user is the one whose credentials are required to access the network share path. The same user credentials are also specified for the selected platform of the CSV option in the Components settings dialog box.

The CSV data collector can be used for data collection in the following scenarios:

To collect data for the common fields of a predefined asset type.

You must use the platform, Common in the Common settings dialog box for the CSV configuration.

See Configuring Common platform through CSV settings.
To collect data for any custom application.

To configure the CSV data collector

Go to Settings > System Topology.
Do one of the following:
- In the System Topology > Grid View, right-click the Data Collection Service and click Edit Settings.
- In the System Topology > Map View, right-click a registered DPS component and click Edit Settings.
In the Components settings dialog box, select CSV under the Data Collector Sites option on the left pane of the dialog box.
Select the site to which the DPS is registered from the Site Name drop-down box on the right side pane of the dialog box.

Enter values for the fields to configure the CSV data collector.

The fields and the descriptions are as follows:

Platform	Enter the platform of the application whose data is to be queried . You can use the drop-down box to select the platform of the application.
CSV File(s) Path	Enter the path where the CSV file is placed. Click the browse button and in the Browse for folder dialog box, browse to the path where the CSV file is located. You must ensure that the CSV file path is specified in the UNC format, \\<server name>\<share name>\<path>\<filename>.csv.
Windows Domain	Enter the domain of the Windows computer, where the CSV file is located. You need to provide the credentials of the Windows domain user in the dialog box, Credentials for the Platform.
User Name	Enter the user name of the specific domain.
Search Pattern	Enter the search pattern of the CSV file. For example, in a given share path there can be several CSV files for the same platform. In such a case, if you want to have data from the CSV file that starts with the alphabet, m, then the search option can be, m*.csv.
File Encoding	Enter the encoding type of the file. For example, Unicode (UTF -8). You can use the drop-down box to select the unicode of the CSV file.

Click Apply.
Click OK.