Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Changing the database password

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

3 Replies
MVP
MVP

Re: Changing the database password

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

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.

pradeepreddy
Valued Contributor II

Re: Changing the database password


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

Community Browser