CODEWITHSUNDEEP
pentahoetlkettle
Rasika Vijay
Rasika Vijay

Reputation: 415

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

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.

Upvotes: 6

Views: 8298

Answers (2)

mind_overflow
mind_overflow

Reputation: 101

If you are not connected to a Pentaho Server Repository (you are working locally), open the transformation where yoy have already configured the connection, now in the "View" tab, "Database connections" element, select the connection and rigthclick to open contextual menu then select "Share", now the connection is available in all other open locally transformations and you can reuse it.

PDI Version 9.2

Upvotes: 2

ingmmurillo
ingmmurillo

Reputation: 2391

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.

Upvotes: 8

Related Questions