Skip to Content
Technical Articles
Author's profile photo Yogananda Muthaiah

SAP Commissions sFTP – Integration Suite Use Case

Dear Readers,

The purpose of this article is to demonstrate and explain how SAP Integration Suite (aka CPI) can be use case to drop a file to sFTP server without pushing manually from client system and can also be automated based on your scheduled time.  (Avoiding Human Intervention)

How to Set Up Integration Suite Trial Account

Link: https://developers.sap.com/tutorials/cp-starter-isuite-onboard-subscribe.html


Pre-requisites :

  • Access to your SAP Commissions sFTP Dropbox
  • SAP Integration Suite [aka CPI] ( Follow above link to get Trail Account)

Step 1: How to get Access to SAP Commissions sFTP?

Raise a CallidusCloud Support ticket sharing your Public key and the Technical support team will confirm once the public key is configured to your tenant server.
Technical Support will share the hostname and username for access

Test it locally through testing in WinScp through your Private key generated.

Once you log in, you can see the folder structures.  that confirms you can log in successfully

Note: If In case, you have trouble accessing your sFTP – Contact Support team.

Refer this Article to (Important to do) :

SAP CPI SFTP Adapter configuration from PuTTY Private Key(.ppk) File

Step 2: Let’s design the Iflow in Integration Suite for dropping the sample file type called BOEXTRACTTRIG.

  • Login to your Integration Suite or Cloud Platform Integration (CPI)
  • Go to Design and start creating your own Iflow

Integration flow design 

Let’s configure the filename to drop the file in the Inbound folder for processing.

I am triggering the Iflow through python call to execute and maybe, you can automate this through scheduled time. File is seen in Inbound folder after 200 response code.

Later, you can see the file got processed in Commission Data Loader (CDL) Jobs


How to Connect to Third-Party Services Using SAP Integration Suite?

Complete this Tutorial: https://developers.sap.com/mission.apim-open-connectors.html

Thanks, for reading it till the end. 🙏


Hope you find that helpful! Let me know your thoughts on this in the comments section.
Don’t forget to share this article with your friends or colleagues.
Feel free to connect with me on any of the platforms below! 🚀

Yogananda Muthaiah |Twitter | LinkedIn | GitHub

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo SAP BTP2009
      SAP BTP2009

      Hi,

      Thanks for the blog. Is it possible to try this scenario using BTP Trial?

      Author's profile photo Yogananda Muthaiah
      Yogananda Muthaiah
      Blog Post Author

      yes Talha A .. its possible.

      Author's profile photo Mohan Thirugnanasambandam
      Mohan Thirugnanasambandam

      Hi,

      Thanks for the blog. I am able to successfully connect to the SFTP dropbox and push files to the inbound folder.

      but i am noticing a very slow process from there for the dropbox to actually consume the file and process it.

      Any idea on how to increase the processing time in the dropbox ?

      Thanks.