7 Replies Latest reply: Nov 18, 2014 4:10 AM by Purushotam Reddy RSS

    Dynamic connection string without interrupting qvw files

      Hi Qlik Community,

       

      I am using Qlik view 9, i have one requirement.

       

      I have 9 qvw reports which fetches data from oracle database.

       

      In general we are establishing connection string for each report manually,

       

      Now we want this mechanism to be dynamic i.e I don't want to create connection string every time in the qvw file when ever database password changes and don't want open qvw file.

       

      So we have created the config file and copied the connection string which we have created for one of the report. My question is how to encrypt the database password to put in config file when ever database password is changed and has server has to reload, so that i no need to touch qvw files.

       

      Thanks & Regards,

       

      D Purushotam