Display Azure billing data

The billing dashboard scripts obtain information from cloud providers. To use these scripts, configure programmatic access to billing in the cloud providers. And you will need to install the billing packages and configure and the scripts so they can obtain billing data and add it to Abiquo. After you configure billing widgets, the platform may take up to 2 days to display data in the Estimated bill section of the dashboard. 

Install and configure billing packages

You will need a server with MariaDB running with access to the Abiquo API, Abiquo database, and public cloud providers. 

1. Install the "abiquo-billing-arm" package

2. Create the local billing databases for Azure and import schema

   mysql -e "create database arm_billing"
   mysql -h -p -u arm_billing < /opt/abiquo-billing-arm/lib/app/schema.sql

3. Grant privileges to a user for the local billing databases

4. Configure the billing packages, edit the config.yml file. By default for Azure, this is file is located at /opt/abiquo-billing-arm/config/config.yml and the following example file shows the values that you must replace.

   abiquo_database:
     host: 10.10.10.36
     user: user
     password: password
     port: 3306
   billing_database:
     host: 10.10.10.38
     user: user
     password: password
     port: 3306
   abiquo:
     api_url: http://10.10.10.32/api
     user: admin
     password: xabiquo
     seed: 

   
   Notes: 

1. The billing database is the one you created in the above steps, so it can be hosted on localhost

2. "seed" is the name of a custom seed that encrypts the Abiquo database. Copy the custom seed into the same directory as the config.yml file for each provider

5. For the Abiquo database, grant select privileges from this host to the abiquo_database user that will run the billing scripts 

Configure CSP accounts

If your tenants use a CSP account, do the following steps:

1. Create a CSP billing configuration file at the following location:

   /opt/abiquo-billing-arm/lib/app/config/csp.yml

2. Add the billing credentials for the CSP subscription used by each tenant. Create a unique random string to use as a tenant key for each entry, which in this example is "4caba317".

    4caba317:
     tenantId:
     clientId:
     clientSecret: ''
     accessToken: ''
     refreshToken: ''
     resource: 'https://api.partnercenter.microsoft.com' 

3. In Abiquo, edit the enterprise and create the following enterprise properties:
   1. "OfferDurableID" with the value of tenant key in the format "CSP_ID_[UUID_key_from_csp.yml_file]". So from the above example, for the tenant with ID 4caba317, this would be CSP_ID_4caba317.
   2. "azurecompute-arm_discount" with the value of the discount applied by Azure to partner providers. To find the PVP, the values on the bills must be divided by (1- CSP_discount). The default is 0.15.
   3. "Currency", the default is "USD"
   4. "Locale", the default is "en-US"
   5. "RegionInfo", the default is "US", which is a two digit ISO code representing the country where you purchased the subscription
4. For the customers of the reseller, edit the enterprise and create the following properties:
   
   1. "azurecompute-arm_price_factor" with the value of the discount or markup applied by the partner to the end user. The default value is 1.

Configure standard Azure accounts

If your tenant has a standard Azure account, do the following steps first.

1. Grant access to billing records to the app role created in Azure for your account
2. Obtain the OfferDurableID from the offer agreement for your enterprise by going to Subscriptions → select your subscription → Overview and copying the Offer ID
   
3. Also obtain the Currency, Locale, and RegionInfo. 
4. In Abiquo, create the following enterprise properties:
   1. "OfferDurableID" with the value from your subscription, e.g., "MS-AZR-0003P"
   2. "Currency", the default is "USD"
   3. "Locale", the default is "en-US"
   1. "RegionInfo", the default is "US", which is a two digit ISO code representing the country where you purchased the subscription
5. "azurecompute-arm_price_factor" with the value of the provider discount or markup applied by the partner to the end user. The default value is 1.

Complete user configuration in Abiquo

1. In Abiquo, check that the Abiquo API user has the Manage bills privilege
2. Assign Abiquo users the privileges to Display hybrid dashboard tab, View bills, and optionally to Display VM cost view widget (hybrid tab). See Configure dashboard display