Pentaho Kettle : How to use the same database connection in both Job and transformation

Question

I have a job and multiple transformations. If i wanted to define a database connection in the Job , and use the same database connection for all the transformations , how do I go about it ? I am using a community edition Pentaho 5.0 version .

I am creating the jobs locally using spoon and moving them to a Linux server where I will be using kitchen.sh to execute the job and transformations .

Thanks.

Answer 1

In Spoon, define your database connection in Tools > Repository > Explore > Connections. It will be shared by all your jobs and transformations. Before that close all your jobs and transformations opened.