Promote a Sense app from Dev to Prod

[kbiesemans]

I am trying to find a solution to promote a Sense application from my Development stream to the Production stream.

In this case I speak about one Sense site on which there exists a stream that is used for Development, called "Dev.Sales". In here I use Data Connections to test data. Now I need to promote this application to the Production stream, called "Sales". Here I need a Data Connection to the production data, so they will have a different name. I don't want to change every time each reference to a Data Connection in my script when I promote the application. Does someone has a good idea to solve this?

Thanks for your ideas!

[JonnyPoole]

Hi Keon, this kind of workflow strikes me as a developer workflow and usually you would develop in a Qlik Sense test site and use somehting like the qlik sense deployment console to move/promote  the content from the dev to prod.

If you are limited to one site then what i would suggest is to use good old fashioned IF() logic in the load script to conditionally connect to the Dev vs Prod data connection. You would have to also include the load statements in each section of the IF because i don't think you can variabize the data connection name just yet and that is referenced in the FROM clause of each load.

Then the trick becomes which condition do you use? 

I've traded some emails recently on this subject and i would suggest using the documentname() function to get the GUID of the development  application vs the GUID of the production application. Then you can reference , in the load script, which document the script is running on and call the different data connection .

make sense ?