Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Ruby-Grace
Contributor
Contributor

Need Help with Quick Cloud Data Integration - Connection Issue

I'm attempting to establish a connection between Quick Cloud Data Integration and a source database (MySQL) to pull in some data for a project. However, despite entering the correct credentials and connection details, I keep getting an error message saying "Connection Failed." I've double-checked my username, password, host, and port, and everything seems to be in order.

Login to RapidFS Portal

online payroll management

Allpoint network

rapid! PayCard

Labels (1)
1 Reply
TimGarrod
Employee
Employee

Hi,   I'm assuming you are using a Qlik Data Movement gateway in order to establish replication from mysql to your target platform.   
Please ensure you have installed the required drivers on the gateway server and that the gateway server has access to connect to your mysql source.    After installation of the gateway, there is a driver utility that can be used to download, install and configure the required drivers.

for installing mysql driver, ssh into your gateway server and cd to this path - 

cd /opt/qlik/gateway/movement/drivers/bin

then run 

./install mysql 

(Note you may have to run it via sudo)
Any additional pre-requisites can be found in the help -https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/SourcesConnections/MySQL/prereq-mysql-source.htm
You will need to do this for your target also (e.g. Snowflake / BigQuery etc.).  Please review the pre-requisites for targets here (select your target to review the docs)  - https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetCo... 

./install snowflake

this will install the mysql driver.