Non-Unique User Names in SQL ODBC UDC Connector

pleiker44 — Sat, 16 Nov 2024 05:21:24 GMT

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-example.htm

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.

topic Non-Unique User Names in SQL ODBC UDC Connector in Management & Governance

Non-Unique User Names in SQL ODBC UDC Connector