Consumption Analytics Documentation

Home > Documentation for older versions > Cloud Cruiser 4 > Administering > Managing services > Importing services

Importing services

You can import services into Cloud Cruiser 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 Cloud Cruiser.

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 Cloud Cruiser, 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 Cloud Cruiser:
    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.
  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 Cloud Cruiser on the Financial > Services page.
  8. Schedule regular collection for this workbook to ensure that Cloud Cruiser always contains your current services, as described in Scheduling jobs to run.

Using ccimport

Before you begin

Create a CSV file on the Cloud Cruiser 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





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


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


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


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



This page has no classifications.

 (c) Copyright 2017-2020 Hewlett Packard Enterprise Development LP