Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Binary load from a QlikView document that requires username and password

Does anyone know the syntax for a BINARY statement in the loadscript if the QlikView document you want to load requires a username and password? I can't enter the username and password interactively - can it be passed as a parameter to the Binary statement?

3 Replies
Miguel_Angel_Baeyens

Hello Tim,

Have you tried creating a section access with the same values that in the file that is being loaded and do the binary load?

Hope that helps.

EDIT: Obviously this doesn't make any sense, since the idea is to avoid entering the username and password... Forget about it. But adding the NTNAME of the loader would work, if there are only NTNAME fields in the section access of the document to be binary loaded.

Not applicable
Author

For anyone interested,    I was able to make this work by only doing a binary load on documents with section access defined and using the same username and password as the loading document.

Not applicable
Author

Hi Tim,

What version/SR was this on? I tried using the same USERID/PASSWORD for both the source and the loading .qvw, but it still prompts me for a USERID and PASSWORD. This was on both V10 SR2 and V9 SR7.

Thanks