Having a changeable database connection login parameters

Hi all,

Is there a way to have the database connection login parameters extracted from a txt or csv file where user can just modify the login parameters in the file instead of having to launch CloverETL and modify the hardcoded login parameters under connections?

Yes, you can use (externalized) parameter files. For example, you can have parameters DB_USER, DB_PASSWORD, DB_URL, … which they can be referenced in that connection using expressions ${DB_USER}, ${DB_PASSWORD}, ${DB_URL}, …

This (external) parameter file has to be linked to the graph, where you’re using that connection. Or you can externalize connection itself and then reuse it in several graphs. Process is the same as with externalizing parameters - right click on connection and select “Externalize connection”.