topic Re: Qlik Sense ODBC Connector Problem in Integration, Extension & APIs

Qlik Sense ODBC Connector Problem

Mon, 23 May 2016 22:24:03 GMT

Hi Everyone,

I am facing problem while i am creating the (ODBC) connector in USER DIRECTORY CONNECTOR LIST, i am using My SQL Server so i need to get the users List from there so i am Using ODBC connector . in that i am having two tables

1. bi_User_list

2. bi_attribute_List.

i have attached the error message. but if i am loading the table in the script editor i can able to load . please help me

Thanks in Advance,

Ramarajan.

Re: Qlik Sense ODBC Connector Problem

konrad_mattheis — Tue, 24 May 2016 05:51:34 GMT

Hi Ramarajan,

I belive your layout of the tables bi_User_list & bi_attribute_List.

Please attach the layout and 1-2 data samples in the thread.

bye Konrad

Re: Qlik Sense ODBC Connector Problem

Tue, 24 May 2016 12:21:56 GMT

Hi Konrad Mattheis,

PFA I have attached two tables in that Excel File.

Many Thanks.

Re: Qlik Sense ODBC Connector Problem

konrad_mattheis — Tue, 24 May 2016 13:50:16 GMT

Hi,

thats clear, the tables have to have the following layout:

bye Konrad

Re: Qlik Sense ODBC Connector Problem

Tue, 24 May 2016 14:09:17 GMT

Hi @Konrad Matthies,

1. I needs to follow only the structure of the table only,

2. the value of the field also I need to follow like "admin.konrad.mattheis" ?

thanks.

Re: Qlik Sense ODBC Connector Problem

konrad_mattheis — Tue, 24 May 2016 14:32:48 GMT

Hi,

1. yes you need only the structure

2. you can define the userid like you want, this is just my personal sample.

bye Konrad

Re: Qlik Sense ODBC Connector Problem

Wed, 25 May 2016 17:03:40 GMT

Hi Mattheis,

Many Thanks,

i got it , i have one small doubt if i was assigning the token to that users, how it will Authenticate, whether it will ask Username and Password or how it will work please explain little bit ?

Thanks,

Ramarajan M

Re: Qlik Sense ODBC Connector Problem

konrad_mattheis — Thu, 26 May 2016 09:17:02 GMT

Hi,

you have to authenticate the persons over ticket / saml authentication.

Username/Password is only with Windows Authentication in the standard possible.

For the rest you have to write own things.

bye Konrad

Re: Qlik Sense ODBC Connector Problem

Thu, 26 May 2016 14:10:36 GMT

Hi Mattheis,

Sorry I am not getting can please explain, which password I need to use to logging to the hub.

Thanks,

Ramarajan m.

Re: Qlik Sense ODBC Connector Problem

konrad_mattheis — Mon, 30 May 2016 14:33:58 GMT

Hi,

you can use passwords that are stored in the Windows System /local or Active Directory, OR you have to create a complete own user / password check website.

bye Konrad