Mapping data to Cloud Cruiser

Table of contents

Overview

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.

Feed configuration settings

The following SpreadSheetFeedConfig property settings are required due to the format of the Excel files provided by Windows Azure:

Mapping specific fields

The sample collection job performs the following mappings.

Resources

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.

Identifiers

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:

AccountName

AccountOwnerId

AdditionalInfo

Component

Product

ResourceGUID

Service

ServiceAdministratorId

ServiceInfo

ServiceRegion

ServiceResource

​ServiceSubRegion

ServiceType

SubscriptionGuid

SubscriptionId

SubscriptionName

You 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.