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.
- Install and configure the cloud connector.Note
The cloud connector is not required for a connection to SAP S/4HANA Cloud Edition.
- Develop and enable OData service through SAP Gateway, please refer to the following documents:
To connect to SAP S/4HANA Cloud OData services, the necessary configuration is documented in scope item 1YB https://rapid.sap.com/bp/#/scopeitems/1YB.
The SAP Analytics Cloud agent doesn't need to be installed during the configuration process.
- 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.
.The Select a datasource dialog will appear.
- Expand Acquire Data and select SAP S/4HANA.
In the New SAP S/4 HANA Connection dialog, do the
- In the Connection Information section, add a Connection Name and Description.
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.
Enter the Data Service URL published during your
NoteOnly 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.
- Select the authentication type.
Enter the User Name and
Password of the user you want to import data
NoteIf 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.
The new connection is added to the list of connections on the Connections screen.
- If you want to create a model based on this connection, see Importing S/4HANA Data to a New or Existing Model.