SAP Datasphere Sources > Before you begin > Create a connection
  

Create a connection

Create an SAP Datasphere connection object in Administrator with the connection details of the SAP Datasphere source system.
    1In Administrator, select Connections.
    2Click New Connection.
    3Enter the following connection details:
    Property
    Description
    Connection Name
    Name of the connection.
    Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
    Maximum length is 255 characters.
    Description
    Description of the connection. Maximum length is 4000 characters.
    Runtime Environment
    The name of the runtime environment where you want to run tasks.
    Select a Secure Agent, Hosted Agent, serverless, or elastic runtime environment.
    Service Type
    The service type of the SAP OData V4 service endpoint to which you want to connect.
    Select one of the following service types from the list:
    • - Default. Connects to a specific SAP service.
    • - SAP Gateway Catalog. Connects to the SAP catalog service that provides a list of all available services on SAP Gateway.
    Default is Default.
    Service URL
    The service URL for the selected application type and service type.
    Enter the service URL in the following format depending on the selected application type and service type:
    • - For the SAP Datasphere application type and the Default service type:
    • https://<Host name of the SAP server>/api/v1/dwc/consumption/relational/<Space name of SAP Datasphere>/<Asset name of SAP Datasphere>/
    • - For the SAP Datasphere application type and the SAP Gateway Catalog service type:
    • https://<Host name of the SAP server>/api/v1/dwc/catalog/
    • - For the SAP S/4Hana application type and the Default service type:
    • http://<Host name of the SAP server>:<Port number>/sap/opu/odata4/sap/<Service name>/<Path of the service>/<version number>/
    • - For the SAP S/4Hana application type and the SAP Gateway Catalog service type:
    • http://<Host name of the SAP server>:<Port number>/sap/opu/odata4/iwfnd/config/default/iwfnd/<Catalog service name in SAP S/4HANA>/<version number>/
    Additionally, you can append multiple SAP query parameters to the service URL to connect to SAP Datasphere or SAP S/4HANA applications, separated by an ampersand (&), in the following format:
    <Custom query1>=<value>&<Custom query2>=<value>&<Custom query3>=<value>....
    When you add SAP query parameters, ensure that there is no space before and after the equal sign (=).
    For more information about the list of SAP query parameters that you can configure, see SAP URL parameters in the SAP documentation.
    Authentication Type
    The authentication type to connect to the SAP OData V4 service.
    You can use the OAuth 2.0 authorization code authentication method to connect to SAP Datasphere.
    Authorization Token URL
    The SAP OAuth 2.0 authorization server that is used to authorize the user request.
    Enter the authorization token URL in the following format:
    https://<Host name of the server>/oauth/authorize
    For example, if the host name is example.authentication.us01.hana.ondemand.com, enter the following authorization token URL:
    https://example.authentication.us01.hana.ondemand.com/oauth/authorize
    Access Token URL
    The SAP OData V4 access token endpoint that is used to exchange the authorization code for an access token.
    Enter the access token URL in the following format:
    https://<Host name of the server>/oauth/token
    For example, if the host name is example.authentication.us01.hana.ondemand.com, enter the following access token URL:
    https://example.authentication.us01.hana.ondemand.com/oauth/token
    Client ID
    The client identifier of your application generated when you configure the application for OAuth.
    Client Secret
    The client secret generated for the client ID.
    Access Token
    The access token granted by the authorization server to access the SAP data.
    Enter the populated access token value that you get from the OAuth endpoint, or click Generate Access Token to populate the access token value.
    For more information about configuring a connection in Administrator, see SAP OData V4 connection properties in the Administrator help.
    5Click Test Connection.