Human Capital Management Blogs by SAP
Get insider info on HCM solutions for core HR and payroll, time and attendance, talent management, employee experience management, and more in this SAP blog.
cancel
Showing results for 
Search instead for 
Did you mean: 
yogananda
Product and Topic Expert
Product and Topic Expert
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! 🚀

yoganandamuthaiah |Twitter | LinkedIn | GitHub
















3 Comments