Storage - NetApp Data ONTAP Extractor Service
Use the NetApp Data ONTAP ETL for BMC Helix Continuous Optimization to poll and collect configuration and performance data via the DATA ONTAP API. The ETL uses the Storage - NetApp Data ONTAP Extractor Service task to collect all the metrics required for performing critical capacity optimization tasks, such as: analysis, trending, simulation and analytic modeling.
Collecting data by using NetApp Data ONTAP ETL ETL for BMC Helix Continuous Optimization
To collect data by using the NetApp Data ONTAP ETL for BMC Helix Continuous Optimization, perform the following tasks:
I. Complete the preconfiguration tasks.
II. Configure the ETL.
III. Run the ETL.
Step I. Complete the preconfiguration tasks
Configuring Data ONTAP
To monitor a NetApp storage system in Cluster mode, you need to create a user with read-only access to the DATA ONTAP API.
When using Data ONTAP v7.x and 8.x
Copy-paste the following command lines into the NetApp CLI:
>::security >login create -username newuser -application ontapi -authmethod password -role readonly
When using Data ONTAP v9
Copy-paste the following command lines into the NetApp CLI:
security login create -user-or-group-name tsco -application http -authentication-method password -role readonly
or add a user in NetApp OnCommand System Manager with the following login methods:
Step II. Configure the ETL
A. Configuring the basic properties
Some of the basic properties display default values. You can modify these values if required.
To configure the basic properties:
- In the Helix Continuous Optimization console, navigate to Administration > ETL & SYSTEM TASKS > ETL tasks.
- On the ETL tasks page, under the Last run tab, click Add > Add ETL. The Add ETL.The Add ETL page displays the configuration properties. You must configure properties in the following tabs: Run configuration, Entity catalog, and ETL additional settings.
- On the Run configuration tab, select Storage - NetApp Data ONTAP Extractor Service from the ETL Module list. The name of the ETL is displayed in the ETL task name field. You can edit this field to customize the name.
- Click the Entity catalog tab, and select one of the following options:
Shared Entity Catalog:
Select if other ETLs access the same entities that are used by the NetApp Data ONTAP ETL.
- From the Sharing with Entity Catalog list, select the entity catalog name that is shared between ETLs.
- Private Entity Catalog: Select if this is the only ETL that extracts data from the NetApp Data ONTAP resources.
Click the Connection Settings tab, and configure the following properties:
Property
Description
Hostname
Hostname of the NetApp Filer in Cluster Mode or the IP address of the first controller in 7-Mode.
Port
Port number to connect to the NetApp Filer (Default: 443).
Connect As
Username to connect to the NetApp Filer.
Password
Password to connect to the NetApp Filer.
Partner Hostname
Partner hostname or IP address of the second controller of the NetApp Filer (7-mode only).
Transport Protocol
Transport protocol used to connect to the NetApp Filer (default port is 80 for HTTP, 443 for HTTPS).
Click Save. You are returned to the Last run tab under the ETL tasks page.
- 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.
- 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.
- Switch the ETL to production mode: Perform the following steps:
- In the ETL tasks table under ETL tasks > Last run, click the ETL under the Name column.
- In the Run configuration table in the ETL details page, click
to edit the active Run configuration.
- In the Edit run configuration page, navigate to the Run configuration expandable tab and set Execute in simulation mode to No.
- Click Save.
- Validate the results in simulation mode: In the ETL tasks table under ETL tasks > Last run, locate your ETL (ETL task name), click
- 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 BMC Helix Continuous Optimization database. You can see the entity hierarchy in the left Navigation pane, under Workspace. - Click the ETL additional settings tab, and configure the following properties:
Property | Description |
---|---|
Entity types | This property allows you to specify the terminology to be used for entity types. Select: Storage - Vendor Agnostic (Recommended) if you are using several storage ETLs and the Storage Capacity Views and Reports for BMC Helix Continuous Optimization. NetApp Specific Terminology if you want your entity types to use the NetApp terminology. Please note that this configuration is not compatible with the Storage Capacity Views and Reports for BMC Helix Continuous Optimizationand requires NetApp Capacity Views for BMC Helix Continuous Optimization to be installed to benefit from the data analysis functionalities. This configuration should therefore only be selected if you are not using other storage ETLs. |
Shares | This property allows you to fine-tune the creation of shares entities in the BMC Helix Continuous Optimization environment. For more information, refer to the section "Customizing Volumes and Shares Monitoring" below. |
Volumes | This property allows you to disable or enable volumes monitoring and fine-tune the creation of volume entities in the BMC Helix Continuous Optimization environment. For more information, refer to the section "Customizing Volumes and Shares Monitoring" below. |
(Optional) B. Configuring the advanced properties
You can configure the advanced properties to change the way the ETL works or to collect additional metrics.
To configure the advanced properties:
Property | Description |
---|---|
Collection level | |
Levels up to | By default, extended level metrics are not imported by the ETL. To import them, you will have to customize the collection level and set it to [4] Extended. |
Click Save. The ETL tasks page shows the details of the newly configured NetApp Data ONTAP ETL.
Complete the procedure by performing steps 6 to 8 from the Configuring the basic properties procedure.
Step III. Run the ETL
After you configure the ETL, you can run it to collect data. You can run the ETL in the following modes:
A. Simulation mode: Only validates connection to the data source, does not collect data. Use this mode when you want to run the ETL for the first time or after you make any changes to the ETL configuration.
B. Production mode: Collects data from the data source.
A. Running the ETL in the simulation mode
To run the ETL in the simulation mode:
- In the Helix Continuous Optimization console, navigate to Administration > ETL & System Tasks, and select ETL tasks.
- On the ETL tasks page, click the ETL. The ETL details are displayed.
- In the Run configurations table, click Edit
to modify the ETL configuration settings.
- On the Run configuration tab, ensure that the Execute in simulation mode option is set to Yes, and click Save.
- Click Run active configuration. A confirmation message about the ETL run job submission is displayed.
- On the ETL tasks page, check the ETL run status in the Last exit column.
OK Indicates that the ETL ran without any error. You are ready to run the ETL in the production mode. - If the ETL run status is Warning, Error, or Failed:
- On the ETL tasks page, click
in the last column of the ETL name row.
- Check the log and reconfigure the ETL if required.
- Run the ETL again.
- Repeat these steps until the ETL run status changes to OK.
- On the ETL tasks page, click
B. Running the ETL in the production mode
You can run the ETL manually when required or schedule it to run at a specified time.
a. Running the ETL manually
- On the ETL tasks page, click the ETL. The ETL details are displayed.
- In the Run configurations table, click Edit
to modify the ETL configuration settings. The Edit run configuration page is displayed.
- On the Run configuration tab, select No for the Execute in simulation mode option, and click Save.
- To run the ETL immediately, click Run active configuration. A confirmation message about the ETL run job submission is displayed.
When the ETL is run, it collects data from the source and transfers it to the BMC Helix Continuous Optimization database.
b. Scheduling the ETL run
By default, the ETL is scheduled to run daily. You can customize this schedule by changing the frequency and period of running the ETL.
To configure the ETL run schedule:
- On the ETL tasks page, click the ETL, and click Edit. The ETL details are displayed.
- On the Edit task page, do the following, and click Save:
- Specify a unique name and description for the ETL task.
- In the Maximum execution time before warning field, specify the duration for which the ETL must run before generating warnings or alerts, if any.
- Select a predefined or custom frequency for starting the ETL run. The default selection is Predefined.
- Select the task group and the scheduler to which you want to assign the ETL task.
- Click Schedule. A message confirming the scheduling job submission is displayed.
When the ETL runs as scheduled, it collects data from the source and transfers it to the BMC Helix Continuous Optimization database.
Step IV. Post-configuration steps
A. Testing the connection to the NetApp Data ONTAP API
The ETL relies on the NetApp Data ONTAP API to collect information about NetApp Filers. Because some connectivity issues may exist and cause the ETL to fail, it is highly recommended to test the connection to this specific component. The procedure is as follows:
- Download the troubleshooting tool from EPD.
- Run the command java –jar <Troubleshooting_Tool_Name.jar> to launch the tool.
- Enter the information required to connect to the system and click Test Connection.
- Wait for the test to complete.
- If a connectivity issue is detected, an error message will appear. In this case, the issue encountered does not concern the ETL. Check your configuration to diagnose the source of the issue.
- Click Save As to export the connection test results into a txt file.
B. Customizing volumes and shares monitoring
Discovering volumes and/or shares and collecting their performance metrics are resource-intensive actions that can create extra workload on the system. To reduce the system resource consumption, administrators can disable or enable the volumes and/or shares monitoring at will and fine-tune the creation of volume and/or share entities into the BMC Helix Continuous Optimization environment.
The following metrics are no longer collected and displayed in the console when volumes monitoring is disabled:
Dataset | Metrics |
---|---|
STOGLB | 7-Mode and Cluster-Mode: ST_CONFIGURED_VOLUME_CAPACITY_PCT (Storage System Configured Capacity Percentage) ST_OVERSUBSCRIBED_CAPACITY (Storage Oversubscribed Capacity) ST_POOL_SUBSCRIBED_CAPACITY (Pool Subscribed Capacity) ST_POOL_SUBSCRIBED_CAPACITY_PCT (Pool Subscribed Capacity Percentage) ST_SYSTEM_SUBSCRIBED_CAPACITY (Storage Subscribed Capacity |
To customize volumes and shares monitoring
- Edit the NetApp Data ONTAP ETL Run Configuration.
- Expand the ETL additional settings menu.
From the Shares/Volumes pull-down lists, select one of the following options:
Option
Result
Disabled
Volumes/Shares are not discovered.
Volumes/shares-related metrics are not loaded in the console.
Collected for metric computation (Default)
All volumes/shares are discovered and their metrics are collected and processed.
Volumes/shares-related metrics are not loaded in the console.
Collected and Imported
All volumes/shares are discovered and their metrics are collected and processed.
Volumes/shares-related metrics are saved in the database, processed and loaded in the console.
- Click Save.
C. Running the Extractor Service task
D. Setting the collect frequency