Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Database Query component connect to different servers based on environment

Using the "Database Query" component, it's possible to use a variable for "Password" property, but it's not possible for "Connection URL" and "Username".

I want to connect to different database servers based on the environment (development / production). How should I do that?

2 Community Answers

Matillion Agent  

Paul Johnson —

Hi Josep,
You can use variables for those fields,
I just tested this myself now. Although i did come across an issue where the default value for the connection url variable is required or it would reset to the default connection url.
I will raise this as an improvement to allow no default values.

Regards,
Paul


Josep Martinez —

Hi Paul,

Thank you for your answer. I see that I was confused because of the UI: the "connection url" doesn't have "Use Variable" checkbox and I understood that was not possible to use it there.

Best regards,

Josep

Post Your Community Answer

To add an answer please login