Establish connectivity to a CSV file via a CSV Plugin

As of 6.1, the CSV plugin has been replaced by the following plugins:

This article describes how to use a CSV plugin in order to create a connection profile with  Metric Insights.

The CSV file which serves as a source of data can be located at:

  • the local file system
  • ftp (sftp, ftps (over ssh))
  • s3 (Amazon file server)

General instructions on setting up data sources based on plug-ins can be found here.

1. Access Admin > Data Sources

The list of data sources available in the system opens

At the bottom of the screen click [+ New Data Source]

2. Select "Other" Data Source Type and choose "CSV" from the drop-down

Move to the Next step.

3. Provide Required Parameters
  1. Root location: provide the path to the directory where the CSV file is located. The available options are:
  • local file system
/home/user/tmp
  • ftp (sftp, ftps (over ssh))
ftp://my-server.com/some/path
  • s3 (Amazon file server)
s3://
s3://bucket
s3://bucket/some/path
  1. Username / Password: provide authentication credentials to access the root location.
Optional CSV Parameters
  1. Bucket Pattern (C3): A setting specific to Amazon server. 
pref*, dasd*, 1*2
  1. CSV Delimiter: Confirm that the Delimiter character is the same as in your CSV file
Advanced Configuration
  1. External Reports fetch method: This setting influences options available in the CSV Report List tab:
    • automatically: just click Refresh list and all Reports are going to be fetched by the system
    • manually: Reports may be added one-by-one or via CSV file.
  2. Optionally, specify the maximum number of concurrent Threads per Trigger execution to be used in background processing when the system updates Metrics and Reports for this Data Source.  If you do not specify any value for this setting, batch data collection processing will be single-threaded.
Other Settings
  1. You can create elements or Datasets directly from the respective tabs
  2. Click Permissions to assign them to Groups or Power Users