Skip to main content

SAP BTP

SAP Business Technology Platform (SAP BTP) is SAP's comprehensive platform-as-a-service (PaaS) offering that enables enterprises to integrate, extend, and build business applications in the cloud. It serves as a unified environment for application development, integration, data management, analytics, and intelligent technologies across SAP and third-party systems.

CategoryCloud
DirectionQuery source
Sign-inUsername and Password, CIS Service Key, OAuth Client Credentials, Access Token
Query languagesSQLite
Websitesap.com

Before you start​

Huntbase can sign in to SAP BTP with any of these methods: Username and Password, CIS Service Key, OAuth Client Credentials, Access Token. Pick one, create the credential in SAP BTP, then keep it to hand for the Connect step.

Username and Password​

SAP BTP user email and password

  1. Make sure your global account admin has entitled a plan of the SAP Cloud Management service (cis) to your subaccount.
  2. Create a service instance of the SAP Cloud Management service with the central plan. Without a grantType parameter, it uses the Password grant type.
  3. Create a service key for that instance.
  4. From the service key, copy uaa.clientid, uaa.url and endpoints.accounts_service_url, and have the email and password of your SAP BTP user ready.

Permissions:

  • The central service plan of the SAP Cloud Management service.

OAuth Client Credentials​

OAuth 2.0 client ID and client secret (from the CIS service key) used to obtain an access token.

  1. Make sure your global account admin has entitled a plan of the SAP Cloud Management service (cis) to your subaccount.
  2. Create a service instance of the SAP Cloud Management service with the central plan. Pass the parameter {"grantType": "clientCredentials"} when you create it.
  3. Create a service key for that instance.
  4. From the service key, copy uaa.clientid, uaa.clientsecret, uaa.url and endpoints.accounts_service_url.

Permissions:

  • The central service plan of the SAP Cloud Management service.
Watch out for
  • The read-only central-viewer plan supports only the Client Credentials grant type.
  • Instances created without {"grantType": "clientCredentials"} issue only Password grant tokens, so the client ID and secret alone won't work.

For the vendor's own instructions, see SAP Cloud Management service access token documentation.

tip

Use a dedicated, read-only credential for Huntbase where the product allows it. Huntbase only needs to read.

Connect SAP BTP​

  1. Go to Connections and click New connection, or click New connection on the SAP BTP product page.
  2. On Product, pick SAP BTP and choose the Owner.
  3. On Details, give the connection a Name and, optionally, a Description.
  4. On Connect, fill in the settings and credentials described below.
  5. On Verify, review the summary and click Create & check.

For everything else on the setup page — saving a draft, I'll do this later, and what each check result means — see Connections.

Settings​

Where your SAP BTP lives:

FieldRequiredNotes
UsernameNoThe email address you use to sign in to SAP BTP.
CIS Accounts Service URLNoThe endpoints.accounts_service_url value from the service key.
CIS Entitlements Service URLNoThe endpoints.entitlements_service_url value from the service key.
OAuth Client IDNoThe uaa.clientid value from the service key.
OAuth Token URLNoThe uaa.url value from the service key, such as https://<subdomain>.authentication.<region>.hana.ondemand.com. You can leave off /oauth/token.

Credentials​

Choose a Method, enter a Credential label (for example Production), then fill in the fields for that method.

Username and Password​

FieldRequiredNotes
PasswordNoIf two-factor authentication is on, append the current SAP Authenticator passcode to your password. Secret — not shown again after you save it.

CIS Service Key​

FieldRequiredNotes
CIS Service Key PathYesSecret — not shown again after you save it.

OAuth Client Credentials​

FieldRequiredNotes
OAuth Client SecretNoThe uaa.clientsecret value from the service key. Secret — not shown again after you save it.

Access Token​

FieldRequiredNotes
Access TokenNoSecret — not shown again after you save it.

Query it​

Once connected, SAP BTP can serve these languages in a query tab, and Scout can use it when you ask in Auto:

LanguageUse it for
SQLiteSQL across this source and every other connected source.

Next steps​