topic Re: Encrypt the user and password in string connection in QlikView

Encrypt the user and password in string connection

fkeuroglian — Wed, 20 Aug 2014 18:14:19 GMT

Hi people

i have a question, i have an include that use a txt that contains the string connection, for example this is my string conection in a txt

OLEDB CONNECT TO [Provider=IBMDASQL.DataSource.1;Persist Security

Info=True;User ID=usertest;Data Source=SERVER;Protection Level=None;Xml Strip

Whitespace=True;Password=1234];

is there a way to encrypt the user and the password?

thank you a lot

Fernando

Re: Encrypt the user and password in string connection

tresB — Thu, 21 Aug 2014 07:26:37 GMT

This should be done at driver-end you use (OLEDB for you). Refer: Re: User and password encryption in odbc string

Re: Encrypt the user and password in string connection

ashfaq_haseeb — Thu, 21 Aug 2014 07:32:35 GMT

Hi,

In your edit script --> Setting tab --> make sure scramble user credentials is selected.

Have a look at the attached image.

Regards

ASHFAQ

Re: Encrypt the user and password in string connection

jonathandienst — Thu, 21 Aug 2014 07:36:44 GMT

You can also put the connection string in a hidden script tab

HTH

Jonathan

Re: Encrypt the user and password in string connection

ashfaq_haseeb — Thu, 21 Aug 2014 07:38:57 GMT

Hi,

Then handling multiple connection with multiple database will be more difficult.

Unless we move entire code to hidden script.

Regards

ASHFAQ

Re: Encrypt the user and password in string connection

jonathandienst — Thu, 21 Aug 2014 07:48:57 GMT

Ashfaq

That's no problem. Create one or more SUB routines in the hidden tab (one per unique connection) and CALL the relevant subroutine to make the connection.

Jonathan

Re: Encrypt the user and password in string connection

ashfaq_haseeb — Thu, 21 Aug 2014 07:56:05 GMT

Thanks

I learned something new.

Regards

ASHFAQ