Skip to Content
Technical Articles

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 2.0 Integration with Rest based Data Replication

Open Artifact View of package SAP BW/4HANA 2.0 Integration with Rest based Data Replication.

Configure Integration Flow Replicate NW EPM Demo data to SAP BW4HANA.

 

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.

 

3 Comments
You must be Logged on to comment or reply to a post.
  • Hi Gordon,

    thank you very much for this interesting blog about new features. Am I right that what you show here is a specific demo scenario provided by SAP for this new interface?

    Could you also provide information about Cloud Integration before BW/4HANA 2.0 and maybe for other approaches or integrating from non-SAP Cloud systems for BW? I can’t find much for this area…

    • Hi,

      In my last project I built an ABAP program running on BW (BW/4 actually), calling the a REST API from SCP Workflows. You don’t have access to the tables directly.

      The steps are actually pretty much the same as in the CPI flow:

      • Create an REST Request using ABAP OO.
      • Get a Security Token.
      • Call the API to access the data, including the token in the request.
      • Write the data to a BW aDSO using the corresponding API (ABAP Function Module).
      • The rest should be easy as pie.

      The same approach would work with any DataSource exposed via a REST API.

      Using SCP CPI would be cleaner, but of course you have to change the first part of the flow, as you pointed out.

      You can search for blogs explaining how to extract data from SCP Workflows, actually.

      Iñigo

       

  • Hi Gordon,

    if I try to find the package “SAP BW/4HANA 2.0 Integration with Rest based Data Replication” on our CPI system I can’t find it. Any idea?

     

    Regards
    Thorsten