Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello all
I'm trying to create a user directory connector in the sense server via MySql.
I'm user the fallowing connection string "Driver={MySQL ODBC 5.3 Unicode Driver};Server=server;Database=db;Uid=db; Pwd=pwd;PORT=3306;
but not getting anywhere.
the are 2 tables ready there for users and attributes but i can't get pass the connection set up.
odbc connector is up and running so what am i missing here?
Hi Doron,
Check whether the QMC root admin had read access to the MySQL Data source.
To copy and paste from an article we have in our customer / partner knowledgebase:
The key elements that you will need are going to be:
Keep in mind:
The user table requires the following fields and only those fields: userid and name.
The attributes table requires the following fields and only those fields: userid, type, value.
Once those elements are in place, you are ready to setup the UDC.
If you encounter an error message that "The User Directory Connector(UDC) is not configured, because the following error occurred: Exception when trying to connect to the data source. Edit the connection string in the user directory connector configuration. It is possible that some text was saved in the Encrypted connection string area. Try entering a semi-colon (;) and saving the UDC.
If you encounter further problems then the best log for troubleshooting will be the UserManagement Repository log found in C:\ProgramData\Qlik\Sense\Log\Repository\Trace\.