We are also using WebTicket with DMS. We have a table in a database and validate users from the login form.
Once validated the user, the form requests a ticket to a QlikView and passes this to the document.
In document are using ntname, follows
LOAD UPPER (ACCESS) ACCESS AS,
UPPER (NTName) AS NTName
$ (v_QVDPropio_Path) \ USUARIOS.qvd (qvd);
Use NTName and ACCESS fields. These two data need to be accessed by WebTicket.
I hope my answer is helpful, but do not hesitate to contact me.
This is very helpful!
My question is, if you just use ACCESS and NTNAME in the section access, then how do you set up the reload on the server? It asks for a username and password - it has to match an entry in section access. A blank password worked before I changed to NTNAME, and I just put in ADMIN as the username. But now it seems that I need the NTName of the account that will run the reload? Is that correct?
I think that your case is a little bit different because of the extranet server, however I think you can still use NTNAME or USERID (you can use this if the NTNAME cause you conflict with the extranet server), just to passing this data to the webticket (Just like Guillermo Said). Besides if you don't want this double authentication (Webticket and then when you open the QVW), you can disable the field PASSWORD in section access.
This way, once webticket gets the NTNAME/USERID and ACCESS, then the document will open without asking again for credentials and displaying just the information that user is allowed to see,
hi lornafnb i am facing same issue when i logged through sso(Web ticket process)
i am unable to see APPS(which has section access) in access point
i am able to see other apps
how you resolved it please let me know
I've removed Password from the section access...
But....section access doesnt work correctly...
I have an Admin user that can override all...so I need the Password for verification, otherwise anyone can sign on as Admin....
so now neither the ADMIN or a 'normal' user can log on....
thanks a ton
Removing the password and using NTNAME as parameter in section access, makes that you won't need a password for login to the app, but only users logged with their Active Directory (windows) account will be able to see their corresponding data. Admin, will be able to override this security, because as its name says it is an Administrator,
Thanks for your responses guys, this is starting to make more sense!
This is my current section access script (will replace this with a SQL lookup in future):
LOAD * INLINE [
ACCESS, USERID, Customer_ID
ADMIN, ADMIN, *
USER, email@example.com, 500475
USER, firstname.lastname@example.org, 153488
USER, email@example.com, 153489
So Guillermo, we should be using NTNAME? I believe that a domain needs to be prefixed on the NTNAME in section access - How should the NTNAME field be formatted?
LOAD * INLINE [
ACCESS, NTNAME, Customer_ID
ADMIN, ADMIN, *
USER, ???????\firstname.lastname@example.org, 500475
USER, ???????\email@example.com, 153488
USER, ???????\firstname.lastname@example.org, 153489
Also, are the following settings correct for this method?
The change to NTNAME in section access solved my issue!
For future reference (for anyone else trying to work this out), the url I ended up using for accessing directly to a QVW after retrieving a web ticket:
I appreciate your help Guillermo and Jaime, thanks to you both!
I am facing some issue while I am implementing WEbticket method to access Qlikview document..
Here is the details...
I have configured out QVWS as below:
Login Address: Alternate Login page
I have below urls to access the document on the server...
Loadbalancer one is:
Actual one is:
I was succesfull getting the webticket form above server, then I am trying to redirect to url as you mentioned above..
Then I am getting just "loading....... ", but it never completed loading the page , but when I saw the view source, I could see that all the html content..
Please could tell, am I missing something else.
Your help is really grateful to me and appreciated.
I'm having exactly the same challenge as you were with this one...
after reading Guillermo's post...my understanding is that the NTNAME field can hold ANY data...i e lets say the user logs in on some site with a username (eg User1) and the webticketing thing is then done...in Section access you will still use NTNAME and that will contain that User1.
am I understanding this correct?
I am having some issues when implementing Web Ticket. I am using membership database to authenticate user in My Web application. Then I am generating tickets and creating URL to redirect to my qlikview document. I need to know if need to change directory service connector to configurable ODBC to make it work.