Dynamically Changing "Data Connections" based on "Streams"
Is there an option to Dynamically change data source in Qlik sense?
For example, I have three streams(DEV, UAT, PROD ) and I need to connect to three different data sources(DEV, UAT, PROD),
Is there a way like I should not change the connection string but it should pick up the data source dynamically when I deploy in respective streams(DEV, UAT, PROD)? Can you please reply. Thanks in advance!
I personally haven't tried anything regarding this, but the first thing comes to mind is an IF ELSE statement using a source-path that would be included in the script. Then when you "deploy" to a stream the files would change locations/paths. Therefore the script would automatically account for it.
A few functions that come to mind to get a path...
Please let me know if you end up finding a viable solution. If I end up finding time to test this I will reply back.