Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

brijeshma
Contributor

Configure UDC for MySql in Qlik Sense

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.

1 Solution

Accepted Solutions
brijeshma
Contributor

Re: Configure UDC for MySql in Qlik Sense

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;

4 Replies
brijeshma
Contributor

Re: Configure UDC for MySql in Qlik Sense

Can some one Please update me on this

Not applicable

Re: Configure UDC for MySql in Qlik Sense

brijeshma

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

vishva2000
New Contributor

Re: Configure UDC for MySql in Qlik Sense

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)

brijeshma
Contributor

Re: Configure UDC for MySql in Qlik Sense

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;