Generic - Custom structure format CSV parser

Before you begin

Before you integrate BMC Helix Continuous Optimization with the Custom structure format CSV parser, refer to Collecting-data-for-custom-structure-tables.

To collect data by using the Custom structure format CSV parser

To collect data by using the Custom structure format CSV parser, do the following tasks:

1. Navigate to Administration > ETL & SYSTEM TASKS > ETL tasks.
2. In the ETL tasks page, click Add > Add ETL under the Last run tab.

3. In the Add ETL page, set values for the following properties under each expandable tab.

   • Basic
   • Advanced

   Important

   Basic properties are displayed by default on the Add ETL page. These are the most common properties that you can set for an ETL, and it is acceptable to leave the default selections for each as is.

   Basic properties

   Important

   To view or configure Advanced properties, click Advanced. You do not need to set or modify these properties unless you want to change how the ETL works. These properties are for advanced users and scenarios only.

   Advanced properties
4. Click Save.
   You return to the Last run tab under the ETL tasks page.
5. Validate the results in simulation mode: In the ETL tasks table under ETL tasks > Last run, locate your ETL (ETL task name), click  to run the ETL.
   After you run the ETL, the Last exit column in the ETL tasks table will display one of the following values:
   • OK: The ETL executed without any error in simulation mode.
   • WARNING: The ETL execution returned some warnings in simulation mode. Check the ETL log.
   • ERROR: The ETL execution returned errors and was unsuccessful. Edit the active Run configuration and try again.
6. Switch the ETL to production mode: To do this, perform the following task:
   1. In the ETL tasks table under ETL tasks > Last run, click the ETL under the Name column.
   2. In the Run configurations table in the ETL details page, click  to edit the active run configuration.
   3. In the Edit run configuration page, expand Run configuration and set Execute in simulation mode to No.
   4. Click Save.
7. Locate the ETL in the ETL tasks table and click  to Run it or schedule an ETL run.
   After you run the ETL or schedule the ETL for a run, it will extract the data from the source and transfer it to the BMC Helix Continuous Optimization database. 

Input file format

The input file follows the open ETL structure.

Here is a sample of the supported file structure for system metrics:

Select one of the APPEND, UPDATE, or TRUNCATE behaviors to import data in the buffer table. If data is present in the input file and you select the TRUNCATE behavior, the table will be emptied out before loading new data. This is the same as selecting APPEND behavior and enabling the Truncate table before load option in the ETL configuration.

The specified buffer table name will be checked in the BMC Helix Continuous Optimization schema. If the table is not present, create the table by using the data mart API. For details, see Datamart-API-endpoints.