Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rmarino14
Partner - Contributor II
Partner - 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

25 Replies
Anonymous
Not applicable

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 stalwar1mtostevedarkvandith123 can you please check this guys


thank you


sreeranga sane






Anonymous
Not applicable

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

Anonymous
Not applicable

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

Anonymous
Not applicable

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

Anonymous
Not applicable

setup as per below link

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

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.

Anonymous
Not applicable

thank you it is working fine

Anonymous
Not applicable

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

Bill_Britt
Former Employee
Former Employee

Hi,

Here is some files that might help you.

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Emmanuelle__Bustos
Partner - Specialist
Partner - Specialist

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

Anonymous
Not applicable

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.