topic Re: How to use ODBC groups in Distribute tab in QlikView

How to use ODBC groups in Distribute tab

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hi community

i have created this ODBC user setup as per qlik help docs (https://help.qlik.com/en-US/qlikview/12.1/Subsystems/QMC/Content/QMC_System_Setup_DirectoryServiceProviders_ConfigurableODBC.htm)

here is my sample data in database

qmc screen

i am able to get my users in QMC

also i am able to assign these users(stevej)

in Named users in Distribute tab.

and logged with SSO aplication with username (DBDSP/stevej) its working fine(i can see qvw files in accesspoint)

Note: DBDSP\stevej(as per my DSP settings)

my requirement is to assign these odbc groups in named users( Distribute tab)

iam able to assign groups (managergroup )

odbc groups in Named users in Distribute tab and

logged with SSO application with username (DBDSP/stevej) its not working (i am not able see qvw files in accesspoint)

Note: DBDSP\stevej(as per my DSP settings), this username "stevej" is assigned to managergroup group

How can i do this with the OBDC groups?

bbt‌stalwar1‌mto‌loveisfail‌vandith123‌Configurable ODBC‌stevedark

Re: How to use ODBC groups in Distribute tab

binujose1982 — Tue, 23 Apr 2019 23:43:22 GMT

Hi,

I am also having same issue. I am able to distribute to individual user id's.But group distribution is not working.

Have you got any solution for the group distribution?

Regards,

Binu

Re: How to use ODBC groups in Distribute tab

binujose1982 — Tue, 23 Apr 2019 23:47:38 GMT

I have changed Qlikview server security to DMS authorization and its working fine for me.

Thank you

Binu

Re: How to use ODBC groups in Distribute tab

felipe_dutra — Wed, 24 Apr 2019 02:10:33 GMT

https://support.qlik.com/articles/000070620

Re: How to use ODBC groups in Distribute tab

binujose1982 — Wed, 24 Apr 2019 04:53:18 GMT

Thank you.

It works with header authentication and DMS authorization.

Re: How to use ODBC groups in Distribute tab

Brett_Bleess — Tue, 18 Jun 2019 18:19:49 GMT

Just wanted to confirm that if you are using Configurable ODBC Directory Service Provider, that you will likely need to have QlikView Server Security tab settings set to use DMS security mode in order for the group resolutions to occur properly, as if QVS is in NTFS security mode, it is relying on Windows for Authorization and resolving of users/groups. In general, most customers do also use Header Authentication method in the QVWS resource as well in these cases, as generally the reason for the Configurable ODBC DSP is due to using Oracle Authentication Manager or other DB related SSO front-ends, and they want to make use of those rather than using Windows Active Directory... Hopefully this adds a bit further clarity to things.

Regards,
Brett