Help & DocumentationConnecting To Data Sources Sourcing Data from CSV PluginEstablish connectivity to a CSV file via a CSV Plugin

Establish connectivity to a CSV file via a CSV Plugin

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]

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 the credentials to access the
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

0 Comments

Add your comment

E-Mail me when someone replies to this comment