using variable names for a database connection in Pentaho Kettle

Question

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?

Answer 1

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.