Dynamic connection string without interrupting qvw files

[#1]

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

[sujeetsingh]

That is some thing out of Qlikview and based on your deployment architecture.

You can have Oracle tasks to get the updated passwords for user to database and then save it to some text file.

And then you can have scripting it qlikview  to get the latest.

I am not sure how it will work.

[vardhancse]

We can create .qvs files for the conenction strings. So that if we change the password in one file will reflects in all QVW's.

And more over environment to environment the credentials will be varied, in that case also this will help you out.

[#4]

Actually our customer is not aware of the qlik view technically and client is not installed in their machines and also reports are present in their machines. We cannot do any changes in their qvw files.

So want a mechanism where customer should not touch .qvw files and some how new password has to be updated by them and reload should happen through server.

[vardhancse]

in QVW files not required to change the password regularly, only in .qvs(notepad file) we can change the password and we can reload the dashboard.

[#6]

We tried the same thing by changing password in the .qvs(notepad file) but when we tried to reload through server it was not reloading.

And we tried to reload through client but every time it is giving a pop to enter the password when ever we change password in the notepad file.

[PradeepReddy]

I think u have to create a new connection string every time, whenever password is changed.

[#8]

Is there any other solution even if database password changes we should not touch the .qvw files and change the password in connection string.