Akn
Akn

Reputation: 35

using variable names for a database connection in Pentaho Kettle

I am working on PDI kettle. Can we define a variable and use it in a database connection name. So that if in future if i need to change the connections in multiple transformations i would just change the variable value in kettle properties file?

Upvotes: 3

Views: 2710

Answers (1)

bolav
bolav

Reputation: 6998

Just use variables in the Database Connection.

For instance ${DB_HostName}, and ${DB_Name} etc.

Then just put it in your kettle.properties:

DB_HostName=localhost

You can see what fields that support variables by the S in the blue diamond.

blue diamond s

Upvotes: 3

Related Questions