topic Batch File user and password for QlikView in QlikView

Batch File user and password for QlikView

stevietm — Mon, 04 Jul 2011 11:35:07 GMT

Hi QlikView People

I Have created a batch file witch runs my QlikView model fine, but when i run my model like that my user id and password pops up..Haw can i tell my batch file to insert the user id and password when that comes up, so that i dont have to insert that myself?

Kind Regards Stevie

Batch File user and password for QlikView

Miguel_Angel_Baeyens — Mon, 04 Jul 2011 11:45:36 GMT

Hello Stevie,

It seems your document has section access. You will need to add the user under the scheduled task is running in your section access in order to get it working.

Note that NTNAME (required byt your batch reload) and USERID and PASSWORD cannot coexist in the same section access.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Batch File user and password for QlikView

stevietm — Mon, 04 Jul 2011 14:20:29 GMT

Hi Miguel

I Have no clue what u meant by that im only woorking from a batch file ("C\ProgramFiles\Qlikview\qv.exe") Thats the first part of the batch file that opens qlikview it self then ('C\Qlikview\QlikviewModels\ClinixModels\Stock_May_Beta_V1.qvw') thats the second 1 that opens the model but when the model opens it gives me the userid and password of my qlikview model so what can i use in that batch file so that the batch file automatically puts in the userid and password???

Kind regards

Batch File user and password for QlikView

Miguel_Angel_Baeyens — Mon, 04 Jul 2011 15:31:39 GMT

Hi Stevie,

So you only want to open your file using a .bat file? Did you set only one line in the BAT file and both paths to qv.exe and the QVW file double quoted?

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Batch File user and password for QlikView

Tue, 05 Jul 2011 03:34:33 GMT

Hi,

I guess your current section access might be something like this:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, user1, 123

ADMIN, user2, 456

];

Section Application;

But what you need to do is modify your script as per the below to have a column for NTNAME which is nothing but your windows login user id. Then reload once manually and save the application, after that try reloading from batch file, which shouldnt prompt for user id and password input.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD,NTNAME

ADMIN, user1, 123 , *

ADMIN, user2, 456, *

ADMIN, *, *, yourWindowsUserID

];

Section Application;

Batch File user and password for QlikView

stevietm — Tue, 05 Jul 2011 08:24:09 GMT

Hi BlackRockS

That works but now when i just go into my QV model manualy it does not ask for a UserID and Password...I still need the Username and Password to pop up when someone opens the QV model manualy the batch file is just created so that I dont need to reload it myself,the clients still want the Username and Password on there...Is there maybe a different way to do that??

Kind Regards Stevie

Batch File user and password for QlikView

stevietm — Tue, 05 Jul 2011 08:29:13 GMT

Sorry Guys Made a mistake there that will work because the model wil be on a server and everyone has a different User log in, so that will work thanx for the help guys...

Kind Regards

Re: Batch File user and password for QlikView

Tue, 05 Jul 2011 08:33:55 GMT

Hi Stevie,

As you have seen once your NT id has added it wont prompt for your user credentials but prompts for everybody else.

Even you can try adding others NT id, so only those people can access without entering user id and pwd but for others it will prompt.

Good it helped you.

Batch File user and password for QlikView

Miguel_Angel_Baeyens — Tue, 05 Jul 2011 08:37:49 GMT

Hi,

If you are going to reload the document in the server, don't forget to add as ADMIN the user under the services are running in the QlikView Enterprise Management Console, Documents menu, clicking on the document, Reload tab, Section Access in the bottom part of the page to make sure the reload stores all values without reduction.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica