Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT

Troubleshooting Data Connections in Qlik Cloud and Qlik Sense Enterprise on Windows

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Albert_Candelario

Troubleshooting Data Connections in Qlik Cloud and Qlik Sense Enterprise on Windows

Last Update:

Jun 12, 2023 11:19:07 AM

Updated By:

Frank_S

Created date:

Jun 9, 2023 8:34:50 AM

Data connections to Qlik Cloud or Qlik Sense Enterprise on Windows can fail for several reasons. In this article we aim to provide you with a step-by-step guide on how to begin troubleshooting data connectivity errors, ruling out the most common root causes. 

Content:

 

Step 1: Verify the Database Connection

Network Connectivity

The first step in your investigation is to verify basic network connectivity to the database.

  1. Run a simple ping or telnet either from the Qlik Sense (on-prem) server or your desktop in case of a Qlik Cloud issue. 
  2. Rule out a restrictive firewall blocking required ports on both target and source by reviewing or temporarily disabling the firewall rules. 

Work with your network administrator on both where necessary. 

Credentials and Settings

If the network and firewall settings are not the issue, verify if the database operates as expected.

  • Is it online?
  • Has a recent upgrade been performed and has this affected the current configuration (driver compatibility issues, disabling features, introducing new security capabilities which need to be reviewed, etc..)

Next, we verify if the credentials and settings in our connection are correct. The easiest way to do this is by logging in directly to the database using its native client. 

Examples of on-premise database clients include:

For cloud-based databases: 

  1. Cloud provider console: Most cloud providers, such as Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (GCP), have a web-based console that you can use to monitor and manage your cloud resources. 
  2. Cloud database management tools: Some cloud providers offer database management tools that can help you monitor and manage your database resources. 
  3. Logging and monitoring tools: You can use logging and monitoring tools, such as AWS CloudWatch, to monitor the performance and activity of your cloud database. These tools can provide valuable information about any issues that may be affecting your database, including connectivity issues.

The specific tools you use will depend on the cloud provider you are using and the type of database you have.

Step 2: Verify the Connection Details in Qlik

Verify if the following are correct in Qlik Sense (details may vary depending on your data connection):

  • Host or server name
  • Database name
  • Port
  • User name
  • Password

In Qlik Cloud

Depending on your permissions, you can either edit/verify your connection directly in the Qlik Sense App Data Load Editor or in the Space.

Using the Data Load Editor:

  1. Open the Qlik Cloud App
  2. Open the Data Load Editor

    Data Load Editor.png

  3. Choose the Data Connection you want to verify: 

    Edit Data Connection in Data Load Editor.png

 

In Qlik Sense Enterprise on Windows:

Depending on your permissions, you can either edit/verify your connection directly in the Qlik Sense App Data Load Editor or in the Qlik Sense Management Console.

Using the Data Load Editor:

  1. Open the Qlik Sense App
  2. Open the Data Load Editor

    Data Load Editor in Qlik Sense on Windows.png

  3. Choose the Data Connection you want to verify: 

    Edit Data Connection in Data Load Editor on Windows.png

 

Using the Qlik Sense Management Console:

  1. Open the Qlik Sense Enterprise Management Console
  2. Open Data Connections 
  3. Locate the Data Connection causing an issue and open it
  4. You can review the Connection String and Username and Password from here 

    Edit Data Connection.png

Step 3: Test the Connection in Qlik Sense

Once you have confirmed the connection details, you can test the connection in Qlik Sense.

  1. Open the Data Connection
  2. Click Test connection

    Test Connection.png

    Any eventual will help you identify the issue.


Step 4: Review the Qlik Sense logs

Data connections generally fail during reload. Qlik Sense will log details of the error or preceding warnings in the corresponding reload log. These error and warning messages can then be used to look up solutions or troubleshoot further. 

Search the warnings and errors in our knowledge base for known solutions. Begin your search here.

Step 5: Contact the Database Vendor

If you have completed all the above and have not found solutions in the Qlik knowledge base, reach out to the database vendor for additional support. They will be able to provide specific information on troubleshooting the issue with your specific database.

Labels (2)
Version history
Last update:
‎2023-06-12 11:19 AM
Updated by: