How to connect Qlik sense desktop with MySql Data Source

[#1]

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

[jagan]

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.

[#3]

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

[#4]

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