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
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Read about some useful Context Variable ideas