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
Paul Johnson —
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.