topic Re: Changing the database password in QlikView

Changing the database password

Tue, 20 May 2014 11:29:21 GMT

Hi,

I created the following connection string using qlikview wizard :

OLEDB CONNECT32 TO [Provider=MSDAORA.1;User ID=SOURCE;Data Source=XE] (XPassword is TKGJRaUGVJNKTaEGRBIB);

I want to be able to change the database password (from a development environment to a production environment) without going through the wizard again and I don't want to delete the connection string and regenerate it.

Is there a solution to this requirement with Qlikview or do I have every time to regenerate the connection.

Thanks

Re: Changing the database password

maxgro — Tue, 20 May 2014 11:33:32 GMT

make 2 oledb connections (dev and prod)

use a variable and an if statement to change from dev and prod

you can further improve it adding an external file from which you read the variable; so when you change from dev to prod you only change the external file

Re: Changing the database password

Colin-Albert — Tue, 20 May 2014 11:51:07 GMT

You could keep the connection details in a separate text file and use a $(include) line to select the relevant connection file. That way the live documents will select the live connection and development dpocuments will connect to the dev data.

Re: Changing the database password

PradeepReddy — Tue, 20 May 2014 11:52:55 GMT

Just create 2 connection strings one for Dev and other for Prod.

Comment out the connection string, in which region u are not working on..

EX:

Assume bellow is the 2 connection strings

Connection_String_Dev

Connection_String_Prod

If u are working in Dev region, use the bellow format

Connection_String_Dev

// Connection_String_Prod

If u are working in Prod region, use the bellow format

//Connection_String_Dev

Connection_String_Prod