Configuring an ETL task to import data for BMC Cloud Lifecycle Management services

This topic describes how to configure a TrueSight Capacity Optimization ETL task to import performance and resource utilization data from the following data sources:

  • VMware vCenter: For environments based on VMware
  • Citrix XenServer: For environments based on XenServer

TrueSight Capacity Optimization needs this data to provide Capacity-Aware Placement Advice (CAPA) and Cloud Lifecycle Management (CLM) services to BMC Cloud Lifecycle Management.

Before you begin

You need to have successfully completed BMC - Cloud Lifecycle Management.

Tip

Because you can configure more than one ETL task based on the same ETL module, select a unique task group for each ETL task. For example, you can assign one ETL task to the London VMware vCenter Servers group and another to Paris VMware vCenter Servers, both based on the VMware Extractor Service ETL module.

To configure ETL tasks to import performance data

To configure the VMware vCenter and Citrix XenServer ETL tasks to import performance data for BMC Cloud Lifecycle Management services (CAPA and CLM), perform the following task:

  1. Access the Console and go to Administration > System & ETL Tasks > ETL tasks.
  2. Click Add > Add ETL in the ETL tasks table.
  3. Configure the following ETL modules.
    Note: It is recommended not to execute the ETLs for VMware and Xen Perf data before sharing the ETL lookup table with the BMC Cloud Lifecycle Management ETL task, as this causes problems with the lookup.

    • VMware vCenter module (Under Add ETL > Run Configuration > Data typeremember to select the metrics at Cluster, Resource Pool, Host, Datastore level option, so that metrics at the virtual machine level are not collected.)

    • Citrix - XenServer extractor
  4. Share the ETL lookup table with the BMC Cloud Lifecycle Management ETL task created while configuring BMC - Cloud Lifecycle Management. To do so, while on the Add ETL page, click the Entity Catalog tab, and select the following options:
    • Sharing status: Under Add ETL > Run Configuration > Entity Catalog > Sharing status, select SHARED. Selecting this option introduces the following list:
      • Sharing with ETL: From the Add ETL > Run Configuration > Entity Catalog > Sharing with ETL drop-down list, select the BMC Cloud Lifecycle Management ETL task created while configuring BMC - Cloud Lifecycle Management.
  5. Under Add ETL > ETL Task properties select a Task group for the ETL modules, and then select a scheduler under Running on scheduler to run the the task on.
    NoteBecause you can configure more than one ETL task based on the same ETL module, select a unique task group for each ETL task. For example, you can assign one ETL task to the London VMware vCenter Servers group and another to Paris VMware vCenter Servers, both based on the VMware Extractor Service ETL module.
  6. Click Save to save the ETL.

    After you save the ETL, you can schedule it.

    Warning

    Schedule only one BMC Cloud Lifecycle Management ETL task to run on a specific cloud environment at any time.

For more information about managing ETL tasks, see Working with ETLs.

Scheduling the ETL task

Before switching the ETL task to production mode, BMC recommends running it in test mode to validate results and ensure that data is imported as expected. In simulation mode, no actual data is imported into TrueSight Capacity Optimization.

To configure an ETL task to run in simulation mode:

  1. Click Edit for the active run configuration under Administration > System & ETL Tasks > ETL Tasks.
  2. On the Run configuration tab, for Execute in simulation mode, select yes.
  3. Click Save.

Click Run active configuration to manually run the ETL task. The execution may require some time, depending on the amount of data to be imported.

To verify that the first execution of the ETL task completed successfully, check its exit status and view the execution log by accessing the ETL tasks page under SCHEDULER on the Administration tab of the TrueSight Capacity Optimization Console.

If the first execution in simulation mode was successful, edit the active run configuration to set Execute in simulation mode to no, and then run the ETL task to import data in TrueSight Capacity Optimization.

To schedule the ETL task for future executions:

  1. Access the ETL task detail page.
  2. To view the scheduling settings defined when creating the ETL task, click Edit.
  3. If necessary, modify the scheduling settings.
  4. Click Save.
  5. On the ETL task detail page, click Schedule.

Tip

BMC recommends scheduling the ETL task to run once per hour.

For more information on managing ETL tasks, see Working with ETLs.

Was this page helpful? Yes No Submitting... Thank you

Comments