Connection String for SAP OData


This page describes how to specify a connection string for an SAP OData data source. 

Entries into the Sensitive Part field will be stored encrypted in Salesforce. If you want to secure the username also, include it in the field separated by a semi-colon.

Overcast connects to SAP OData web services using a custom adapter to handle the SAP specific parameters.


Format

Enter the following text into the Connection String field

URI=<full uri to service> Username=<username> param.<uri param name>=<param value> header.<custom header name>=<header value> RequireCsrfToken=<true|false> timeout=<timeout value(sec)>

Enter the following text into the Sensitive Part field

Password=<password>

 

Sample - Connect to SAP Order Service

Enter the following text into the Connection String field

URI=https://sap.mycompany.com/sap/opu/odata/sap/lord_odata_order_srv/ Username=myusername param.sap-language=EN param.sap-client=100 RequireCsrfToken=true timeout=300

Enter the following text into the Sensitive Part field

Password=mypassword

 

When entering any password that uses whitespace, it should be enclosed in double quotes, i.e., Password="my password";
All keys are case-insensitive.

 

Parameter Keys

Key Description Required
URI The full URI to the SAP OData service. Yes
Username Username No
Password Password No
header This key allows adding API specific request headers. For example, setting the language with header.sap-language=DE will add the HTTP request header to sap-language:DE. No
param This key allows adding API specific request headers. For example, setting the client with param.sap-client=100 will add the URL parameter to sap-client=100. No
RequireCsrfToken Specify true if the SAP OData API requires x-csrf-token. Accepts “true”, “false”. Defaults to “false”. No
Timeout Specify the timespan in seconds (sec) to wait before the SAP OData request times out. Defaults to 100. No
PageSize PageSize can be used to reduce the back-end's load by paging with the specified page size. The parameter will be ignored when other paging parameters are specified on real-time scenario. No


 

1. Go to the Connection Strings tab and select the New button.

 

2. Enter a Connection String Name and select "OData" for Connection Type. Enter your Connection String and its Sensitive Part as described above, and select Save. Description and Named Credential are optional.

 

3. Select Check to validate your connection. A green checked circle will appear once a successful connection is established.