Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

7 Replies
sujeetsingh
Not applicable

Re: Dynamic connection string without interrupting qvw files

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
Not applicable

Re: Dynamic connection string without interrupting qvw files

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.

Not applicable

Re: Dynamic connection string without interrupting qvw files

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
Not applicable

Re: Dynamic connection string without interrupting qvw files

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.

Not applicable

Re: Dynamic connection string without interrupting qvw files

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
Not applicable

Re: Dynamic connection string without interrupting qvw files

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

Not applicable

Re: Dynamic connection string without interrupting qvw files

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