Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qliksense Enterprise version + ODBC connection

i am trying to connect to MYSQL database using MYSQL ODBC Driver.

MySQL ODBC driver is installed on server.

I have created USER-DSN in DATA SOURCE(ODBC) and connection is successful.

but when i select ODBC connection from QLIKSENSE while adding data, i am not able to view the connection.

whereas,

when i created SYSTEM-DSN in DATA SOURCE(ODBC) and connection is successful.

and now i can view this connection from qliksense while adding data.


QUESTION :   Why am i not able to view connction in USER-DSN?????

4 Replies
rittermd
Master
Master

I don't know why.  But it does need to be a System DSN.

jonathandienst
Partner - Champion III
Partner - Champion III

A USER DSN is only accessible to the user who created the DSN. Did you create the DSN while logged in on the system account used by the QlikSense server?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

yes USER-DSN is created by same user account as that of qliksense server user account..

jonathandienst
Partner - Champion III
Partner - Champion III

Perhaps a user DSN does not work for a service (much like mapped drives do not work with a service). So you will need a system DSN as mentioned earlier.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein