Importing services and rates together

Importing using an ETL workbook

Before you begin

Ensure that you have service and rate data available to be collected and published in HPE Consumption Analytics Portal.

To import services and rates using an ETL workbook

1. Go to Data > Workbooks.
2. Create a new workbook for your ETL process.
   See Creating workbooks for more information. By default, the flow of the new workbook contains an Import Collections step, which is required.
3. Create a collection to map your source service and rate data to HPE Consumption Analytics Portal, as described in Creating collections.
   For example, if you export your your service and rate information from its source service catalog to a CSV file, build a CSV collection.
4. If needed, create a Transformation step with one or more processors to modify the imported data before publishing.
   For more information about transformation steps, see Working with flows.
5. Create a Publish as Service and Rate step in your flow to publish collected service and rate data to HPE Consumption Analytics Portal:
   1. Right-click the flow area, and select Publish Config > As Service and Rate.
      The Publish as Service and Rates dialog box appears. For more information about the fields available to publish, see the CSV format section of this topic.
   2. Provide Map To Worksheet Column values for data you want to publish.
      Schema fields with checkboxes are required. You can enter values in quotation marks to publish a literal value, or you can select from the columns available in your collected data to publish collected values.
   3. Enter or select a Map To Worksheet Column value for the Rate Plan: Fixed charge amount and Rate Plan: Rate schema fields, else you will have no rates in your published rate plan.
   4. Consider entering a  Map To Worksheet Column value for the Rate plan name schema field.
      If you do not provide a value, your rates are added to the Default rate plan.
   5. Click OK.
      In the following example, the step creates metered services from Microsoft Azure data using the collected ComputedServiceName measure as the service name. Usage for services is charged according to the collected ComputedServiceName measure, with the units of measurement defined by the collected ServiceResource measure (which might be Compute Hours, Data Transfer Out in GB,and so on).
      
6. Click Save to save your workbook.
7. Test your workbook, as described in Testing collection and deleting data loads, and correct errors as needed.
   When the workbook runs without errors, verify that your rate plan and services appear as expected in HPE Consumption Analytics Portal on the Financial > Services and Financial > Rate Plans pages.
8. Schedule regular collection for this workbook to ensure that HPE Consumption Analytics Portal always contains your current services and rate plan information, as described in Scheduling jobs to run.

Importing with ccimport

Before you begin

Create a CSV file on the HPE Consumption Analytics Portal server in the required CSV format.

To import services

• Enter the command ccimport -t servicerate -f <filename> [-u] [-D <parameter> ...]

  The table below lists the parameters you can use when importing services. You must precede each parameter with -D. For example, to import from the file cloud_services.csv with incomplete service definitions and update duplicate entries:

  ccimport -t servicerate -f cloud_services.csv -u -D enforceValidation=false

CSV format