Using free version of qlik sense desktop with remote database.

[#1]

Hello.  New user trying to use free destop version of qlik sense desktop.  Is it possible to connect qlik sense desktop to a remote version of mysql running on aws?  What would be the steps to do so, and does this involve the qlik connectors?  Any help would be much appreciated.

[Anonymous]

See if this helps MySQL Enterprise Edition ‒ Qlik Connectors

[lakshmikandh]

Hi,

Desktop version connect to MySQL Please ensure your server is external IP / name accessible from system where you have installed the desktop version and the required ports for connecting to the MySQL are enabled in the server.

Hope this Helps,

Thanks,

Lakshmikandh

[jagan]

Hi,

If you are able to access the database from your PC/laptop then you can also connect from Qliksense to that database.

Regards,

Jagan.

[millan123]

Hi,

Are you able to access that database form your laptop /System ??

Then only  your able to access that database from QlikSense

[rohitk1609 · Accepted solution]

Hi Andy,

MYSQL database is on AWS cloud space and I am sure the AWS server comes under your network I mean you can access it by your user credentials .

Now Download drivers of MYSQL databse with respect to your operating system and go to administrator tools and go to system DSN then create a new connection with MYSQL installed drivers and test it once and if it is showing you OK then open your Qlik Sense Desktop and create an new app and new connection , Choose OLEDB and you will find the same newly created connection you made earlier and select it and choose your desired tables and import the data to Sense.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Rohit Kumar