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

Seven Stars

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

 

 

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog