In this blog post, I will cover how we can move analytical data available in the SAP Ariba APIs to SAP HANA Cloud. To achieve this, I will use the trial version of the Integration Suite and SAP HANA Cloud available in SAP Cloud Platform. I will build an integration flow in SAP Cloud Platform Integration and use the recently released JDBC adapter for SAP Cloud Platform Integration (Cloud Foundry environment) to send data to SAP HANA Cloud.
In a previous blog post, I covered how to use SAP Cloud Platform Integration to replicate SAP Ariba analytical data. This blog post is a continuation of it but will focus just on what is required to get it working with SAP HANA Cloud.
Now that we have access to the different systems, I will proceed to explain what we need in to get the SAP Cloud Platform Integration integration flow to SAP HANA Cloud.
Deploy JDBC security material in SAP Cloud Platform Integration
Update the integration flow components
Modify Process Ariba response script
Deploy the integration flow
The integration flow end result is shown in Fig. 1.
Fig. 1 - Integration flow to SAP HANA Cloud
Step 1 - Deploy JDBC material in SAP Cloud Platform Integration
⚡ Go to your SAP Cloud Platform Integration instance and create/deploy 2 security materials (Monitor > Manage Security > JDBC Material). This will be used by the integration flow to communicate with SAP HANA Cloud.
Fig. 2 - JDBC material
I'm using DBADMIN for simplicity purposes, this is not recommended for production. Sample JDBC URL: jdbc:sap://56acb719-b476-xxxx-bd11-xxxxxxxxx.hana.trial-eu10.hanacloud.ondemand.com:443/?encrypt=true. Note that the URL will vary depending on the region of your account and the port in the connection string is 443.
Step 2 - Update the integration flow components
The integration flow should look like the integration flow in Fig. 1. Below, the details on what each of the new components are doing:
Modify the Process Ariba response script: Instead of outputting JSON lines, the script will not be outputting INSERT SQL statements.
Set the target system adapter and name: Remove the connection to the target system, create a new one and set the adapter type as JDBC. In the connection details we set the JDBC Data Source Alias which is the name of the JDBC material, e.g. HANACloudTrial_JDBC. See Fig. 2. Set the name of the target system to something meaningful.
Now that all steps are completed, we deploy the integration flow and check the records created in SAP HANA Cloud.
Fig. 10 - SAP HANA Database Explorer
As we can see, we have replicated the SAP Ariba data to SAP HANA Cloud. We can now use this dataset to create a report/dashboard in reporting tools that connect to SAP HANA Cloud, e.g. SAP Analytics Cloud.