Skip to main content

Ripple – Azure EA Cost Data Integration

How to Connect Azure EA Cost Data Using Azure Storage

Written by Alphaus Support Team
Updated today

Overview

This guide walks you through the steps to configure daily exports of Azure EA (Enterprise Agreement) Cost Management data to Azure Blob Storage, and to grant Alphaus read access to those files.

Important Notes Before proceeding, make sure you have completed the Azure EA Integration steps first.


Step 1. Create an Azure Storage Account

  1. Open the Azure Portal

  2. Go to Storage accounts > Create

  3. Select your Subscription and Resource group

  4. Configure the following settings:

    1. Storage account name:

      • Must be globally unique

      • 3–24 characters

      • Lowercase alphanumeric characters only

    2. Region: Use the same region as your primary workload for lower latency

    3. Performance: Standard (recommended for cost export use)

    4. Redundancy: Select based on your requirements (e.g., LRS, GRS)

  5. Click Create


Step 2: Create a Container and Configure Read Permissions

  1. Open the Storage account you created in Step 1

  2. Go to Data storage > Containers

  3. Click + Container

  4. Configure the following:

    • Name: e.g., cost-exports

    • Public access level: Private

  5. Click Create


Step 3. Create a Cost Management Export and Assign Permissions

How to Create the Export

  1. In the Azure Portal, go to Cost Management + Billing > Exports

  2. Select the appropriate scope (e.g., Subscription, Resource group, or Management group)

  3. Click + Add and select the template Cost and usage (actual + amortized)

  4. Configure the export settings:

    • Frequency: Daily (exports month-to-date data on a daily basis)

    • Dataset version: 2023-05-01

    • Datasets tab – Export prefix: Specify a path prefix if needed (e.g., exports or alphaus)

    • Destination tab:

      • Storage type: Azure blob storage

      • Storage account: Select the account created in Step 1

      • Container: Select the container created in Step 2

      • Format: CSV

      • Compression: Gzip

      • File partitioning: Yes

      • Overwrite data: Yes

  5. Click Create

3-A. Grant Write Permission to the Cost Management Service Principal

Grant Cost Management write access to the Storage account so it can write exports.

  1. Go to Storage account > Access Control (IAM) > + Add > Add role assignment

  2. Set the following:

    • Role: Storage Blob Data Contributor

    • Assign access to: User, group, or service principal

  3. Under Select members, search for and select Cost Management

  4. Click Review + assign

3-B. Grant Read Permission to Alphaus

Grant Alphaus read access to the Storage account so it can retrieve the exported files.

  1. Go to Storage account > Access Control (IAM) > Add role assignment

  2. Set the following:

    • Role: Storage Blob Data Reader

  3. Under Select members, search for and select the App Registration connected to Alphaus

  4. Click Review + assign


Step 4. Run the Export

  1. After creating the export, either wait for the scheduled export to run, or click Run now to trigger a manual export

  2. The first export may take several hours depending on data volume


Step 5. Verify the Export Output

  1. Go to Storage account > Containers and open the target container

  2. Confirm that exported files are present in the following directory structure:

[directory]/[export-name]/[date]/[export-name]_[guid].csv.gz

Example:

ea-exports/daily-usage/20260115/daily-usage_abc123.csv.gz

Appendix: Cost Data Types

Data Type

Description

Cost and usage details (actual)

Standard usage and purchase billing

Cost and usage details (amortized)

Amortised costs for reservations (RI) and Savings Plans

Cost and usage details (FOCUS)

FinOps Open Cost and Usage Specification (FOCUS) format — combines actual + amortized; may reduce data processing, storage, and compute costs. Note: Management group scope is not supported

Cost and usage details (usage only)

Usage data only — new creation not available, but existing exports are still supported

Additional export types available: Price sheet, Reservation details, Reservation recommendations, Reservation transactions.


Need More Help?

If any errors occur during the process or if you have any questions, please reach out to us:

Did this answer your question?