I want to start with Qlik sense desktop to test its features. My data source is mysql running on centos 7 linux server. In order to connect to this database, I selected MySql Enterprice Edition in the first step pf the "Add data" process. I filled out the form with correct info (I checked host, username and password) to connect to database. But it gives error message with description: general error! How can I gain more info about the error to see the connection problem? How can I resolve the problem? Any help will be appreciated.
You can install the MySQL odbc connector and then you can create a system (or user) DSN connection in windows ODBC manager. Just make sure to configure correctly either 32 o 64 bit depending on your needs,