Skip to main content

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.

CategoryOther
DirectionQuery source
Sign-inOAuth Client Credentials
Query languagesSQLite
Websitesap.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.

  1. In the SAP Business Technology Platform subaccount that holds your SAP Integration Suite subscription, create a service instance for the Process Integration Runtime service with the api service plan.
  2. When you configure the instance parameters, select the Client Credentials grant type and assign the WorkspacePackagesRead role.
  3. Create a service key of type ClientId/Secret for that service instance.
  4. Open the service key and copy the url, tokenurl, clientid and clientsecret values from its oauth section.

Permissions:

  • WorkspacePackagesRead
Watch out for
  • Each connection covers a single SAP Cloud Integration tenant.

For the vendor's own instructions, see SAP Cloud Integration OData API documentation.

tip

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

Connect SAP​

  1. Go to Connections and click New connection, or click New connection on the SAP product page.
  2. On Product, pick SAP 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 lives:

FieldRequiredNotes
Base URLYesThe url attribute in the oauth section of the service key, such as https://xxxxxxxxxx.it-cpi000.cfapps.xx00-000.hana.ondemand.com.
Token URLYesThe tokenurl attribute in the oauth section of the service key. It ends in /oauth/token.
Client IDYesThe clientid attribute in the oauth section of the service key.
Maximum ConcurrencyNo
Request TimeoutNoA 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:

FieldRequiredNotes
Client SecretYesSecret — 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:

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

Next steps​