topic Re: Reloading Password - Protected Model through batch file in QlikView

Reloading Password - Protected Model through batch file

skzwane01 — Mon, 17 Sep 2018 06:28:29 GMT

Hi,

I am currently reloading a password-protected qlikview model manually. I would like to automate the process by running the model through a batch file.

I need help on how to run a batch file that will automatically reload the Password-Protected Qlikview model.

Your assistance will be highly appreciated.

Kind Regards,

Sanele Zwane

Re: Reloading Password - Protected Model through batch file

marcus_sommer — Mon, 17 Sep 2018 14:25:54 GMT

I assume with password protected you mean section access. If possible switch the section access from user+password to NTNAME and add your user to it. If this isn't possible you will need a VBS batch to be able to specify a user and a password, see: Re: open document from command line‌

- Marcus

Re: Reloading Password - Protected Model through batch file

skzwane01 — Tue, 18 Sep 2018 05:48:06 GMT

So basically one of the datasources is a password-protected ODBC connection not necessarily Section Access. The username and password are only prompted when one tries to reload or add an additional datasource.

I would like to incorporate the username and password on the batch file so it runs automatically but still want the password to be prompted for any manual reload and scripting.

Re: Reloading Password - Protected Model through batch file

marcus_sommer — Tue, 18 Sep 2018 06:51:21 GMT

You need to include user+password within your connection-string: Passing userid and password to ODBC Connection.

- Marcus

Re: Reloading Password - Protected Model through batch file

skzwane01 — Tue, 18 Sep 2018 06:57:38 GMT

Thanks Marcus for the assistance