topic Re: Configurable ODBC in QlikView

Configurable ODBC

rmarino14 — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Configurable ODBC

danielrozental — Tue, 11 Sep 2012 19:40:37 GMT

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.

Re: Configurable ODBC

Tue, 15 Oct 2013 07:01:44 GMT

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.

Re: Configurable ODBC

Fri, 14 Nov 2014 15:11:34 GMT

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

Re: Configurable ODBC

Bill_Britt — Tue, 18 Nov 2014 18:51:34 GMT

Hi,

See if this will help.

Bill

Re: Configurable ODBC

Emmanuelle__Bustos — Mon, 09 Nov 2015 22:51:10 GMT

Thanks for this share Bill !

Re: Configurable ODBC

Sat, 05 Mar 2016 18:46:20 GMT

Hi there,

I am struggling I am afraid - getting this error?

Andy

Re: Configurable ODBC

Anonymous — Sat, 01 Apr 2017 14:38:52 GMT

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 : ?

swuehl‌gaballester‌stevedark‌adamdavi3s‌loveisfail‌dvqlikview‌bbt

Re: Configurable ODBC

Bill_Britt — Sat, 01 Apr 2017 16:29:13 GMT

HI,

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

Bill

Re: Configurable ODBC

Anil_Babu_Samineni — Sat, 01 Apr 2017 16:58:59 GMT

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

Re: Configurable ODBC

Anonymous — Fri, 18 Aug 2017 14:59:39 GMT

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

Re: Configurable ODBC

Anonymous — Thu, 07 Dec 2017 19:50:50 GMT

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

Re: Configurable ODBC

Anonymous — Fri, 08 Dec 2017 06:53:43 GMT

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

Re: Configurable ODBC

Anonymous — Fri, 08 Dec 2017 09:11:10 GMT

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

Re: Configurable ODBC

Anonymous — Fri, 08 Dec 2017 10:47:14 GMT

setup as per below link

http://help.qlik.com/en-US/qlikview/November2017/Subsystems/QMC/Content/QMC_System_Setup_DirectoryServiceProviders_ConfigurableODBC.htm

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.

Re: Configurable ODBC

Anonymous — Fri, 08 Dec 2017 12:39:26 GMT

thank you it is working fine

Re: Configurable ODBC

Anonymous — Fri, 08 Dec 2017 12:42:52 GMT

post your solution how it was solved it may helps others.

Re: Configurable ODBC

Bill_Britt — Fri, 08 Dec 2017 13:29:31 GMT

Hi,

Here is some files that might help you.

Bill

Re: Configurable ODBC

Emmanuelle__Bustos — Fri, 08 Dec 2017 20:44:17 GMT

Thank you Bill for the share, BTW do you have something like this but for LDAP Qlik Sense?

Re: Configurable ODBC

Anonymous — Sat, 09 Dec 2017 07:02:08 GMT

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.