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
This is what the help says about it.
The Configurable ODBC directory service provider can connect to ODBC databases. This folder includes only a General tab.
The ODBC database has to have two tables, or two views; one for entities and one for groups. Theentity table has to contain the following fields:
The groups table has to contain the following fields, which together create a unique identifier:
To add a Configurable ODBC entry, click on the Add icon, , to the right in the pane, and configure the following text boxes:
Note! Valid value(s) must be entered, which might be indicated with a red asterisk and a tool-tip error message.
Hi,
I am trying to connect to MySql database through ODBC driver MySQL ODBC 3.51 Driver.
Do I need to create two tables for entities and groups in MYSQL database?
Currently,I do not have Database Name,Directory Label,Entity Name and Groups Table Database name.
I have the ip of the database and username and password.
Hi,
Can you tell how groups table is used? I have created a group table and mapped it in ODBC Configurable section. I have an entry in group table but that doesn't show up in Users tab in QMC. Also, I am not able to search that group in QMC. I can see users i have in entity table but not groups. Please help.
Rakhi
Hi,
See if this will help.
Bill
Thanks for this share Bill !
Hi there,
I am struggling I am afraid - getting this error?
Andy
hey bill i gone through document that you provided
i did setup as you mentioned in document everything is ok
but one issue is when try try request my server url in browser what is password that i should give i did't setup any pass word while setup
here i believe
in FormLogin.htm
User Name : user1(which we added in entity table)
Password : ?
swuehlgaballesterstevedarkadamdavi3sloveisfaildvqlikviewbbt
HI,
This isn't for authentication it is for authorization. You will have to use sometype of SSO for authentication.
Bill
what was the data inside with you for FormLogin.htm
And Look Section access to give. Even section access don't have the allocated password. you can go and click ok without password. It will work like charm. Would you share script and any section access which you mentioned