In this article, describes how you can automate your SQL deployments to SAP Commission database automatically using Touchless Deployment API’s through SAP Integration Suite or Cloud Integration (CPI) through sFTP connection
If customers wants another way to deploy but not through CI/CD or Postman process explained in my previous articles,, there is way to automate through pushing the DDL file to sFTP dropbox provided by SAP Commissions through developing Iflow from SAP Cloud Platform Integration or SAP Integration Suite.
so this way, customer will have to just drop their ddl file with updated incremental changeset id so it gets deploy automatically and secured way… also you can develop your own Iflow adding additional steps like after deploy you can send email notifcation or adding succesfull logs with your deploy id.
Let’s get started
SAP Commission dropbox offers customers provided with sFTP connection & access for pushing the files but we are making use of Outbound folder to automate for storing DDL objects for deploying..
so we are going to create a New folder called “DDL” but this will not be available for any of your dropbox by default but even though if you have folder creation access and then you wouldn’t have access to create files inside the directory. This is something Product team and engineering team to think through how customers can get benefit and take advantage from different approach.
sFTP Configuration setup
We have deployed Iflow successfully and now you can drop the DDL files inside the sFTP directory and process would check & pick every 5mins if there is any file inside the directory to trigger the Iflow.
Final Iflow would look like below
Let’s see the sample file how it gets deploy succesfully
Once you push your file to sFTP directory i.e DDL folder in my example – Iflow will pick automatically.
How liquibase.xml looksHow it gets zipped and deployed to SAP Commissions
Once the Iflow is succesfull and gets deployed to SAP commissions, the file in sFTP gets deleted automatically.
Closing Thoughts for Developers motivation