SAP S/4HANA Public Cloud Connector
This article explains how to set up the SAP S/4HANA Public Cloud connector.
Note: This connector uses the JDBC driver provided by Progress Hybrid Data Pipeline (HDP). It requires the user to set up the connection in HDP.
For more information on how to set up HDP connections refer Setup Connections to On-Premises and Direct Data Sources.
SAP Public Cloud Configuration
Use Communication Management to expose the SAP Public Cloud API’s to the insightsoftware Cloud Platform.
Communications User and System
Create a dedicated communications user to connect to the SAP Cloud instance (inbound communication) and setup a new Communications System representing the insightsoftware Platform.
Note: This is logical system and does not physical require host name and port to exist.
Communication Arrangement
Create new Communication Arrangements to link the new Communication System, User and the following appropriate Scenarios. Some examples are shown below:
Communication Scenario | Scope Item |
---|---|
Finance - Accounting Analytics Integration (SAP_COM_0303) |
Accounting and Financial Close(J58) Accounting and Financial Close(O58) |
SAP Analytics Cloud for Planning Integration (SAP_COM_0087) |
Note: If the communications scenario cannot be found ensure that SAP Scope Items has be enabled.
See https://userapps.support.sap.com/sap/support/knowledge/en/3387377
HDP connector Setup
-
Sign in to Progress HDP with the credentials provided by insightsoftware.
-
Create aConnection in HDP using the SAP S/4HANA data store.
-
Create the data source in HDP by filling the required fields in the SAP S/4HANA Data Source form.
-
Server Name
-
User ID
-
Password
-
-
In the performance tab, update the Web Service Fetch size to 5000.
Verify if the connection to HDP is successful.
Connection Setup In Platform
-
Navigate to Connections, and select Create Connection.
-
Select the SAP S/4HANA Cloud Public Edition Data Source.
-
Enter information in the following required fields:
Field
Description
Data Sources
SAP S/4HANA Cloud Public Edition
Version
Current
Name
A name for the connection. You can refer to this field while creating business views.
JDBC URL
The HDP JDBC URL with the HDP Data Source name specified in it. The JDBC URL follows the format:
jdbc:datadirect:ddhybrid://<HDP Server URL>;hybridDataPipelineDataSource=<HDP Data Source Name>
Username
The HDP username
Password
The HDP password
-
Save the connection. Angles will automatically validate the connection before saving.
-
Once the connection is saved, the business views will automatically start importing.
Prebuilt Content
This connection will have prebuilt content. Any available business views will be automatically imported. Here are the prebuilt business views that are imported:
-
Company Code-MF-S-SAP
-
Cost Center Groups-GL-S-SAP
-
Cost Center Hierarchy-MF-S-SAP
-
Cost Centers-GL-S-SAP
-
Currency-MF-S-SAP
-
GL Account Groups-GL-S-SAP
-
GL Account Hierarchy-GL-S-SAP
-
GL Account Line Item-GL-S-SAP
-
GL Accounts-GL-S-SAP
-
GL All Balances-GL-S-SAP
-
GL All Journal Lines-GL-S-SAP
-
GL Trial Balance-GL-S-SAP
-
Ledger-GL-S-SAP
-
Planning Category-GL-S-SAP
-
Planning Entry Items-GL-S-SAP
-
Profit Center Groups-GL-S-SAP
-
Profit Center Hierarchy-GL-S-SAP
-
Profit Centers-GL-S-SAP
-
Segments-GL-S-SAP
-
Sysinfo-MF-S-SAP