Skip to main content

SAP Analytics Cloud (SAC)

ERPL-Web reads SAP Analytics Cloud models and stories directly from DuckDB SQL. Authenticate once with OAuth2, then list, describe, and query your SAC assets.

Authenticate​

Create a sac secret with an OAuth2 client provisioned in your SAC tenant.

CREATE SECRET sac (
  TYPE sac,
  PROVIDER oauth2,
  tenant_name 'mytenant',
  region 'eu10'
);

The OAuth2 flow refreshes tokens automatically — you do not need to wire access tokens by hand.

Discover assets​

List the models and stories in your tenant:

SELECT * FROM sac_show_models();
SELECT * FROM sac_show_stories();

Describe a model or story​

Pull the full metadata for a specific asset by ID:

SELECT * FROM sac_describe_model('YOUR_MODEL_ID');
SELECT * FROM sac_describe_story('YOUR_STORY_ID');