Import Data Connection to OData Services

You can create a connection that allows you to import data from both on-premise and cloud data sources using generic OData services. It is possible to request a customized OData data source solution.

Prerequisites

You have completed ONE of the following setup options:

Context

Procedure

  1. Go to Start of the navigation path (Main Menu) Next navigation step  Connection Next navigation step Connections Next navigation step  (Add Connection)End of the navigation path.
    The Select a datasource dialog will appear.
  2. Expand Acquire Data and select OData Services.
  3. In the New OData Services Connection dialog, enter a name for the connection.
  4. You can select the following options:
    • Connect to an On-Premise OData service: Make sure to complete the prerequisites before connecting to an On-Premise source using a generic OData driver. If this option is not selected, the driver will connect to cloud OData data sources.
    • Connect to an SAP OData service: When you select this option, specific SAP metadata is respected. This metadata specifies default behaviors based on SAP OData services guidelines; for example, filterable and sortable are by default true, if not claimed to be false, and support basic filter operators. For more information see SAP Annotations for OData Version 2.0Information published on SAP site.
  5. If you are connecting to an on-premise OData service, select the Location of your cloud connector from the list.
  6. Enter the Data Service URL published during your configuration.
  7. Select the authentication type.
    The following authentication types are available:
    • Basic Authentication
    • OAuth 2.0 Client Credentials
    • OAuth 2.0 Authorization Code
    • No Authentication
  8. Provide the authentication details based on the authentication type you selected:
    • For Basic Authentication, enter the User Name and Password of the user you want to import data from.
    • For OAuth 2.0 Client Credentials, enter the OAuth Client ID, Secret, Token URL and Scope (if required) of the application you want to access.
    • For OAuth 2.0 Authorization Code, enter the OAuth Client ID, Secret, Token URL, Authorization URL and Scope (if required) of the application you want to access. Before the connection is created, you will be redirected to the Authorization URL of your application where you can authorize SAP Analytics Cloud to access your data.
  9. Choose Create.
    The new connection is added to the list of connections on the Connections screen.
  10. If you want to create a model based on this connection, see Importing OData Services Data to a New or Existing Model.