 |
Consumption Analytics Documentation |
|
Consumption Analytics Documentation |
The Windows Azure Collector is an extension of the universal Excel Collector, and so mapping data from Azure usage reports to CC Records uses the SpreadSheetFeedConfig bean for feed configuration. For general information about data mapping for Excel that also applies to Azure data, see Data mapping in the section for Excel collection.
The following SpreadSheetFeedConfig property settings are required due to the format of the Excel files provided by Windows Azure:
<property name="sheet" value="Detailed Usage" /> <property name="header" value="true" /> <property name="linesToSkip" value="2" />
The sample collection job performs the following mappings.
The job maps the value of the ServiceResource field in a usage report record as the name of a resource in HPE Consumption Analytics Portal and the value of the ResourceQtyConsumed field as the value of that resource.
The job maps the following fields as identifiers with the name of the field becoming the name of the identifier and the value of the field becoming the value of the identifier:
AccountNameAccountOwnerIdAdditionalInfoComponentProductResourceGUIDServiceServiceAdministratorIdServiceInfoServiceRegionServiceResourceServiceSubRegionServiceTypeSubscriptionGuidSubscriptionIdSubscriptionNameYou can add or remove fields from this mapping. For descriptions of the fields in an Azure usage report, see Understanding Your Bill in the Windows Azure documentation. The fields listed in the Usage Charges section there don't exactly match those in a usage report, but they are close enough that you can determine which is which.