Reputation: 35
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
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.
Upvotes: 3