How to deploy DB script as part of CICD to Talend Remote Engine?

sarora1 — Sat, 16 Nov 2024 03:16:19 GMT

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

topic How to deploy DB script as part of CICD to Talend Remote Engine? in Talend Studio

How to deploy DB script as part of CICD to Talend Remote Engine?