Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks in Advance...
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
Hi Avinash,
Please refer below Thread it may help you:
User directory Connectors (UDC) in Qlik Sense
Thanks,
Arvind Patil
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.
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.
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