Cloud Cruiser became HPE Consumption Analytics on Nov. 1st. You'll still see the old name in places while we update this site.

 

 

Consumption Analytics Documentation

Home > Cloud Cruiser 4 > Administering > Managing services > Importing services

Importing services

You can import services into HPE Consumption Analytics Portal by using an ETL workbook to collect the service data from a data source, transform it as necessary, and publish it as services. You can also run the ccimport utility against a comma-delimited (CSV) file in the defined format. This article explains how to do both.

You might find it more efficient to import services and rates together.

Using an ETL Workbook

Before you begin

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

To import services 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 services to HPE Consumption Analytics Portal, as described in Creating collections.
    For example, if you export services 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.
  5. Create a Publish as Services step in your flow to publish collected services to HPE Consumption Analytics Portal:
    1. Right-click the flow area, and select Publish Config > As Service.
      The Publish as Services dialog box appears.
    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. 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 ResourceQtyConsumed measure, with GB as the units of measurement.
      PublishAsServices.bmp
  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 services appear as expected in HPE Consumption Analytics Portal on the Financial > Services page.
  8. Schedule regular collection for this workbook to ensure that HPE Consumption Analytics Portal always contains your current services, as described in Scheduling jobs to run.

Using ccimport

Before you begin

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

To import services

  • Enter the command ccimport -t service -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 service -f cloud_services.csv -u -D enforceValidation=false

 

Parameter

Description

defaultActiveFlag

Whether new services are active when no value is specified for active_flag. The default is true.

defaultServiceGroupName

The service group in which to place new services when no value is specified for group_name. The default is Default.

enforceValidation

Whether to enforce validation of imported services, rejecting incompletely defined services. The default is true.

ignoreActiveFlag

Whether to ignore the active_flag values in the import file and instead set all services' Active flag to the value of defaultActiveFlag. The default is false.
Last modified

Tags

Classifications

This page has no classifications.
© Copyright 2018 Hewlett Packard Enterprise Development LP