Looking for recommendation on where to store usernames and passwords for a custom data reference, which isn't hard coded?
I was first thinking an AF admin could enter connection details in the Configuration database, and just have the CDR read the details from there, but as I give it more thought the CDR is executed under the context of the end-user, so the config database isn't even visible for them.
I need something that is configurable, and can hold multiple connection sets. I don't mind that an admin sets up the connections.
My plan now is a SQL database to hold the details, and hard-code a SQL user into the data reference to fetch the details.