topic Re: Error when creating User Directory Connector using SQL (via ODBC) in Management & Governance

Error when creating User Directory Connector using SQL (via ODBC)

nurfatenmunirah — Wed, 30 Aug 2017 04:32:52 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

Re: Error when creating User Directory Connector using SQL (via ODBC)

m_s — Thu, 31 Aug 2017 08:20:09 GMT

Hello Nur Faten,

maybe you don't have the SQL Server Native Client 11.0 Driver installed on Qlik Sense Server. You can try Driver={SQL Server}; and if that does not work install the SQL Server ODBC driver.

I would also remove the database name and schema from the table names:

User table name: [External_Users]

Attribute table name: [External_Users_Attributes]

Re: Error when creating User Directory Connector using SQL (via ODBC)

nurfatenmunirah — Mon, 11 Sep 2017 01:37:22 GMT

Thank you for your reply Mathias.

I found the error and I have corrected it already and finally it works. There is nothing wrong with the connection string. The only mistake I made is that Qlik couldn't read the table because of the column name in my SQL table. The column name must be the same as in the example in this link ODBC example ‒ Qlik Sense.

Thanks.