Map AWS tags to Apptio Schema

Edit online

This article will help you map AWS cost allocation tags to your Apptio schema. Cost allocation tags help you categorize and track your AWS costs.

When you apply tags to your AWS resources (such as Amazon EC2 instances or Amazon S3 buckets) and activate the tags, AWS generates a cost allocation report as a comma-separated value (CSV file) with your usage and costs aggregated by your active tags. You can apply tags that represent business categories (such as cost centers, application names, or owners) to organize your costs across multiple services.

Applies to: Apptio Costing Standard on TBM Studio 12.3.3 and later

About this task

The following AWS resources provide background information about tags:

Recommended tags

Not all AWS tags are required for Apptio. The following list is recommended as a guide for the data that will be important in your Costing Standard implementation.

Tag Description Value in Apptio
Application Name Name of the application supported by the tagged resource
  • Provide analytics to help understand cloud spend by apps consuming cloud services
  • Allocate spend to apps to calculate TCO
Application Environment (Prod, Dev, Test, DR) Environment supported by the tagged resource Provide analytics to help understand cloud spend by app environment built on cloud services
Application Tier (Web server, Business Logic, Database) App tier of the tagged resource Provide analytics to help understand cloud spend by app tier built on cloud services
Cost Center Cost center responsible for operating the tagged resource
  • Provide analytics to help understand cloud spend by cost center consuming cloud services
  • Allocate and showback/chargeback spend to IT customers
System Owner Individual responsible for operating the tagged resource
  • Provide analytics to help understand cloud spend by cost center consuming cloud services
  • Allocate and showback/chargeback spend to IT customers
Project Project associated with the tagged resource
  • Provide analytics to help understand cloud spend by cost project driving cloud services
  • Allocate spend to IT projects

For the monthly Cost Allocation report

Edit online

Procedure

  1. Navigate to TBM Studio.
  2. Select the AWS Cost Allocation Bill Master Data and check it out.

  3. In the transform pipeline, click the Append step, then click Edit on AWS Cost Allocation Raw.

    A dialog opens, allowing you to map columns from the raw AWS Cost Allocation Raw to the Apptio AWS Cost Allocation Bill Master Data table.

  4. Complete the mappings for the following columns that are relevant to your organization's AWS tags and payer/linked account structure:
    IMPORTANT Be sure to click Saveafter completing the mappings.
    • Business Unit (defaulted to Payer Account)
    • Department (defaulted to Linked Account)
    • Team
    • System Owner
    • Cost Center
    • Application
    • Environment
    • Project
    • Purpose
  5. Click Save, then check in your work.

For the daily Detailed Billing report with resources and tags

Edit online

Procedure

  1. Navigate to DataLink and select Default Agent.
  2. Select to edit the AWS Daily-Hourly - Daily Run connector.
  3. Scroll down to the Report - Column Mappings section.
  4. Update the entries in the Source column to match those that you configured for the Cost Allocation report above.
  5. Leave Source blank for any unmapped Destination fields.
  6. Save the connector.
  7. In the connector list, click Action, then click Run Now from the AWS Daily-Hourly - Daily Run list.

For the monthly Detailed Billing report with resources and tags

Edit online

Procedure

  1. Navigate to DataLink and select the Default Agent.
  2. Select to edit the AWS Daily-Hourly - Monthly Run connector.
  3. Scroll down to the Report - Column Mappings section.
  4. Update the entries in the Source column to match those that you configured for the Cost Allocation report above.
  5. Leave Source blank for any unmapped Destination fields.
  6. Save the connector.
  7. In the connector list, click Action, and then click Run Now from the AWS Daily-Hourly - Monthly Run list.

What to do next

Go to Continue your configuration of Public Cloud