Import Data Connection to SAP S/4HANA

You can create a connection that allows you to import data from SAP S/4HANA Cloud Edition or On-Premise exposed OData V2 services.

Prerequisites

To connect to SAP S/4HANA On-Premise OData services, you must do the following:
  1. The cloud connector is installed. For more information, see Installing the SAPCP Cloud Connector.
  2. The cloud connector is configured. For more information, see Configuring the SAPCP Cloud Connector.

To connect to SAP S/4HANA Cloud OData services, the necessary configuration is documented in scope item 1YB https://rapid.sap.com/bp/#/scopeitems/1YBInformation published on SAP site.

The SAP Analytics Cloud agent doesn't need to be installed during the configuration process.

Context

An import data connection allows you to bring data from your SAP S/4HANA system into SAP Analytics Cloud.
Note
  • You cannot send information from SAP Analytics Cloud back to SAP S/4HANA.
  • While OData exposes one-to-many navigation, SAP Analytics Cloud cannot follow these relationships because doing so would distort the measures at the parent level. OData v4.0 supports Lambda operators “any” and “all”, which can reduce the collection of children to a single Boolean value. For this to work, however, both the server and SAP Analytics Cloud must support OData v4.0. Currently, SAP Analytics Cloud supports only OData v2.0. As a result, one-to-many navigation properties will be hidden to the end user until OData v4.0 is supported on both sides. As a possible alternative, select the child entity as the main entity for the data query and use the parent entity as the navigation property.

  • SAP Analytics Cloud supports OData Version 2.0. Logical Operators (such as Equal, Not Equal, Greater than, Greater than or equal, Less than, Less than or equal, Logical and, Logical or) are supported. Not logical negation, arithmetic operators, or functions are not supported.

  • Embedded Complex types are not supported.

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 SAP S/4HANA.
  3. In the New SAP S/4 HANA Connection dialog, do the following:
    1. In the Connection Information section, add a Connection Name and Description.
    2. If you are connecting to an SAP S/4HANA on-premise system, select Connect to an On-Premise OData service, and then select the Location of your cloud connector from the list.

      Make sure to complete the prerequisites before connecting to an on-premise source. If this option is not selected, the driver will attempt to connect to a S/4HANA cloud data source.

    3. Enter the Data Service URL published during your configuration.
      Note
      Only the server address and port are required for both SAP S/4 HANA Cloud and SAP S/4 HANA On-Premise. For example, https://<S/4HANA SERVER> for SAP S/4HANA Cloud or https://<S/4HANA SERVER:PORT> for SAP S/4HANA On-Premise.

      For SAP S/4HANA Cloud, SAP Analytics Cloud will connect to https://<S/4HANA SERVER >/sap/opu/odata/IWFND/CATALOGSERVICE;v=2/, if the gateway service is enabled. Otherwise, it will connect to https://<S/4HANA SERVER >sap/opu/odata/sap/API_CA_ODATA_CATALOG_SRV/. To verify that the page can be loaded in the browser without error, please load the page with your credentials from the browser.

      For SAP S/4HANA On-Premise, SAC will connect to https://<S/4HANA SERVER:PORT>/sap/opu/odata/IWFND/CATALOGSERVICE;v=2/. To verify that the page can be loaded in the browser without error, please load the page with your credentials from the browser.

    4. Select the authentication type.
    5. Enter the User Name and Password of the user you want to import data from.
      Note
      If you want to share the credential details, select the option Share these credentials when sharing this connection. Otherwise, users will need to enter their own credentials in order to use the connection. If you don't share your credentials, users will be able to edit their credentials at any time without having to start a data acquisition process.
  4. Choose Create.
    The new connection is added to the list of connections on the Connections screen.
  5. If you want to create a model based on this connection, see Importing S/4HANA Data to a New or Existing Model.