Customer Portal

how to externalize a db connection with environmental variables?

Comments 2

  • Avatar
    Lukas Cholasta
    0
    Comment actions Permalink
    Hi Ramiro,

    It is possible to use environment variables even in externalized connections. However, under certain circumstances, these variables may not be visible to CloverETL, mainly on Linux where these variables may exist in isolated shells. So, the most reliable way to tell whether the CloverETL can see them is to navigate into the CloverETL Server web console -> Configuration -> System Info -> Environment Variables. It you can see your variable here, you can use it within the software. Here you can find how to reliable define a global environment variable for Linux. If you are on a different OS, please let me know which one it is, whether you can see them in the web console and how did you define the variables. If you do not have a CloverETL Server or if it is located in a different environment, please let me know about it as well.

    Best regards,
  • Avatar
    ramiro
    0
    Comment actions Permalink
    Thanks Lukas,

    It is possible indeed! We have the connection working now.

    The problem was that we were caching the docker image that run cloverETL.

    We run everything in containers, and I was using the old cached version (without the new env variables set) by mistake.

    All good, not a cloverETL issue, but thanks for the response!

    Ramiro

Please sign in to leave a comment.