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
This is what the help says about it.
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:
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.
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.
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
User Name : user1(which we added in entity table)
Password : ?
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