In this blog we’ll discuss complete steps for Import data connection from S/4 hana on-premise system to SAP Analytics Cloud . The Operating system we are using on which S/4 Hana system is installed is SUSE Linux SP 15.
Here, Our Data source is S/4 Hana from which the SAP Analytics Cloud is connected using the SAP Analytics Cloud Agent and SAP Cloud Connector.
It is recommended that the Cloud Connector, SAP Analytics Cloud agent, and the SAP Java Connector (JCo) are installed together on a dedicated server, and not a personal computer. This helps to ensure that multiple users can use an import data connection without experiencing slowness or downtime.
The SAP Analytics Cloud Agent Simple Deployment Kit allows you to quickly get your import data connections working.
The simple deployment kit is only supported on Windows 64-bit operating systems. If you have a different server, such as Linux, you'll need to install and configure the agent manually.
If we have windows Environment, then the SAP Analytics Cloud Agent Simple Deployment Kit is preferred. More details can be found in the below link.
SAP Analytics Cloud Agent Simple Deployment Kit | SAP Help Portal
For Linux Environment we have to install SAP JVM, SAP Cloud Connector, Tomcat Apache server, SAC Agent, Java Connector.
Below are the steps for Import Data connection for On-premise S/4 HANA systems -
- SAP JVM 8.1 and JDK installation on the linux server
- Install SAP Cloud Connector on the same linux server.
- Installing Tomcat Apache server
- Installing and configuring Java connector (Jco)in Tomcat .
- Installing and configuring SAP Analytics Cloud Agent .
- Configuration and Connection steps in SAC portal
1. SAP JVM 8.1 installation on the same linux server
Download the SAP JVM from the below link:
https://tools.hana.ondemand.com/#cloud
Download the rpm file compatible for linux 86x64 -
sapjvm-8.1.095-linux-x64.rpm (sha1)
Move the file to the server and run the below command to install SAP JVM
rpm -i <file_name>.rpm
Also it is recommended to install the openjdk packages on SUSE linux .
Run command ‘zypper install java’
To check the verison of openjdk installed.
Run command 'java –version'
2. Install SAP Cloud Connector on the same linux server.
To download the SAP Cloud Connector go to the below link :
https://tools.hana.ondemand.com/#cloud
Download the zip file for Linux x86_64 Architechture and move the downloaded file to the server.
Now, unzip the file and install the rpm package for cloud connector as below.
Cloud connector is installed now.
To open the SCC, enter: https://<hostname>:8443 in a browser, where the <hostname> is the hostname of the machine on which the connector is installed, and the port number is the one configured during installation. The default port number is 8443
By default Login Credentials are :
Username : Administrator
Password : manage
After the fist login , It prompts you to change password for the Administrator User.
Now Add the SAC subaccount to the cloud connector:
Click on “Add subaccount” and enter the details SAC subaccount , which you can find on SAP Analytics Cloud.
To find the Subaccount details of SAP Analytics Cloud :
You must use a System Owner account to perform the following steps. If you don't know who the system owner is, log on to SAP Analytics Cloud and from the side navigation, choose Security > Users.
- Log on to SAP Analytics Cloud.
- From the side navigation, choose System > Administration.
- Switch to the Data Source Configuration tab.
3.Installing Tomcat Apache Server :
- Create a directory named tomcat in the /opt folder:
- Go to the Apache Tomcat 8 Download page by clicking this https://tomcat.apache.org/download-80.cgi Place your cursor under 8.5.65 Binary Distributions, right-click on the tar file and select the copy link address from the menu that appears (as shown in the picture below). At the time of writing, Tomcat 8 is the most recent edition, but you are free to use whatever version is most current.
- Download the file from wget
- Extract the tar.gz file
- Starting Tomcat apache server
4.Installing and configuring Java connector (Jco)in Tomcat .
- Download SAP Java connector from SAP support portal -> Software downloads
- On a Linux server, put the sapjco3.jar and libsapjco3.so in the lib folder of Apache Tomcat.
5. Installing and configuring SAP Analytics Cloud Agent .
It is recommended, but not mandatory, that the Cloud Connector, SAP Analytics Cloud agent, and the SAP JCO are installed together on a dedicated server, and not a personal computer. This helps to ensure that multiple users can use an import data connection without experiencing slowness or downtime.
Modifying the Cloud Connector’s embedded web application and deploying the agent to it is not supported.
- Download the SAP Analytics Cloud agent from the SAP Support Portal.
The agent is available on the SAP Software Downloads page. Expand By Category, select SAP Cloud Solutions > SAP ANALYTICS CLOUD CONN > SAP ANALYTICS CLOUD CONN 1.0 > SAP ANALYTICS CLOUD AGENT 1.0 and download the latest version.
- Unzip the downloaded file and rename the WAR file to C4A_AGENT.war.
- Extract the package and copy the file C4A_AGENT.war to your Tomcat webapps directory.
The agent will automatically deploy when Tomcat is restarted.
- Create a user for the SAP Analytics Cloud agent and assign the Services role to the user.
- The user credentials will be needed later for setting up the connection to SAP Analytics Cloud.
- Restart the Tomcat application server for the settings to take effect.
- Test if the installation was successful, by opening the following URL in your browser: http://<Host>:<Port>/C4A_AGENT/deploymentInfo
The version of the SAP Analytics Cloud agent installed is displayed.
6. Configuration and Connection steps in SAC portal
- Add the Data source in System > Administration > on-premise data sources
- Check connection configuration , It should be green.
- From the side navigation, choose
Connections > (Add Connection).
The Select a data source dialog will appear.
- Expand Acquire Data and select SAP S/4HANA.
- In the New SAP S/4HANA Connection dialog, do the following:
- 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.
- Enter the Data Service URL published during your configuration
- Select the authentication type.
- Enter the User Name and Password of the user you want to import data from.
- Choose Create.
The new connection is added to the list of connections on the Connections screen.
Conclusion :
Import Data Connection to S/4Hana on-premise system in SAP Analytics Cloud has been established successfully.
- SAP Managed Tags:
