Technical Articles
Touchless Deployment ๐ – Working Session
Dear All,
Previous Article : Introducing Touchless Deployment
In this article, describes step by step how to migrate your sqlย through Touchless Deployment API and understand each scenario’s for deploying which would benefit customers, partners, DBA’s & Data Integration consultant.
Available for both SAP HANA and Oracle tenants
Getting Started
Step 1 : Enable Touchless deployment role and assign to the user
The Touchless Deployment permission is added in Security > Roles > Administration.The Commissions user who deploys the database changes must be granted with this permission (through a role).
To configure permissions for Touchless Deployment:
1. In Manage Setup > Security > Roles, select the Role that has the permissions to deploy database changes.
Step 2 : Touchless Deployment API’s to check if you have access to deploy.
Below API will not provide any 200 ok response.
Method : GET
URL : https://Xyz.callidusondemand.com/TrueComp-SaaS/services/rest/touchlessdeployment/
Authentication : Basic XXXXXXXXXXXXXX
content-type : application/json
Below API will provide 200 ok response if User is authenticated, that confirms user can deploy the next step.
Method : GET
URL : https://XYZ.callidusondemand.com/TrueComp-SaaS/services/rest/touchlessdeployment/status
Authentication : Basic XXXXXXXXXXXXXX
content-type : application/json
Step 3 : Create your own folder with required xml and *sql format files. (Sample Github link at end of the step is mentioned)
๐ฆ project-folder โฃ
๐ master.xml
โฃ ๐CR1
โ๐ CR1.sql โ๐ CR2.sql โ๐ CR3.sql โ๐ CR4.sql
Master.xml would be look like below for deploy. you can change XML file name as you per your need.ย Mention your folder name which will have all your *.sql files.
CR1.sql would like below sample which can continue multiple statements.ย
CR2.sql would like below sample which can continue multiple statements – INSERT & UPDATE statements.
Ensure you have auto commit feature enabled in your tenant, as you see no commit statement is mentioned in below
GitHub Link : https://github.com/yogananda-muthaiah/Touchless-Deployment
Understand Liquibase Documentation
https://docs.liquibase.com/concepts/changelogs/sql-format.html
Step 4 : Zip the complete root folder
Zip file should have XML and folder (conatins all your sql files).
Step 5 : Lets upload the zipfile for deploying to the database using Touchless Deployment API
Method : POST
URL : https://XYZ.callidusondemand.com/TrueComp-SaaS/services/rest/touchlessdeployment/update?changeMasterFile=master.xml
Authentication : Basic XAAKAKKKAKA
content-type : application/json
changeLogZip : <your folder path of zip file> (forma-data)
Open the postman or any other API Management tool
2 tables are created after API went successful (202 Accepted) as per above CR1.sql (above screenshot)
Once API is successful, records will be stored in table : ext.cs_td_ext_databasechangelog
If user is tried many times, it will be locked in below table : ext.cs_td_ext_databasechangeloglock
Step 6 : Below API will update the TAG which would be required for rollback statement ..
many of you might know what is database rollback… sometimes rollback are important in your implementation in the long run because if you need to archive the records and delete the entire process, it would help only if you have updated the TAG name for your deployed.
Method : POST
URL : https://XYZ.callidusondemand.com/TrueComp-SaaS/services/rest/touchlessdeployment/tag?tag=version1&changeMasterFile=master.xml
Authentication : Basic XAJHAKJHAKJAK
content-type : application/json
changeLogZip : <your folder path of zip file> (select form-data)
Go back to your postman to execute the below API to update the tag which will deploy and reflect immediately in database.
As shown in below screenshot, last row is updated with TAG column Version1
Best Practice :
Always follow Step 6 if you need to rollback in future anytime.ย Step 5 is straightforward will not rollback.
Step 7 : API to check your Deployed Status
Method : GET
URL : https://XYZ.callidusondemand.com/TrueComp-SaaS/services/rest/touchlessdeployment/getstatus/22
Authentication : Basic XAHAKAKJAKJKA
content-type : application/json
Step 8 : Roll back Scenario on last ChangeSet
Below API will rollback the last number of changesets (the number is provided in your sql file in 2nd line). so In my scenario – 2 tables are dropped.. because it refers to the last time in CR1.sql (refer Step3)
https://docs.liquibase.com/workflows/liquibase-community/liquibase-auto-rollback.html
Method : POST
URL : https://XYZ.callidusondemand.com/TrueComp-SaaS/services/rest/touchlessdeployment/rollbackLastChangesets?changeMasterFile=master.xml&changesets=9998
Authentication : Basic XAHAKAKAJK
content-type : application/json
changeLogZip : <your folder path of zip file> (select form-data)
In my example, changeset = 9998 was executed in Step 6 which was in my sql file statement
After the API is successfull, that confirms your sql is executed successfully and you don’t see the records in log table …ย
Best Practice :
Ensure your zip file what it contains would be rolledback, if you have multiple sql statements, while rolling back it executes everything from *.sql
Step 9 : Roll back Scenario on Tag column
Below API will rollback based on RollbackToTag endpoint allows the user to rollback all changes which have been done after the TAG
Method : POST
URL : https://XYZ.callidusondemand.com/TrueComp-SaaS/services/rest/touchlessdeployment/rollbackToTag?changeMasterFile=master.xml&tag=Version1
Authentication : Basic XAJHAKAJKAJK
content-type : application/json
changeLogZip : <your folder path of zip file> (select form-data)
Step 10 : Roll back Scenario on Date column
Below API will rollback based on RollbackToDate endpoint allows the user to rollback all changes which have been done after the date
Method : POST
URL : https://XYZ.callidusondemand.com/TrueComp-SaaS/services/rest/touchlessdeployment/rollbackToDate?changeMasterFile=master.xml&date=2022-06-21,12:27:13
Authentication : Basic XAHKAKAKKA
content-type : application/json
changeLogZip : <your folder path of zip file> (select form-data)
Note:
Any future enhancements : SAP Commissions Influence Portal
Refer Housekeeping Notes from Previous Article : Introducing Touchless Deployment
Known Limitations
- Deployed information stored in ext schema is not available in /TouchlessDeployment (Step2)
- Touchless Deployment API is only for EXT Database Schema.
- Zip file should contain only *.sql format and zip file upload limit is upto 2MB.
- username in changeset will not be considered from RestAPI – User Authorization.
- Deploy id status keeps generating even if you executed more than once.
Good Job Yogananda Muthaiah
Thank you boss Naveen Pandiri !!
Good one Yogananda Muthaiah
Thank you sir Rakesh Sripathi !!
This is a fantastic new feature! Thank you.
thanks Philip Holtom
Hi Yoga, ext.cs_td_ext_databasechangelog--is the table name for tracking changes the same for all tenants ? Is there something that needs to be set up in order to access this?
Thanks,
Deepan