Skip to main content
Version: v2

Qlik Analytics Services

In this article, you can learn how to get data from Qlik Analytics Services to Canner Enterprise.

Set Canner Enterprise as the Qlik Analytics Services data source

Step 1: Set the data source

After entering the Qlik page: Click the Add new button in the upper right corner. Expand the menu. Select the Dataset option.

1_qlik

After selecting the Dataset option, enter this screen and click the Create connection button.

2_qlik

Once clicked, select PostgreSQL as the data source.

3_qlik

Step 2: Set connection information

Set the connection information on the following screen.

4_qlik

  • Host: Fill in the Host or IP address of Canner Enterprise
  • Port: usually 7432; if there is a particular port setting, please pay attention to this field
  • Database name: Enter the SQL Name in Workspace
  • Username: canner
  • Password: Fill in Personal Access Token to create Personal Access Token Way

When setting relevant field information, you can click the Share button on the upper right of the workspace you want to connect to Qlik Analytics Services in Canner Enterprise and switch to PostgreSQL Wire Protocol to view its connection information.

pg_connect_info

After filling in the above information, click Test Connection.

5_qlik

The test connection is successful.

6_qlik

Click Create Connection.

7_qlik

After the connection is successful, the data source we are connected to can be seen on the screen, select and click Next.

8_qlik

Click the Owner menu, and select the Database Name that we just filled in to set the connection information.

9_qlik

After selection, you can see the data connection from the Canner Enterprise workspace in the tables on the left column.

10_qlik

You can also select a profile to preview.

11_qlik

Check the tables you want to import into Qlik and click the Next button after checking.

12_qlik

Select the Qlik workspace in which the data is created.

13_qlik

Step 3: Connection completed

After the connection is completed, enter the Catalog page, and you can see the information about the connection. You can use this information to perform various subsequent applications in Qlik.

14_qlik