Configure UDC for MySql in Qlik Sense

[brijeshvma]

Hi All,

I have a Urgent Need. Kindly Help me to resolve this.

Say I Created 2 Table in MySql database .

User Table:

LOAD `userid`,

    name;

SQL SELECT `userid`,

    name

FROM justtry.`q_user`;

And

Attribute Table:

LOAD `userid`,

    `type`,

    value;

SQL SELECT `userid`,

    `type`,

    value

FROM justtry.`q_attribute`;

And in UDC , I Used  SQL(Via ODBC)

and i created visible connection string :

Driver={MySQL ODBC 5.3 ANSI Driver};Server=172.10.5.146;Database=justtry;Trusted_Connection=yes;dsn=justtry;

But Still i am Getting an Error,

The User Directory connector (UDC) is not configured, because the following Error occured:

Exception When trying to connect to the data source. Edit the connection string in the user directory connector configuration

The User Directory Connector(UDC) is not operational

As Well find the image for Error. Both the Table i can able to fetch using Script Editor.

[brijeshvma]

Can some one Please update me on this

[#3]

brijeshma‌

Did you find a solution for your problem? If so, what needed to change/configured?

[vishva2000]

try connection string as follows

dsn=YourODBC;Server=servername;Database=DBname;uid=userID;pwd=password;

YourODBC is the ODBC name you setup in your ODBC Data Source Administration

Also try Server as Server\InstanceName  (e.g. Servername\SQLEXPRESS , for local db .\SQLEXPRESS)

[brijeshvma · Accepted solution]

I got the solution string

Driver={MySQL ODBC 5.3 ANSI Driver};Server=server Ip Address ;Database= DatabaseName; Uid=userid; Pwd=Database Password ; PORT=3306 ;Trusted_Connection=yes;