Skip to Content
Technical Articles
Author's profile photo Akash Shrivastava

IBP to CPI using CPI-DS

Introduction

Cloud Platform Integration for Data Services (CPI-DS) is delivered with IBP as a preffered integration tool to send and receive data to/from IBP. However, there are scenarios where CPI-DS cannot send the data to the end system, like in case of BW4HANA, where CPI-DS does have the capability to send data to BW4HANA datastores (I will cover this in my next blog post). In cases like these we can use Cloud Platform Integration (CPI) to send the data.

Overview

After going through this blog post till the end you will be able to fetch data from IBP and send it to CPI.

Steps

CPI

1. Create an iflow in CPI to send the data to end system (eg. BW4HANA).

2. Deploy the iflow and get the endpoint url, which we will use in CPI-DS to create the datastore.

CPI-DS

3. Create a datastore of type “SOAP Web Service” and enter the CPI wsdl URL.

4. Test your connection once data store is created.

5. After the test connection is successful, you will be able to import the structure in CPI-DS.

6. Create a new project in CPI-DS.(IBP_BPC_StatisticalForecast in my case)

7. Create a task “T_IBP_CPI_StatisticalForecast”

8. Create a data flow inside the task

When you will create a new dataflow you will find “Target_Web_Service_Call” and “outputLoader”

Do the necessary transformation and make sure in the transform type “XML Map” has iteration rule applied to child node of xml

9. Finally your flow will look something similar to this.

10. Save and run the flow.

11. Check in Monitor Message Processing in CPI if you see a hit there. (Once the test connection is successful it will always hit CPI and for any error in posting the data in end system you will see that flow fails in CPI-DS)

 

Conclusion

Here you have seen how to pull records from IBP using CPI-DS and send it to CPI and from here this can be delivered to multiple end systems. This approach comes handy when CPI-DS cannot interact with the end system directly.

Please check product availability matrix for CPI-DS before you plan your integrations – https://support.sap.com/content/dam/launchpad/en_us/pam/pam-essentials/TIP/SAP_Cloud_Platform_Integration_PAM.pdf

Happy Learning.

Akash

Assigned tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Pratibha Singh
      Pratibha Singh

      Many Congratulation Akash !! This is definitely going to help.

      Author's profile photo Rakesh damera
      Rakesh damera

      Congratulations on the post Akash! Looking forward to more blog posts!

      Author's profile photo Sibi Sivakumar
      Sibi Sivakumar

      Thanks for the detailed Blog Akash 🙂

      Author's profile photo Bhanu GK Tiruveedula
      Bhanu GK Tiruveedula

      It's nice idea. Thanks for sharing.

      Author's profile photo Nakul Thacker
      Nakul Thacker

      Akash Hi does CPI-DS now have the capability to load directly to BW4Hana data store objects? as I know BODS has that capability .

      Author's profile photo Kirthan Kumar
      Kirthan Kumar

      Hello Akash,

      I'm working with the similar requirement.

      But after providing all the details to SOAP Webservice data store, while saving I'm getting below error(screenshot is attached). Could you please advise if you came across this..? Thanks..!

      Also the URL used in the Soap webservice data store is https right(which was copied from CPI-PI)..?

       

      Regards,

      Keerthan