I am trying to connect Qlik to a MongoDB instance using the SQL interface technology.
I can create a Qlik connector using ODBC and start a query with success.
I'm facing an error when trying to create a user directory connector with the same ODBC connection.
"The user Directory Connector (UDC) is not configured, because the following error occured : Error when validating tables : ERROR [HY000][MongoDB][API] Caught panic : input_text_to_string_w : text pointer was null . Ok("in file 'cstr\\src\\lib.rs' at line 97")"
Is it possible for you to reproduce this use case? Any help would be appreciated.
Regular data loads via ODBC work fine because they query tables normally. However, UDC has stricter requirements on how it reads the schema/metadata, and the current MongoDB ODBC driver (especially the SQL Interface / BI Connector) often struggles with this, causing the “input_text_to_string_w : text pointer was null” panic.
Recommendations:
Best Option – Use a dedicated User Directory Connector type instead of ODBC UDC via SQL/ODBC to MongoDB is not well supported by most MongoDB ODBC drivers. Consider syncing users from a more stable source (e.g. Active Directory, Azure AD, or a SQL database).
If you must use MongoDB:
Try switching to a different MongoDB ODBC driver (Progress DataDirect or Devart ODBC driver sometimes handle schema discovery better).
Make sure your ODBC DSN is configured as a System DSN and test the connection thoroughly in the ODBC Administrator.
Simplify your user table/view as much as possible (minimal columns, no complex data types).
Workaround many teams use:
Load user data from MongoDB into a QVD or temporary table using a normal load script.
Then create a Custom User Directory Connector or use Qlik Application Automation to sync users.
Would you be able to share:
Which MongoDB ODBC driver and version you’re using?
