Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlikview-Document chining with Section Access

Hi,

we have two documents with Section Access.

What we want to do is open the second document from the first using a URL.

We would like to avoid the prompting for user+password in the second document.

Is there any way to pass the user and password to the second document?

Thanks in advance

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Short answer: no if you are using USERID

In earlier versions of QlikView, as far as I can remember, you could send the username and password via URL header, but right now that is not an option as it would be a massive security breach.

By default, section access uses the same credentials stored for the user who initially open the session, that is, the user who open the AccessPoint. These credentials can be used by cookies or if you are using the IE Plugin or the QlikView Desktop, directly from Windows.

However, in the case of USERID and PASSWORD field in section access, it is QlikView actually handling security, and since section access is a special table within the data model, you cannot pass those username and passwords as selections during the document chaining (like you can with any other field in the model, as long as the field names are the same). There is nothing QlikView can do to "guess" that the requesting user for the chained application is the same than the user who open the source application, so basically when USERID is in the section access, QlikView will always show the prompt.

If switching to NTNAME is not an option, then you still could create something which sends the username and password to that prompt using javascript, but I don't think that is a viable option, as it would be a third party development and nothing to do with QlikView.

NTNAME however works just fine with section access and document chaining because it uses the user security, not QlikView security. So if the user is properly authenticated and is authorized to open the document, it will just happen

View solution in original post

2 Replies
Miguel_Angel_Baeyens

Short answer: no if you are using USERID

In earlier versions of QlikView, as far as I can remember, you could send the username and password via URL header, but right now that is not an option as it would be a massive security breach.

By default, section access uses the same credentials stored for the user who initially open the session, that is, the user who open the AccessPoint. These credentials can be used by cookies or if you are using the IE Plugin or the QlikView Desktop, directly from Windows.

However, in the case of USERID and PASSWORD field in section access, it is QlikView actually handling security, and since section access is a special table within the data model, you cannot pass those username and passwords as selections during the document chaining (like you can with any other field in the model, as long as the field names are the same). There is nothing QlikView can do to "guess" that the requesting user for the chained application is the same than the user who open the source application, so basically when USERID is in the section access, QlikView will always show the prompt.

If switching to NTNAME is not an option, then you still could create something which sends the username and password to that prompt using javascript, but I don't think that is a viable option, as it would be a third party development and nothing to do with QlikView.

NTNAME however works just fine with section access and document chaining because it uses the user security, not QlikView security. So if the user is properly authenticated and is authorized to open the document, it will just happen

Anonymous
Not applicable
Author

Thank you very much Miguel!!!