I have been able to set database connection properties in Kettle.properties and use that in transformations. For example I have


in Kettle.properties and refer to these varables in the data connections. This setup helps me to modify the properties file to connect to different source systems without touching any of the transformations. Great feature in Kettle!!

But I do have a requirement where the etl scripts are called from a different framework and there is a need to connect to different source system dynamically at run time. i.e from an UI, I should have the capability to select the source system and execute these ETL scripts to load the data from that identified source.

How can I achieve this? Is there a way to pass the connection properties (source, port ...) to Kitchen and have the transformations use these properties to connect to the database?

Thanks in advance for any help