SAP Cloud Platform Integration (CPI) to push data into SAP BW/4HANA
One option to connect cloud applications with other SAP and non-SAP cloud and on-premises applications is the usage of SAP Cloud Platform Integration (CPI).
SAP Cloud Platform Integration is using the new http (REST) based interface for data integration to SAP BW/4HANA 2.0.
This blog describes how to push data from a Cloud application into a SAP BW/4HANA advanced DataStore Object.
In the first step a BW persistency object must be created.
1.Create DataStore Object in SAP BW/4HANA 2.0
Open the BW Modeling Tools in Eclipse and create a new DataStore Object.
Maintain the technical name and the description.
Please use DataStore Object 0EPM_ADSO3 as an template otherwise the CPI integration flow will not work.
Maintain the Special Properties in the DataStore Object and set Write-Interface-Enabled. Activate the DataStore Object.
2. Install the SAP Cloud Connector
Please ensure that the SAP Cloud Connector is already installed and runs properly. Details are available here.
3. Maintain the Integration Flow
Open SAP Cloud Platform Integration Web Interface (System dependent).
Open Operations View.
Open Security Material Tile.
Add new User Credentials to connect from CPI -> SAP BW/4HANA.
Add User Credentials and deploy.
Open Discover Page and search for Package SAP BW/4HANA Integration With Rest Based Data Load.
Open Artifact View of package SAP BW/4HANA Integration With Rest Based Data Load.
Configure Integration Flow Integration for Open Purchase Orders with Rest Based Data Load.
Maintain the Connection for the SAP BW/4HANA System to push data into the defined advanced DataStore Object (created in step 1 in that blog).
It is mandatory to maintain both reciever connections (BW4System and TokenService).
Start with Token Service and maintain the Adress -> BW Serverhostname and DataStore Object Name.
Open Receiver Connection BW4System and maintain Adress here as well -> BW Serverhostname and DataStore Object Name.
Save and deploy.
Open the Integration flow and check if the details are well maintained.
E.g. check the field mapping.
In 3 fields (EPM_CHAT, EPM_PDELD and EPM_POAS) SAP included a simple type conversion for date and boolean. Here is one example:
Once all settings and mappings checked and maintained – deploy the Integration Flow.
4. Consume the data in SAP BW/4HANA
Go back to the SAP BW/4HANA System and open the BW Modeling Tools in Eclipse.
Search for the Write-Interafce-Enabled advanced DataStore Object in which the already created Integration Flow is pushing the data.
Open the Manage view in the context menu of the advanced DataStore Object.
You will now see all the already pushed data from the source to the advanced DataStore Object in SAP BW/4HANA.
It is now possible to create a virtual model (Composite Provider) or transfer the data to the next layer of your Enterprise data model depending on your data model and the Business requirements.