Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
sbkumar
Creator
Creator

how to conenct Mysql with qliksense?

i have installed  qlik sense desktop tool and mysql server community edition on my system .How to conenct qliksense with Mysql?i have installed Mysql Odbc driver also.

1 Solution

Accepted Solutions
shraddha_g
Partner - Master III
Partner - Master III

Try below steps:

  • Go to Administrative Tool ->ODBC Data Sources(64bit/32bit)
  • Select System DSN -> Add..
  • Show you the Available Servers. Select one and “Finish”
  • Give Name of the Connection and server name ex: 10.x.x.xx\XXXMDPPRODTRXXX
  • Click “Next”
  • Select the SQL server authentication and provide Credentials
  • Change the setting as per the requirement and ‘Finish’
  • Go to Qliksense App and Select ‘Create New Connection’  ->  ODBC
  • You see the Connection name as below. Select the connection and provide the credentials provided while creating the connection.
  • Click Save and you are done with the Connection.

View solution in original post

2 Replies
shraddha_g
Partner - Master III
Partner - Master III

Try below steps:

  • Go to Administrative Tool ->ODBC Data Sources(64bit/32bit)
  • Select System DSN -> Add..
  • Show you the Available Servers. Select one and “Finish”
  • Give Name of the Connection and server name ex: 10.x.x.xx\XXXMDPPRODTRXXX
  • Click “Next”
  • Select the SQL server authentication and provide Credentials
  • Change the setting as per the requirement and ‘Finish’
  • Go to Qliksense App and Select ‘Create New Connection’  ->  ODBC
  • You see the Connection name as below. Select the connection and provide the credentials provided while creating the connection.
  • Click Save and you are done with the Connection.