Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to connect Qlik sense desktop with MySql Data Source

hello,

I want to connect Qlik sense desktop with MySQL  data source, So could anyone  please tell me how to do this?,

please provide step by step process to establish connection with MySQL.

thanks....

3 Replies
MVP
MVP

Re: How to connect Qlik sense desktop with MySql Data Source

Hi Piyush,

You can connect MySQL database by using ODBC or OLE DB connection.  Check this link hope it helps you.

https://community.qlik.com/message/650955#650955

Regards,

Jagan.

Not applicable

Re: How to connect Qlik sense desktop with MySql Data Source

Hi Piyush,

You may also want to look at the ODBC Connector add-on provided by Qlik that makes it easier to connect to popular data sources including MySQL.

More information can be found at: ODBC Connector

Hope this helps.

Rod

Not applicable

Re: How to connect Qlik sense desktop with MySql Data Source

Hi Piyush,

Follow the 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.

Thanks

Avinash