Documentation
APIs & integrations

APIs & integrations

With a rich set of APIs, Cube can power and deliver data to all kinds of data applications.

Data APIs are used to run queries against the data model. Despite varying protocols and query formats, all data APIs share common querying concepts.

Also, there are management APIs to control Cube deployments externally.

Data APIs

A few rules of thumb to help you choose an API:

Data modeling

Support for data modeling features differ across APIs, integrations, and visualization tools. Some of the features with partial support are listed below:

Feature✅ Supported in❌ Not supported in
HierarchiesMicrosoft Power BI via the DAX API
Cube Cloud for Excel
Cube Cloud for Sheets
Tableau via Semantic Layer Sync
All other tools
FoldersMicrosoft Power BI via the DAX API
Cube Cloud for Excel
Cube Cloud for Sheets
Tableau via Semantic Layer Sync
All other tools

Authentication methods

Support for authentication methods differ across APIs, integrations, and visualization tools:

Method✅ Supported in
User name and passwordDAX API
MDX API
Semantic Layer Sync
SQL API
Identity providerCube Cloud for Excel
Cube Cloud for Sheets
Access tokenREST API
GraphQL API
AI API

Management APIs

In case you'd like Cube to work with data orchestration tools and let them push changes from upstream data sources to Cube, explore the Orchestration API.