Non-Unique User Names in SQL ODBC UDC Connector

[pleiker44]

We have an SQL-based ODBC user directory connector. The usernames being returned from this user directory connector is non-unique. The same username may be used by two different users. We expected, based on the documentation, that this was supported via the unique ID field in the table definitions. However, when we sync users, users are merged based on username, so only one user record is added in the QMC for each username, even if there are multiple users with different distinct ID fields for that same user.

Does anyone know how to get this to work for our user case where usernames are not unique. In the ODBC example, it says "If the user IDs are unique, the ID column is redundant.", which is not our case http://help.qlik.com/en-US/sense/June2019/Subsystems/ManagementConsole/Content/Sense_QMC/ODBC-exampl...

Here is an example of two user records with the same username as returned from the "User" table (view) query.

Here are attributes for those users and the resulting user records as shown in the QMC.  User records are merged, which is not what we want.