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.
| Category | Cloud |
| Direction | Query source |
| Sign-in | Username and Password, CIS Service Key, OAuth Client Credentials, Access Token |
| Query languages | SQLite |
| Website | sap.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
- Make sure your global account admin has entitled a plan of the SAP Cloud Management service (
cis) to your subaccount. - Create a service instance of the SAP Cloud Management service with the
centralplan. Without agrantTypeparameter, it uses the Password grant type. - Create a service key for that instance.
- From the service key, copy
uaa.clientid,uaa.urlandendpoints.accounts_service_url, and have the email and password of your SAP BTP user ready.
Permissions:
- The
centralservice 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.
- Make sure your global account admin has entitled a plan of the SAP Cloud Management service (
cis) to your subaccount. - Create a service instance of the SAP Cloud Management service with the
centralplan. Pass the parameter{"grantType": "clientCredentials"}when you create it. - Create a service key for that instance.
- From the service key, copy
uaa.clientid,uaa.clientsecret,uaa.urlandendpoints.accounts_service_url.
Permissions:
- The
centralservice plan of the SAP Cloud Management service.
- The read-only
central-viewerplan 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.
Use a dedicated, read-only credential for Huntbase where the product allows it. Huntbase only needs to read.
Connect SAP BTP
- Go to Connections and click New connection, or click New connection on the SAP BTP product page.
- On Product, pick SAP BTP and choose the Owner.
- On Details, give the connection a Name and, optionally, a Description.
- On Connect, fill in the settings and credentials described below.
- 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:
| Field | Required | Notes |
|---|---|---|
| Username | No | The email address you use to sign in to SAP BTP. |
| CIS Accounts Service URL | No | The endpoints.accounts_service_url value from the service key. |
| CIS Entitlements Service URL | No | The endpoints.entitlements_service_url value from the service key. |
| OAuth Client ID | No | The uaa.clientid value from the service key. |
| OAuth Token URL | No | The 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
| Field | Required | Notes |
|---|---|---|
| Password | No | If 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
| Field | Required | Notes |
|---|---|---|
| CIS Service Key Path | Yes | Secret — not shown again after you save it. |
OAuth Client Credentials
| Field | Required | Notes |
|---|---|---|
| OAuth Client Secret | No | The uaa.clientsecret value from the service key. Secret — not shown again after you save it. |
Access Token
| Field | Required | Notes |
|---|---|---|
| Access Token | No | Secret — 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:
| Language | Use it for |
|---|---|
| SQLite | SQL across this source and every other connected source. |
Next steps
- Connections — health, credentials and settings after you connect
- Query languages — syntax, parameters and time ranges
- Chatting with Scout — ask questions without writing a query
- All integrations — the rest of the catalog