Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Configurable ODBC - read from excel file

Hello!

I am trying to set up a configurable ODBC to read from excel file with two tabs: entity (containing columns entityid, name, descr, email) and groups (columns: groupid, memberid) as described in manual. Still the below settings seem not to work. I receive no errors (red star) but when I try to search for users, no results are returned on Users tab.

I have set up a system DSN with name TESTDCS.

I do not know what exactly should be put in Directory Label field and also if tab names (from excel file) should be used in Entity and Groups table db name fields.

Has anyone managed to set up a configurable ODBC properly? Any ideas what am I doing wrong?

Thank you in advance!

ScreenHunter_01 Nov. 07 10.53.gif

2 Replies
amien
Valued Contributor

Re: Configurable ODBC - read from excel file

Did you ever got this working? Can you share it? Thanks

sibin_jacob
Contributor III

Re: Re: Configurable ODBC - read from excel file

HI Amien,

Please give the Entity name as `name `, Entity table db name as `entity$` and Groups table db name as `groups$`.

I am using Qlikview 11.0 and it is working fine for me. Please find the attached Scrrenshot.

Thanks,

Sibin Jacob. C

Community Browser