Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I tried searching for the documetation on how to setup, create tables, views in a database so that I can create users and groups in it. Is there any documetation on requierments on what is needed to be done so that users and groups can be read from a database?
My main goal is to be able to use a email address as a userid. Hopefully the documetation will tell me if it is possible or not.
I'm using Qlikview Enterprise Server 11
Thanks
hey bill
i have created this ODBC user setup as per your attached document and its working fine.
i am able to get my users in QMC
also i am able to assign these users(user1)
odbc users in Named users in Distribute tab and
logged with SSO aplication (SQL/user1) its working fine(i can see qvw files in accesspoint)
SQL\user1(as per your document DSP settings)
my requirement is to assign these odbc groups in named users( Distribute tab)
iam able to assign groups (groupa)
odbc groups in Named users in Distribute tab and
logged with SSO aplication (SQL/user1) its not working fine(i am not able see qvw files in accesspoint)
SQL\user1(as per your document DSP settings)
How can i do this with the OBDC groups?
also i gone through your answer on this thread https://community.qlik.com/thread/21747
(user header.docx) this is what i want to achieve with ODBC groups.
bbt stalwar1 mto stevedark vandith123 can you please check this guys
thank you
sreeranga sane
I have done the Configurable ODBC in DSC but when we mouse over on the star symbol in that console it showing Exception When connecting to Data Source.
We need to consider the above exception.
We are unable see the ODBC connection in the Users ----> User Management tab drop down.
Please can you help me
Thanks
B Rama Krishna
hello rama krishana
have you created ODBC data source with your SQL server?
if not you need to create that in ODBC Data Source Administrator under system the system tab confirm once.
thank you
srp
hi Prasad,
Thanks for your response.
We are using MySQL DB and In the ODBC drive we have 2 types of MySQL drivers - MySQL ODBC 5.3 Unicode Driver and MySQL ODBC 5.3 ANSI Driver
Which one I need to use ?
Thanks
B Rama Krishna
setup as per below link
and i believe it should be MySQL ODBC 5.1 Driver(5.1 or 5.3) and make sure yo have created tables in your database with same setup as mentioned in link.
thank you it is working fine
post your solution how it was solved it may helps others.
Hi,
Here is some files that might help you.
Bill
Thank you Bill for the share, BTW do you have something like this but for LDAP Qlik Sense?
thank you Bill.
But we are unable get the ticket for the user,
http://192.168.1.161/QVAJAXZfc/GetWebTicket.aspx?cmd=<Global method='GetWebTicket'><UserId>SSOTEST/carecoordinator</UserId></Global>
The above URL is correct.
We are using the Configurable ODBC USERS .Can You please let me how to request that users for a session id.