Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

rmarino14
New Contributor II

Configurable ODBC

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

Tags (2)
25 Replies
danielrozental
Honored Contributor II

Re: Configurable ODBC

This is what the help says about it.

Configurable ODBC

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:

  • entityid (unique identifier, suitable for primary key)
  • name (string)
  • descr (string)
  • email (string)

The groups table has to contain the following fields, which together create a unique identifier:

  • groupid
  • memberid

Directory Service

Add

To add a Configurable ODBC entry, click on the Add icon, , to the right in the pane, and configure the following text boxes:

  • Path
    To configure the path to the directory service, click on the Get Default icon, , to use the default path, or enter a valid path in this text box.
    Default value: ODBC://localhost.
  • User Name
    To configure the user name used for accessing the directory service, enter the desired credentials in this text box.
  • Password
    To configure the password used for accessing the directory service, enter the desired credentials in this text box.
  • Settings
    To configure the Directory Service Provider (DSP) Settings, open the dialog by clicking on the Edit icon, , and enter the desired values in the following text boxes:
    • Cache Expiry in Minutes
      Set the time for how long the queries to the directory service should be cached.
      Default value: 15 (minutes).
    • Connection Database Name
      Set the name of the ODBC database to connect to.
      Default value: dbname.
    • Data Source Name
      Set the name of the ODBC driver.
      Default value: MySQL ODBC 5.1 Driver.
    • Directory Label
      Set the label of the directory service to connect to.
      Default value: DB DSP.
    • Entity Name
      Set the name of the entity to connect to.
      Default value: entity_name.
    • Entity Table Database Name
      Set the name of the entity table to connect to.
      Default value: entity.
    • Groups Table Database Name
      Set the name of the table named groups to connect to.
      Default value: groups.
    • Override Connection String
      If entering a string in this field, the entered value will be used, while the settings in User Name,Password, Connection Database Name, and Data Source Name will beignored.
      Default value: Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\AccessTest.accdb;.
    • Service Timeout in Seconds
      Set the timeout for the connection to the directory service.
      Default value: 30 (seconds).

Note! Valid value(s) must be entered, which might be indicated with a red asterisk and a tool-tip error message.

Not applicable

Re: Configurable ODBC

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.

Not applicable

Re: Configurable ODBC

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

Employee
Employee

Re: Configurable ODBC

Hi,

See if this will help.

Bill

Emmanuelle-Bustos
Valued Contributor

Re: Configurable ODBC

Thanks for this share Bill !

Not applicable

Re: Configurable ODBC

Hi there,

I am struggling I am afraid - getting this error?

Andyerror.png

sreerangasane
New Contributor III

Re: Configurable ODBC

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

Employee
Employee

Re: Configurable ODBC

HI,

This isn't for authentication it is for authorization. You will have to use sometype of SSO for authentication.

Bill

Re: Configurable ODBC

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