Overview

If you are using a data warehouse or a BI platform, you might want to ingest the plan data in Toolio to these destinations. Toolio allows setting up periodic exports of your plan data to destinations like AWS S3 or Azure Blob.

Schema

Toolio's exports are generated in the csv format. Please see a sample plan export here.

The plan export will contain information at the lowest level of granularity, i.e. at the Cartesian combination of all scenario, time and attributes. For each possible combination, there will be a list of metrics.

The fields included in the export will fall in one of these 4 buckets

Field Type

Overview

Scenario

Scenario column will either be plan (i.e. master scenario on Toolio) or the name of the scenario that the metrics pertain to.

Time

Time will either be year, week headers or year, month headers depending on the calendar configuration.

Attributes

This will be a cartesian combination of all the planning attributes.

Metrics

These will be all the metrics exposed in your Toolio account. Please see the full list of metrics here.

File Naming Convention

Toolio exports follow the convention below:

toolio_{module_name}_{yyyymmdd_hhMM).csv

Below is an example plan export filename:

toolio_mp_20210901_1949.csv

Destinations

We currently support AWS S3 and Azure Blob as possible destinations for the plan data. We are constantly adding new destinations, so if you need an unsupported destination, please reach out to your Customer Success Manager.

AWS Destination

Please configure an S3 bucket and provide the following information to your Customer Success Manager:

  • Bucket Name

  • Access Key Id (create an IAM user)

  • Secret Access Key (create an IAM user)

Related Articles

Did this answer your question?