2 Replies Latest reply: Sep 23, 2014 9:21 AM by Sibin Jacob.C C RSS

    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