Storage All-in-One ETL for TrueSight Capacity Optimization
To collect data by using the Storage All-in-One ETL 1.12.00 for TrueSight Capacity Optimization, perform the following tasks:
I. Complete the preconfiguration tasks.
II. Configure the ETL.
III. Run the ETL.
The Storage All-in-One ETL supports the following platforms:
- Ceph Storage
- Dell EMC Isilon
- Dell EMC ScaleIO (REST)/Dell EMC PowerFlex (REST)
- Dell EMC SC Series
- Dell EMC Unity (REST)
- Dell EMC PowerStore (REST)
- Dell EMC PowerVault (REST)
- Dell EMC VMAX (3rd Generation, All Flash or newer), and PowerMax (WBEM)
- Dell EMC VMAX/PowerMax (REST)
- Dell EMC XtremIO
- HPE Primera (WBEM)
- Huawei OceanStor (REST)
- Hitachi G Series (REST)
- IBM DS888x
- IBM Spectrum Scale
- NetApp E-Series
- NetApp SolidFire
- Pure Storage
Important information
Some platforms can be monitored by both the Storage All-in-One ETL and a manufacturer specific ETL. Please read the following information:
EMC VMAX Systems
For recent systems (3rd Generation and AllFlash) the use of the All-in-One ETL is recommended as it is better optimized for these larger systems. For older VMAX, VNX and Clariion systems, the EMC ETL should be preferred.
Pure and XtremIO Systems
Code Level 144 will be the last version released for these manufacturer specific ETLs. It is recommended to migrate to the All-in-One ETL for monitoring Pure and XtremIO systems.
Ceph
Dell EMC Isilon
Dell EMC SC Series
Dell EMC ScaleIO (REST)/Dell EMC PowerFlex (REST)
Dell EMC Unity (REST)
Dell EMC PowerStore (REST)
Dell EMC PowerVault (REST)
Dell EMC VMAX (WBEM)
Dell EMC VMAX/PowerMax (REST)
Dell EMC XtremIO
HPE Primera (WBEM)
Huawei OceanStor
Hitachi G Series (REST)
IBM Spectrum Scale
IBM DS888x
NetApp E-Series REST API
NetApp SolidFire
Pure Storage REST API
Deploying the ETL module
Complete the following steps to deploy the ETL Module:
- Navigate to Administration > SYSTEM > Maintenance.
- Verify the installation status of the already uploaded packages. If their status is "READY" or "RUNNING", wait for the installation to complete before proceeding.
- At the bottom of the Maintenance page, locate the Upload patch or additional package file section.
- Click Browse.
- Locate and select the ETL installation package.
- Click Upload.
- Read the Overview and click Next to continue.
- Read and accept the End User License Agreement.
- Select the server on which the operation must be executed; that is the server on which the package will be saved. Click Proceed to continue.
A successful installation will result in a green line in the Additional Packages table.
Note
In case of unsuccessful outcome (e.g. a yellow WARNING line), click theicon to inspect the deployment log.
Once the Storage All-in-One ETL is installed, the Storage Engine and Storage Intelligence rows appear in the Administration > System > Maintenance > Additional Packages tab:
You must configure the ETL to connect to the required storage system for data collection. ETL configuration includes specifying the basic and optional advanced properties. While configuring the basic properties is sufficient, you can optionally configure the advanced properties for additional customization.
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 TrueSight Capacity 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 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 - All-in-One 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 ETLs access the same entities.- 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.
Click the Connection Settings tab, and configure the following properties:
Property Description Storage Solution Storage solution to be configured. Select:
- Ceph Storage REST to collect capacity information about your Ceph Storage systems
- Dell EMC Isilon to collect capacity information about your Dell EMC Isilon systems
- Dell EMC ScaleIO REST to collect capacity information about your Dell EMC ScaleIO systems
- Dell EMC SC Series to collect capacity information about your Dell EMC SC Series systems
- Dell EMC VMAX WBEM to collect capacity information about your Dell EMC VMAX systems
- Dell EMC XtremIO REST to collect capacity information about your Dell EMC XtremIO systems
- IBM DS8880 WBEM to collect capacity information about your IBM DS888x systems
- IBM Spectrum Scale REST to collect capacity information about your IBM Spectrum Scale systems
- NetApp E-Series REST to collect capacity information about your NetApp E-Series systems
- NetApp SolidFire REST to collect capacity information about your NetApp SolidFire systems
- Pure Storage REST to collect capacity information about your Pure Storage systems
- Other Storage Solution to collect capacity information about any other storage solution supported by the Storage-All-in-One ETL. In this case, you will have to manually enter the name of the Si (Storage Intelligence) file to be used.
Other Storage Solution Name of the Storage Intelligence file (without extension) to be used. This field should only be specified if the Storage Solution property is set to Other Storage Solution. Hostname Hostname or IP address of the storage solution.
Port Port number used to connect to the storage solution.
Connect As Password to connect to the storage solution.
Transport Protocol Transport protocol used to connect to the storage solution (HTTP or 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 to run the ETL.
Locate the ETL in the ETL tasks table and click
After you run the ETL, or schedule the ETL for a run, it will extract the data from the source and transfer it to TrueSight Capacity Optimization database. You can see the entity hierarchy in the left Navigation pane, under Workspace. to run it, or schedule an ETL run.
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 TrueSight Capacity 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.
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 TrueSight Capacity 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 TrueSight Capacity Optimization database.
Reconciling data
If you used the same Shared Entity Catalog while creating your ETL tasks, data will be automatically reconciled since the ETL tasks are using the same lookup details. If you used a Private Entity Catalog or a different entity catalog, you will have to reconcile data. The procedure is as follows:
- Create the new entity catalog:
- In the Administration tab, click ETL & System Tasks > Entity catalogs
- Click Add entity catalog
- Name your entity catalog and eventually provide a description
- Click Save.
- Configure both ETL tasks to use this entity catalog:
- In the Administration tab, click ETL & System Tasks > ETL tasks.Click the link of the ETL task for which you wish to set the entity catalog
- Click the Stop button to stop the service execution; then click the button available in the Run configuration section.
- In the Entity Catalog section:
- Select the Shared Entity Catalog radio button
- From the Sharing with Entity Catalog pull-down list, select the entity catalog previously created (in our example: EMC)
- Click Save.
- Start the ETL.
- Resume the procedure for the second ETL task.
- Perform the reconcile operation:
- In the Administration tab, click ETL & System Tasks > Entity catalogs
- Click the entity catalog previously created (in our example: EMC)
- Click the Reconcile entities button
- Perform the entity reconciliation:
Select the Datasource for which you wish to compare the Lookup fields
- Compare entities by Lookup fields and select the look fields
- Click Search to determine the entities that can be reconciled
- Either select the entities to be reconciled and click Reconcile selected rows or click Reconcile all.
Verify in your workspace that all the selected entities are properly reconciled. Only one instance should be created.
Comments
I can't see this page: Unable to render {include} The included page could not be found.
Hello,
Thanks for reporting this. Please check now.
Thanks, Bharati
I have the same problem that Lorenzo had. Unable to render {include} The included page could not be found. Thanks, John
Hi John,
It's accessible now. Please check.
Thanks, Bipin Inamdar
Log in or register to comment.