Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Using free version of qlik sense desktop with remote database.

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.

1 Solution

Accepted Solutions
rohitk1609
Valued Contributor II

Re: Using free version of qlik sense desktop with remote database.

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

5 Replies
okolyug16
Contributor II

Re: Using free version of qlik sense desktop with remote database.

lakshmikandh
Valued Contributor II

Re: Using free version of qlik sense desktop with remote database.

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

MVP & Luminary
MVP & Luminary

Re: Using free version of qlik sense desktop with remote database.

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
Contributor II

Re: Using free version of qlik sense desktop with remote database.

Hi,

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

Then only  your able to access that database from QlikSense

rohitk1609
Valued Contributor II

Re: Using free version of qlik sense desktop with remote database.

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