How to deploy DB script as part of CICD to Talend Remote Engine?
Our development process requires, every new Talend Job to have a DB script to insert some entries to the DB. There is a Talend Job that executes this DB script. tFileInputDelimited (read sql script file) -> tFlowToIterate (iterate over each sql statement in file) -> tDBRow (execute the sql statement)
But the problem I am having is how to move this DB script from local to remote engine through CICD. Executing the script is not an issue.
I'm using Jenkins & Maven to build & deploy to Talend cloud. This works for Talend Job.
How do I include moving the DB script to Talend Cloud in the same CICD process?
Is there a plugin in Jenkins that can read a file from git and move it over to Talend Cloud?
Is there a different way to implement what I am trying to do? It's basically deploying DB changes (mostly insert statements) through CICD process
