Recovering data using the vis files parser
This section provides information about how to configure a recovery ETL. A recovery ETL is used when you want to recover and import in BMC TrueSight Capacity Optimization data. For more information on the scripts that can be used for recovery, refer to Creating recovery scripts for TrueSight Capacity Optimization and Gateway Server.
To configure the Recovery ETL
The following steps describe the content of the tabs and configuration settings; items that are only available in advanced mode are marked as . Click Advanced to view the advanced settings available for this ETL.
To configure the recovery ETL, follow these steps:
- Navigate to Administration > ETL & SYSTEM TASKS > ETL tasks.
- In the ETL tasks page, select Add > Add ETL under the Last run tab.
- Enter the following details in the Run configuration tab.
- Run Configuration name: Enter a name for the ETL. For instance, Gateway Server Data Recovery.
- Environment: Select environment as Production or Test.
- Description: Brief description for the ETL.
- Log Level: Select the level of detail for the execution log (for example, 1 - Light, 5 - Medium, 10 - Verbose)
- Execute in simulation mode: Select yes if you want to test data import, the ETL will not store actual data into the data warehouse
- ETL module: Select BMC - TrueSight Capacity Optimization Gateway VIS files parser.
- Datasets: Select the datasets from the list.
- Platform: Select the platform that the ETL will recover. It should be the same platform as the data that you want to recover.
- Enable platform filtering: Select either yes or no. By default yes is selected.
- Data type: Select the data types you want to recover.
- In the Entity catalog tab, select SHARED to share the lookup with the ETL that is importing online data. If you have a master lookup table that is handling all the Gateway Server ETLs, share it with that ETL.
You must have one recovery ETL instance per BMC TrueSight Capacity Optimization domain/Gateway Server visualization platform.
- In the Object relationships tab, select existing domain to select the domain you are trying to recover.
- In the Metric filter tab select the metrics that should be loaded for each of the selected data sets.
- In the Gateway Server Vis parser tab,
- Gateway Server Version: Select the version you are trying to recover.
- Extractor mode: Select via file.
- Lookup names customization: Select the name customization for hosts and virtual machine.
- User network name as system name for VMware virtual machines: Select if you want to use system name or network name for VMware virtual machines.
- Data recovery mode: Select True to activate data recovery mode.
In the File location tab, select the transfer method and required details. The selected directory must be shared between the recovery script and ETL.
- MultiExcerpt named 'filelocation' was not found
- In the Loader configuration tab, specify the following details.
- Empty dataset behaviour: What to do when no data is available (available options are Abort or Ignore).
- ETL log file name: Name of the file contains the ETL execution log; the default value is
- Maximum number of rows for CSV output: A number which limits the size of the output files.
- CSV loader output file name: Name of the file generated by the CSV loader; the default value is
- BCO loader output file name: Name of the file generated by the BMC Capacity Optimization loader; the default value is
- Detail mode: Available options are Standard, Raw also, or Raw only.
- Reduce priority: Available options are Normal or High.
- Remove domain suffix from data source name: (Only for systems) if true, the domain name is removed from the data source name; e.g.
server.domain.comwill be saved as
- Leave domain suffix to system name: (Only for systems) if true, the domain name is maintained in the system name; for example,
server.domain.comwill be saved as such.
- Update grouping object definition: If this option is selected, the ETL will be allowed to update the grouping object definition for a metric loaded by an ETL.
- Skip entity creation: (Only for ETL tasks sharing lookup with other tasks) If this option is selected, this ETL does not create an entity, and discards data from its data source for entities not found in BMC Capacity Optimization. It uses one of the other ETLs that share lookup to create the new entity.
- In the Scheduling options tab, specify the details to schedule a recovery ETL. Enter the following details in the properties.
- Hour mask: Hour mask to schedule a recovery ETL.
- Day of week mask: Select the type of day of week mask from the check box.
- Day of month mask: Number of days of month mask.
- Apply mask validation: Select mask validation either as true or false.
- Execute after time: Execute after time of a recovery ETL.
- Enqueueable: Select if the ETL should be enqueueable.
- In the ETL task properties tab, specify the following details.
- Task group: Select the Task group from the Task group drop- down box.
- Running on scheduler: By default Primary Scheduler is selected.
- Maximum execution time before warning: Set Maximum execution time before warning in format (minutes, hours, and days).
- Frequency: By default Predefined is select as frequency. In case of selecting frequency as Custom, you need to set Custom frequency and Custom start timestamp.
- Predefined frequency: Select Predefined frequency, either as day, week, or month.
- Start timestamp: Specify timestamp in hour and minute format.
- Select Save to apply the changes.