On-premises Microsoft Mysql to connect with QlikSaaS/Cloud

[fatinfazrizanor]

Hi,

im trying to look for any article or guideline to connect on-premises microsoft mysql to QlikSaaS.

I only find the article from Qlikhelp: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/SourcesC...

Im not sure if this is the right article i should refer, because i not familiar with on-premises mysql environment.

Please help me if there is any article or guideline for this. Thanks in advance.

[Ralf-Narfeldt]

The help article that you quote describes how to connect to a MySQL source in Qlik Cloud Data Integration, using the Data Gateway - Data Movement. You can deliver data ready for consumption to Qlik Cloud or to cloud data warehouses. The data can be kept up-to-date without manual intervention, and you can create a data pipeline and perform fit-for-purpose transformations and create data marts. If this is what you are after, I suggest you read more under: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Introduc...

You can also read data directly from MySQL into your Qlik Cloud app. More about this connectivity here:
https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/My...

[fatinfazrizanor]

Hi Ralf,

actually my objective is to read data directly from on-premises MySQL into Qlik Cloud app. Based on this article https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/My... , does this mean i need to connect via Direct Access Gateway?

Thanks for your help 🙂

[Ralf-Narfeldt · Accepted solution]

If your MySQL database can be reached from outside through a port, you can connect to it directly without Direct Access Gateway. Just create a new app, and in the Add data dialog, connect to the MySQL database using the host name, port and credentials.
https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/My...

But if it is behind strict firewall policies, Direct Access Gateway can provide secure access over a strictly outbound, encrypted, and mutually authenticated connection.
https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/direct-access-g...