SAP
SAP is a comprehensive enterprise resource planning (ERP) and business application platform that provides integrated solutions for managing business operations, finance, human resources, supply chain, procurement, manufacturing, and customer relationships across organizations of all sizes.
| Category | Other |
| Direction | Query source |
| Sign-in | OAuth Client Credentials |
| Query languages | SQLite |
| Website | sap.com |
Before you start
Huntbase signs in to SAP with OAuth Client Credentials. Create the credential in SAP first, then keep it to hand for the Connect step.
- In the SAP Business Technology Platform subaccount that holds your SAP Integration Suite subscription, create a service instance for the
Process Integration Runtimeservice with theapiservice plan. - When you configure the instance parameters, select the
Client Credentialsgrant type and assign theWorkspacePackagesReadrole. - Create a service key of type
ClientId/Secretfor that service instance. - Open the service key and copy the
url,tokenurl,clientidandclientsecretvalues from itsoauthsection.
Permissions:
WorkspacePackagesRead
- Each connection covers a single SAP Cloud Integration tenant.
For the vendor's own instructions, see SAP Cloud Integration OData API documentation.
Use a dedicated, read-only credential for Huntbase where the product allows it. Huntbase only needs to read.
Connect SAP
- Go to Connections and click New connection, or click New connection on the SAP product page.
- On Product, pick SAP 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 lives:
| Field | Required | Notes |
|---|---|---|
| Base URL | Yes | The url attribute in the oauth section of the service key, such as https://xxxxxxxxxx.it-cpi000.cfapps.xx00-000.hana.ondemand.com. |
| Token URL | Yes | The tokenurl attribute in the oauth section of the service key. It ends in /oauth/token. |
| Client ID | Yes | The clientid attribute in the oauth section of the service key. |
| Maximum Concurrency | No | |
| Request Timeout | No | A duration such as 30s. Valid units are ns, us, ms, s, m and h. The default is 30s. |
Credentials
The only Method is OAuth Client Credentials. Enter a Credential label (for example Production), then fill in:
| Field | Required | Notes |
|---|---|---|
| Client Secret | Yes | Secret — not shown again after you save it. |
Query it
Once connected, SAP 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