User Directory Connector - SQL (via ODBC)

Fri, 02 Apr 2021 08:01:35 GMT

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:

I've been on following link but no lock!

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

Attached Trace file.

Re: User Directory Connector - SQL (via ODBC)

rbpeterson2 — Mon, 06 Nov 2017 15:23:41 GMT

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

topic Re: User Directory Connector - SQL (via ODBC) in Connectivity & Data Prep

User Directory Connector - SQL (via ODBC)

Re: User Directory Connector - SQL (via ODBC)