Qlik Community

New to Qlik Sense

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
brijeshvma
Partner
Partner

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
brijeshvma
Partner
Partner
Author

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;

View solution in original post

4 Replies
brijeshvma
Partner
Partner
Author

Can some one Please update me on this

Not applicable

brijeshma

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

vishva2000
Contributor II
Contributor II

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
Partner
Partner
Author

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;

View solution in original post