0 Replies Latest reply: Feb 14, 2017 6:49 PM by Imane EL HASSANI RSS

    Excel connection via ODBC - duplicate records

    Imane EL HASSANI

      Hi everybody,

       

      I'm trying to set up an Excel connection via ODBC to import new users to a QlikSense server.

      The server uses the default windows authentication, so I created local user accounts in windows, set up passwords etc..

      In the QMC I successfully created the UDC, the sync retrieves all the users I have added to the Excel file, all are displayed on the User Management tab.

       

      However, when a user connects to the hub for the first time, a new record is created for that user, with the same user ID that was previously created with Excel sync, and a different User directory. So I have two rows displayed for the same user, one from Excel sync, and the second from its connection to the hub

      .

      duplicate_records.PNG

      I suppose we should have a single record for each user? Since licenses must be allocated afterwards.

      Did I miss something in the configuration? or is this the expected behavior?

      Thanks for your support.