Can we create "Server Aliases" in Linux clients (webservers etc.) so that you can change connections without touching the application's DB URL string?
The official documentation seems to talk about a GUI way of doing this in Windows, so I was wondering if something like this exists for Linux. This has lots of benefits, especially during containerization of apps.
My high level objective is to see if I can create some level of indirection so that the application always thinks of DB as
DSN=myDsn;Uid=myUsername;Pwd=myPwd; while the real driver redirects it to
DSN=realDsn;Uid=realUsername;Pwd=realPwd;. Initially I was thinking of something like
socat, but I am not sure how password changes can be handled! "Server Aliases for client" seems to do something like this, hence the question.