Qlik Sense Cloud


Qlik Sense Cloud


This page outlines the steps to connect Qlik Sense Cloud to the CData Connect Virtual SQL Server API.

Prerequisites

Before you connect, you must first do the following:

  • Connect a data source to your CData Connect account. See Connections for more information.
  • Generate a Personal Access Token (PAT) on the Settings page. Copy this down, as it acts as your password during authentication.

Connecting to CData Connect

To establish a connection from Qlik Sense Cloud to the CData Connect Virtual SQL Server API, follow these steps.

  1. Log in to Qlik Sense Cloud.

  2. On the home dashboard, click Add new > Connect to data.

  3. In the Add data connection dialog, select Microsoft SQL Server.

  4. Enter the connection settings.
    • Database Properties
      • Server—enter tds.cdata.com
      • Port—enter 14333
      • Database—enter the Connection Name of the CData Connect data source you want to connect to (for example, Salesforce1).
      • Encrypt—check this box, but do not upload a certificate file.
      • Trust Server Certificate—check this box.
      • Minimum TLS—leave as 1.0.
    • Authentication
      • Use Trusted Connection—leave unchecked.
      • Use NTLM—leave unchecked.
    • Account properties
      • User defined credentials—set this according to your needs.
      • User name—enter your CData Connect username. This is displayed in the top-right corner of the CData Connect interface. For example, test@cdata.com.
      • Password—enter the PAT you generated on the Settings page.
    • Leave the settings below Account Properties blank and unchecked.
  5. Click Test connection to test your entered credentials. If you receive an error, check all fields and try again.

  6. Click Create to save the connection or Create and Analyze to save the connection and begin an analysis.

Your connection is now available for data analysis. To manage your connection, open the Qlik Sense Management Console and select Data content.