Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

User Directory Connector - SQL (via ODBC)

Hi All,

I'm trying to create User Directory Connector through SQL (via ODBC), which should connect to SQL server database to retrieve Users and Users Attributes, but I'm getting configuration errors:

UDC.JPG

I've been on following link but no lock!

https://help.qlik.com/en-US/sense/3.2/Subsystems/ManagementConsole/Content/user-directory-connectors...

Attached Trace file.

1 Reply
rbpeterson2
Contributor III
Contributor III

I'm in the same boat - did you ever resolve?

I feel I'm getting a little bit closer user the following connection string parameters:
Uid as user id

Pwd as password

PORT as port

I'm used to a connection string utilization in application form so where I would normally have my server address and then the port (Server=ipaddress, port) doesn't work. 

I still get a Time Out error but not getting the above error from your screenshot any more ... I believe my error lies in the "Driver" piece of the connection string of which I'm not familiar where to lookup the different driver names...