Posts: 3
Joined: Thu Apr 20, 2017 8:47 am

Having a changeable database connection login parameters

Postby cloveretluseruser » Fri Apr 21, 2017 2:35 am

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?

Posts: 25
Joined: Wed Nov 09, 2016 11:51 pm
Location: 2111 Wilson Blvd., Arlington VA 22201

Re: Having a changeable database connection login parameters

Postby svecp » Tue Apr 25, 2017 3:11 pm

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".
Pavel Švec | CloverETL | Sales Engineer | 2111 Wilson Blvd | Suite 320 | Arlington, VA 22201