Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
avinashkk696
Contributor III
Contributor III

USER Directory Connector Error.

Hi,

I have an issue regarding the User Directory Connectors. I have created an ODBC connection for SQL and tried to create User Directory Connector SQL(Via ODBC). Below is the screen Shot of the Connector I have created. But I am still getting an error. I have tried many things but I could not resolve it. I could not see any issue with the connection. But still still it is not working..Kindly help me with it.

1.JPG

Thanks in Advance...

1 Solution

Accepted Solutions
avinashkk696
Contributor III
Contributor III
Author

Hi Bilal,

I have found the solution for my problem. This worked fine after making the following changes.

1. Removing the database name and schema from table 1 and table 2

2. Including Uid={};Pwd={} at the end of the string providing username and password

View solution in original post

4 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Avinash,

Please refer below  Thread it may help you:

User directory Connectors (UDC) in Qlik Sense

Thanks,

Arvind Patil

chaudharybilal
Partner - Contributor III
Partner - Contributor III

Hi Avinash,

We had a similar problem connecting to Teradata. Can you add the port in connection string as well ? We had missed the port number from connection string and were facing the same issue, but after adding the port the UDC worked just fine.

avinashkk696
Contributor III
Contributor III
Author

Hi Arvind,

Thanks for your reply. That thread was really helpful but even if I configured it the same way, I was getting the error. I was thinking if I was missing any inverted comas while giving the server name or database name. Or do I need to specify the username and password?? If so, how?? Any help on that is highly appreciated.

Thanks.

avinashkk696
Contributor III
Contributor III
Author

Hi Bilal,

I have found the solution for my problem. This worked fine after making the following changes.

1. Removing the database name and schema from table 1 and table 2

2. Including Uid={};Pwd={} at the end of the string providing username and password