Kettle or PDI: share same DB connection between different steps

Question

I've multiple DB connections in a Kettle (Pentaho Data Integration) trasformation.

There are some lookup steps and a table output steps. They must use the same DB connection.

I'm searching a way to change the DB connection in a step and automatically change the connection also in the other steps. Is it possible?

I know that i can use variable readed from parameters inside the connection definition, but i'm searching a sort of GUI way.

simar · Answer 1 · 2017-06-19T21:30:53.270

First implementation use jdbc connection pool. Set pool size same as number of steps in transformation demand connections to DB.

Another case to define separate connection for each step. It is much easier if you use jndi preconfigured in $KETTLE_HOME/simple-jndi/jdbc.properties

For example on image underneath two variables point on master and slave connection. This will allow you to choose appropriate connection.

1 Answers1