Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Thanks.
Authentication and authorisation are independent of each other in QlikView. This means that ticketing will work without a directory service connector but if you like to use any of the data in the membership database for authorisation then you need to connect to the database using a directory service connector to ODBC.
Regards
Fredrik
I am connecting to Database using directory service connector to ODBC. Is there any other settings I need to take care?
Webticket and Configurable ODBC must be configured independently.
The only relevant thing is that the format of the full username should be consistent.
In other words, if you create an Configurable ODBC, full username will "Directory label value" \ "Entity name row value."
Example:
DSC Configuration
Label Directory "DirectoryTest"
Entity name: "Name"
Entity table: "entity"
Groups table "groups"
entity Table
entityId Name descr email
1 User1 John John@test.com
2 User2 Amy amy@test.com
The Qlikview usernames will: DirectoryTest\User1, DirectoryTest\User2.
Therefore tickets must be ordered for those usernames.
Pablo.
I tried it. It does not work.
Cheers,
Rakhi Agrawal
Senior Tax Consultant| TMC
Deloitte Tax LLP
Tel/Direct: +1 (214) 840 7253 | Mobile: Tel/Direct: +1 469 502 0554
rakhiagrawal@deloitte.com<mailto:rakhiagrawal@deloitte.com> | www.deloitte.com
Please consider the environment before printing.
You can test manually, in the browser, with the following URLs.
http://server/QvAjaxZfc/GetWebTicket.aspx?cmd=<Global method='GetWebTicket'><UserId>Test\User1</UserId></Global>
The server will return a ticket
<Global>
</Global>
Then you must create a URL with a webticket and access to Qlikview Access Point or .qvw
(Access Point)
(Qvw )
Pablo.
Hi Rakhi,
What is the error you are getting?. Are the tickets getting generated or getting invalid error.
Hi Pablo,
I have an issue with the web ticket
1. I am getting the ticket generated for the user.
2.. when i tried to validate the ticket i am getting message as login failed . I have used the same URL
3. Also i am trying to pass values for list box. But the values are not getting selected . The url looks like
Any idea why the parameters are not getting selected in iFrame it would be really helpful if someone could share the information
Brindlogcool,
is the user authorized to access the .qvw application?
Can you access to user Access Point? (http://server/QvAJAXZfc/Authenticate.aspx?type=html&webticket=pi9W5RTq7mGH7ByffuCBqhJ83OMCpRccs/sL/U...)
You can encode the TryURL. with http://meyerweb.com/eric/tools/dencoder/.
For example
TryUrl : /QvAJAXZfc/opendoc.htm?document=Application.qvw&select=LB1,1
TryEncodedUrl : %2FQvAJAXZfc%2Fopendoc.htm%3Fdocument%3DApplication.qvw%26select%3DLB1%2C1
General URL: http://server/QvAJAXZfc/Authenticate.aspx?type=html&webticket=pi9W5RTq7mGH7ByffuCBqhJ83OMCpRccs/sL/U...
Pablo
Hi Pablo,
Thanks for the quick response. Really appreciate it
I have access to all the documents.
Little bit improvement in it. When i try below url in browser it is redirecting to the Access point home page and not getting failed. But the same is getting redirecting correctly to the document in iframe. it is kind of confusing.
server/QvAJAXZfc/authenticate.aspx?typehtml&webticket=prsadasfdfdsf=/QvAJAXZfc/opendoc.htm?document=a.qvw&select
How to validate the ticket which is generated.
I will check the encoder and confirm it.