Link Search Menu Expand Document

Table of Contents

AWS Connector

The AWS Connector can be used to retrieve usage data from AWS Bucket storage, as well as maintain the product portfolio and accompanying pricing rules. The connector uses AWS’s Cost and Usage report for usage information and the Price List API for product and pricing information.

The usage is retrieved daily and the connector can be used to create a mapping between the AWS account IDs and the customers you have configured in CloudBIlling.

AWS Reporting setup guide

For CloudBilling, in order to retrieve all the required data from AWS Cloud on your customers and generate corresponding invoices, a bucket with cost and usage reporting is required. Mentioned below are the steps required to set up cost and usage reporting in AWS.

Step 1. Setting up the S3 Bucket to store the reports.

The first step required to provide the usage data is to set the bucket where the required usage reports will be dropped.

  • Go to https://console.aws.amazon.com/s3 or navigate to S3 bucket storage as shown in the image below.

Figure AWS Connector 1: Navigation menu with S3 highlighted

Figure AWS Connector 1: Navigation menu with S3 highlighted

  • Click on ‘Create Bucket’.
  • Follow the steps to setup a new S3 bucket. The settings for the bucket can be left as-is.

Step 2. Enabling the reports in AWS.

  • Go to https://console.aws.amazon.com/billing/home (can be accessed through the dropdown option ‘My Billing Dashboard’ beside your profile username on the menu).
  • Click on Cost & Usage Report on the navigation pane on the left.
  • Click ‘Create report’ and follow the steps outlined below.

Step 1. On this page, you are required to give your report a name. Any name can be used for the report. All the other settings can be left untouched (see image below).

Figure AWS Connector 2: Creating Cost and Usage report step 1

Figure AWS Connector 2: Creating Cost and Usage report step 1

Step 2.

  • Give a report path prefix. Any prefix name can be used.
  • Set report data time granularity to daily.
  • Set Compression type to ‘ZIP’.

Figure AWS Connector 3: Creating Cost and Usage report step 2

Figure AWS Connector 2: Creating Cost and Usage report step 2

Step 3.

  • Review the settings of your report and press “Create”

Step 3. Creating a security policy.

  • Go to https://console.aws.amazon.com/iam (can be accessed through the dropdown option ‘My Security Credentials’ beside your profile username on the menu).

Figure AWS Connector 4: Security Credentials Navigation

Figure AWS Connector 4: Security Credentials Navigation

  • Click on ‘Policies’ on the left-hand side navigation pane.

Figure AWS Connector 5: Navigating to Policies in security menu

Figure AWS Connector 5: Navigating to Policies in security menu

  • Click on ‘Create policy
  • Select the Service ‘S3’

Figure AWS Connector 6: Selecting the S3

Figure AWS Connector 6: Selecting the S3

  • Under ‘Access level’, open the ‘list’ actions and select ‘ListBucket’
  • Open the ‘read’ actions and select ‘GetObject’

Figure AWS Connector 7: Selecting the policy actions

Figure AWS Connector 7: Selecting the policy actions

  • Under resources, you can add your bucket ARN. You can find your bucket ARN (Amazon Resource Name) when going to S3, choosing the bucket you want to restrict your policy for, and going to its properties. In case you want this policy to be applicable to all buckets, check ‘Any’ box.

Figure AWS Connector 8: Obtaining the bucket ARN

Figure AWS Connector 8: Obtaining the bucket ARN

  • For the objects, you can also specify where the report is located using Uniform Resource Identifier (URI). You can obtain URI by going to the same section as specified above and then choosing the folder or object that you need. In that directory, you can press the ‘Copy URI’ button. Otherwise, check ‘Any’ box in case you want this policy to access every object inside the bucket.

Figure AWS Connector 9: Obtaining the object URI

Figure AWS Connector 9: Obtaining the object URI

  • Click ‘Next’
  • Give your policy a name and description. You will asign this policy to a user group that you create on the next step.

You can see these steps performed in a figure below:

Figure AWS Connector 10: Policy creation step-by-step guide

Figure AWS Connector 10: Policy creation step-by-step guide

Step 4. Creating a user group.

  • Navigate to https://console.aws.amazon.com/iam or via the dropdown option ‘My Security Credentials’ beside your profile username on the menu (as presented on the Step 3, figure 4).
  • Click on ‘User Groups’ on the left-hand side navigation pane.

Figure AWS Connector 11: Navigating to user groups

Figure AWS Connector 11: Navigating to user groups

  • Click on ‘Create New Group’ on the right side of the page
  • Give the group a convenient name of your preference.

Figure AWS Connector 12: Giving your user group a name

Figure AWS Connector 12: Giving your user group a name

  • Select the following permissions on this screen. Use the Search box to search for them:
    1. AWSPriceListServiceFullAccess.
    2. The policy that you have created in Step 3.

Figure AWS Connector 13: Adding required policies to your user group

Figure AWS Connector 13: Adding required policies to your user group

  • Click on ‘create group’ at the bottom of the page

Step 5. Creating a user.

  • Navigate to https://console.aws.amazon.com/iam or via the dropdown option ‘My Security Credentials’ beside your profile username on the menu (as presented on the Step 3, figure 4).
  • Click on ‘Users’ on the left-hand side navigation panel.

Figure AWS Connector 14: Navigating to users

Figure AWS Connector 14: Navigating to users groups

  • Click ‘Create user’
  • Give the user a name, say, ‘cloudbilling-biller’
  • Click ‘Next’
  • Select the group that you created for the purpose of CloudBilling.
  • Click ‘Next’
  • Set any tags, if required.
  • Click ‘Next: Review’
  • Click ‘Create user’ if the settings are in order.

Step 6. Creating the user security keys.

  • Navigate to https://console.aws.amazon.com/iam or via the dropdown option ‘My Security Credentials’ beside your profile username on the menu (as presented on the Step 3, figure 4).
  • Click on ‘Users’ on the left-hand side navigation pane.

Figure AWS Connector 15: Navigating to users

Figure AWS Connector 15: Navigating to users

  • Under the ‘User name’ column in the table, click on the user that you just created, ‘cloudbilling-biller’ in this case.
  • The list of permissions assigned to the user show up underneath the Permissions tab.
  • Click on the ‘Security credentials’ tab.
  • Under the ‘Access Keys’ section, click on ‘Create access key.
  • On the Step 1, select use case ‘Third-party software’ and check ‘I understand’ box.

Figure AWS Connector 16: Creating Access Key. Step 1

Figure AWS Connector 16: Creating Access Key. Step 1

  • On the Step 2, add your preferred description tags. These tags are not necessary.
  • Click ‘Create access key’.You will be redirected to a page with your freshly created Access key.
  • Please make sure to click on the ‘Download .csv file’ button to keep a copy of the keys with you. You will need it later on while configuring your AWS account on CloudBilling! The file should download as ‘accessKeys.csv’. You will need that key when creating an account in CloudBilling.

Figure AWS Connector 17: Downloading Access Key

Figure AWS Connector 17: Downloading Access Key

Step 7 (Optional). Enabling Tags

AWS offers you the ability to tag individual resources. A tag is a label that you assign to an AWS resource. Each tag consists of a key and an optional value, both of which you define. Tags enable you to categorize your AWS resources in different ways, for example, by purpose, owner, or environment. This is useful when you have many resources of the same type—you can quickly identify a specific resource based on the tags you’ve assigned to it. For example, you could define a set of tags for your account’s Amazon EC2 instances that helps you track each instance’s owner and stack level. Once you have assigned the required tags, activate these tags by navigating to the Cost allocation tags section.

Figure AWS Connector 18: Navigating to cost allocation tags

Figure AWS Connector 18: Navigating to cost allocation tags

CloudBilling configuration guide

Step 1. Configuring the accounts

To setup the CloudBilling AWS connector • In the menu bar go to Connectors • Under Amazon Web Services, click on ‘Connector Settings’ • Click ‘Add’

Figure AWS Connector 19: Navigating to AWS connector settings

Figure AWS Connector 19: Navigating to AWS connector settings

Fill in the account details you configured in the previous steps:

  • Name: Give your account a name of your preference. Usually it corresponds to the name of your customer
  • Access Key: Use the access key ID that you created in Step 6.
  • Secret Key: Use the secret key ID that you created in Step 6.
  • Bucket Name: Use the name of the bucket that you created
  • Region: Select the region indicated near your bucket name. You can find it when accessing the S3 menu (search S3 in AWS console or us this link).
  • Report Prefix: Use the report prefix you gave it in Step 2.
  • Report Name: Use the name of the report you provided in Step 2.

Figure AWS Connector 20: Adding a new AWS account in CloudBilling

Figure AWS Connector 20: Adding a new AWS account in CloudBilling

After filling up the information on your bucket, you can see a checkbox “Enable sharing of reservations”. This setting passes the discounts to CloudBilling users in case the reservations are shared in AWS (see examples below). It is recommended to match this setting with the settings you have in your account. You can access these settings by going to your account settings and selecting the ‘billing preferences’ tab: Figure AWS Connector 21: Reservation sharing settings

Figure AWS Connector 21: Reservation sharing settings

Here are some examples on how this setting might affect the billing of your customers:

  • If reservation sharing is on in the AWS Console as well as in CloudBilling, the discounts from AWS are always passed on to the customers
  • If reservation sharing is turned on in the AWS Console but not in CloudBilling, your customers are sharing reservations in the management console but not in CloudBilling. That means that in case a customer is using another customer’s reservation which has a discount, the discount is passed on to the reseller, but not to the customer. Only if the payer account is also a user account, the customer is eligible for the discount.

In the table below the input fields, you can see 13 product categories that are retrieved from AWS. These categories can be set up to work in different ways.

Figure AWS Connector 21: Mapping the products and customers

Figure AWS Connector 21: Mapping the products and customers

  1. Credit – Any credits that AWS applied to your bill. Be aware that AWS might update reports after they have been finalized if AWS applies a credit to your account for the month after finalizing your bill. That means that the credit may appear in Cost and Usage report during the next billing period.
  2. DiscountedUsage – The rate for any instances for which you had Reserved Instance (RI) benefits. If the account corresponding to the DiscountedUsage is the one who purchased the RI as well, it gets charged the LineItemUnblendedRate otherwise, the PublicOnDemandRate is used.
  3. Fee – Any upfront annual fee that you paid for subscriptions. For example, the upfront fee that you paid for an All Upfront RI or a Partial Upfront RI.
  4. Refund – Negative charges that AWS refunded money to you for. Check the Description column for details. AWS might update reports after they have been finalized if AWS applies a refund to your account for the month after finalizing your bill.
  5. RIFee – The monthly recurring fee for Reserved Instances subscriptions. For example, the recurring fee for Partial Upfront RIs and No Upfront RIs that you pay every month.
  6. Tax – Any taxes that AWS applied to your bill: for example, VAT or US sales tax.
  7. Usage – Any usage that is charged at On-Demand Instance rates.
  8. SavingsPlanUpfrontFee – Any upfront fee you paid for your Savings Plans. For example, the upfront fee that you paid for an All Upfront Savings Plan or a Partial Upfront Savings Plan. CloudBilling assigns the fee to whatever account it is reported on, so the using account.
  9. SavingsPlanRecurringFee – the monthly recurring fee for your Savings Plans-related subscriptions. For example, the recurring monthly fee for a Partial Upfront Savings Plan or No Upfront Savings Plan. CloudBilling assigns the fee to whatever account it is reported on, so the using account.
  10. SavingsPlanCoveredUsage – Any on-demand cost that is covered by your Savings Plan. Savings Plan covered usage line items are offset by the corresponding Savings Plan negation items. CloudBilling assigns the usage to whatever account it is reported on, so the using account.
  11. SavingsPlanNegation – When the Savings Plans discount is applied, this line item is present and contains negative costs (discounts). This enables you to find the net cost after Savings Plans discounts, using the total sum of the Unblended Cost. CloudBilling assigns the negation to the using account if and only if that account is also the account that purchased the SavingsPlan, otherwise it is assigned to the master account. This is determined using the SavingsPlanARN.
  12. BundledDiscount - The bundled discount applied to the line item. A bundled discount is a usage-based discount that provides free or discounted usage of a service or feature based on the usage of another service or feature.
  13. SPP Discount - Amazon partner discount. This discount is usually applied to the CSP as a partnership program promotion.

All of these product types can be mapped in different manners.

For Customer Mapping:

  • As Reported – The purchase would map to the customer as reported in the billing report. That means that if you have a purchase, it will be assigned to the customer indicated in the report and not the master account of the bucket.
  • Map to Master – Instead of mapping to the actual customer reported in the report, you can also map the LineItemType to the master account. Commonly used in the case of Tax and/or Credit, where the purchase normally shouldn’t show up on a customer’s invoice.

For Product Mapping

  • As Reported – The purchase would map to the product as reported in the billing report. That means that if you have a purchase, for example, a credit for AWS Reserved instances linux x64 machine, you will have the negative value for that product on the invoice because of it.
  • Use Type – These are used for LineItemTypes that do not have a corresponding SKU in the billing report. For example, if you set Credit purchases of the product from the example above to Use Type, they will be presented on the invoice as “Credit”, and not “AWS Reserved instances linux x64 machine”.

Figure AWS Connector 22: Do not forget the 'Enabled' checkbox

Figure AWS Connector 22: Do not forget the 'Enabled' checkbox

After you are finished, you can save your new account by clicking the save button.

Step 2. Enabling the AWS Products and Pricing Maintenance

After you have created your first AWS connector account in CloudBilling, go to ‘Connectors’ and under Amazon Web Services, press ‘Settings’.

  1. Check ‘Perform AWS Product and Pricing Maintenance’
  2. Select the product cluster, under which the new AWS products will be created
  3. Select the customer cluster, to which the new AWS pricing rules will be applicable
  4. Select the default markup. This will be the markup you apply to every customer. For example, the value of 15 will bill your customer extra 15% of the product cost. Markup can be also edited for a specific customer or a product. See section below on how it can be done
  5. Input the required billing output tags. These are usually put by our team and used for the invoices and exports.
  6. In the field for ‘Stop processing reports after day’, you can set up the number of days after which the report is not being retrieved anymore. For example, if you set number 9, on the 9th of October, the report for September will not be updated anymore.

Figure AWS Connector 23: Setting up the maintenance

Figure AWS Connector 23: Setting up the maintenance

Step 3. Mapping your customers

Within 24 hours CloudBilling will start retrieving the customers corresponding to your AWS account configuration. Once that happens, you need to map your AWS customers to CloudBilling customers.

  • In the menu bar go to Connectors
  • Click on ‘Customer Mapping’ under Amazon Web Services connector
  • Make sure you have CloudBilling customer entities created. Use our documentation in case you have difficulties creating new customers.
  • Map the AWS account IDs to CloudBilling customers and click on Approve one by one. Within 24 hours of successfully completing this step, you should see AWS usage information flow into your CloudBilling account in the form of purchases.

Figure AWS Connector 24: Mapping the CloudBilling and AWS customers

Figure AWS Connector 24: Mapping the CloudBilling and AWS customers

Step 4. Setting up the markups

There are multiple ways in which you can set the markups for your customers:

Setting up a markup for all the customers

In order to set up a global markup for AWS, go to ‘Connectors’ tab. Under the AWS, select ‘Settings’. On the right side, you can see the field ‘Default Markup’. In that field, you can write up the markup number. For example, 15 corresponds to a 15% markup for the AWS products.

Figure AWS Connector 25: Setting up a global AWS markup

Figure AWS Connector 25: Setting up a global AWS markup

Setting up a markup for the specific customers

Every customer has a section called ‘Amazon Web Services. Under that section, there is a field called ‘Markup’. If you set the value of that field to 20, 20% markup will be applied to that customer./br/ This field overwrites the default markup that you have set up in the connector settings (see above).

Figure AWS Connector 26: Setting up a customer-specific markup

Figure AWS Connector 26: Setting up a customer-specific markup

Setting up a markup for the specific products and customers

In order to set up a markup for the specific products and to combine it with the specific customer, a new pricing rule must be set up which will override the default markup. You have to override the pricing rule because it is externally managed. Otherwise, if you edit the existing rule, the next connector run will create a new “duplicate” rule leading to double values on the invoice.

The best way to set up this markup is to go to the existing invoice of the customer, identify the markup rule that you need to replace and create a new pricing rule. When setting up a new pricing rule, go to the advanced tab and under ‘ Override Rule’ field, find the rule that needs to be replaced. See how it is done in a demonstration below:

Figure AWS Connector 27: Setting up a pricing rule for a custom markup

Figure AWS Connector 27: Setting up a customer-specific markup


Back to top

Copyright Ⓒ 2023 CloudBilling (Inter8-NL B.V.)