Deploying and configuring Storage All-in-One ETL for TrueSight Capacity Optimization
This topic contains the following sections:
- Compatibility details
- Prerequisites
- Deploying the ETL module
- Configuring the ETL module
- Post-configuration steps
- Lookup details
Compatibility details
TrueSight Capacity Optimization
TrueSight Capacity Optimization v11.5.
Supported platforms
- Dell EMC ScaleIO
- Dell EMC VMAX
- NetApp SolidFire
Prerequisites
Dell EMC ScaleIO
Dell EMC VMAX
NetApp SolidFire
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.
Once the Storage All-in-One ETL is installed, the Storage Engine and Storage Intelligence rows appear in the Additional Packages tab:
Configuring the ETL module
Complete the following steps to configure an ETL service and add it as an ETL task to extract capacity and performance metrics:
- Navigate to Administration > ETL & SYSTEM TASKS > ETL tasks.
- In the ETL tasks page, under the Last run tab, click Add > Add ETL. The Add ETL page is displayed.
- In the Run configuration tab, in the ETL module property, select Storage - All-in-One Extractor Service
Specify values for the common and advanced properties that are listed under the expandable tabs. To view or configure advanced properties, click Advanced.
For details about the common properties, see ETL common configuration properties. The following table lists the properties that are specific to the Storage All in One ETL module:
Property | Description |
---|---|
Connection settings | |
Storage Solution | Storage solution to be configured. Select:
|
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 | Username to connect to the storage solution. |
Password | 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.
- 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 TrueSight Capacity Optimization database. You can see the entity hierarchy in the left Navigation pane, under Workspace.
Post-configuration steps
- Reconciling data
- Configuring the discovery of VMAX remote arrays
- Running the Extractor Service task
- Setting the collect frequency
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: Storage)
- Select the Shared Entity Catalog radio button
- 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.
Configuring the discovery of VMAX remote arrays
VMAX remote arrays are not discovered by default. To enable the discovery, you will have to add the property discoverRemoteArrays and set it to true. The procedure is as follows:
- Edit the ETL Run Configuration:
- In the Administration tab, click ETL & System Tasks > ETL tasks.
- Click the link of the ETL task for which you wish to set the collect frequency.
- Click the Stop button to stop the service execution; then click the
button available in the Run configuration section.
- Click the link You can manually edit ETL properties from this page provided at the bottom of the page to display a list of editable options.
- In the Add new property field, enter discoverRemoteArrays and click Add.
- In the list of properties, locate discoverRemoteArrays and enter true.
- Click Save.
- Start the ETL.
Running the Extractor Service task
Setting the collect frequency
Lookup details
Storage All-in-One ETL for TrueSight Capacity Optimization defines the following lookup fields:
Storage System | DEFAULT |
Storage Pool | DEFAULT |
Storage Volume | DEFAULT |