Import Data Connection to SAP Concur

You can create a connection that allows you to import data from SAP Concur.

Prerequisites

A valid SAP Concur account is required to import data into SAP Analytics Cloud. The user must have Web Services Administrator and Expense User roles assigned in SAP Concur.

To enable the connection, the SAP Concur web admin must generate a Company Request Token under Start of the navigation pathAdministration Next navigation step Company Next navigation step Authentication Next navigation step Company Request TokenEnd of the navigation path using SAP Analytics Cloud’s App ID: 8d70b41a-a89e-4a8a-834a-8399d38bff3e, and record the Company UUID and Company Request Token.

If the Authentication menu is not available, please raise a case in SAP Concur support portal with Case subject: SAP Analytics Cloud to get the Company UUID and Company Request Token.

The Company Request Token is valid for 24 hours only. Make sure you create the Concur Connection in SAP Analytics Cloud within 24 hours or repeat the steps to generate a new one.

For more information, see the Concur API referenceInformation published on SAP site.
Note
  • This data source isn't yet available for datasets.
  • Currently, SAP Analytics Cloud only supports import data from SAP Concur Expense Reports or Expense Entries.
  • The SAP Concur expense entry API doesn't allow filter by date, so the connector cleans and replaces all the data with every scheduled import. Please consider the maximum row limit for data model refresh. For more information, see System Sizing, Tuning, and Limits.
  • The SAP Concur web service API may raise timeout exceptions depending on the server workload.
  • If multi-step approval is used, the field ApproverName reflects only the last approver, but not the history of the workflow.
  • The field ApproverName is only populated for expense reports that are pending approval and reflects the report approver that is currently assigned to the report. All amounts are based on currency conversion rates used by SAP Concur. For currency conversions within the SAP Analytics Cloud dashboard, rates maintained by the customer will be used.

Procedure

  1. From the side navigation, choose Start of the navigation path Connections Next navigation step  (Add Connection)End of the navigation path.
    The Select a data source dialog will appear.
  2. Expand Acquire Data and select SAP Concur.
  3. On the New Concur Connection dialog, do the following:
    1. Enter a name and a description for the new connection.
    2. Enter the data Company UUID and the Company Request Token generated in SAP Concur.
      Refer to the prerequisites above for more information.
  4. Select Create.
    The new connection is now set up and listed on the Connections screen.
  5. If you want to create a model based on this connection, see Import Data to Your Model.