Qlik Sense Connector (On-Prem)

Qlik Sense connector (On-Prem) is a lightweight web service that helps you fetch data from many social media and web-based data sources. Qlik Sense is a data visualization and discovery product that allows you to create flexible, interactive visualizations that would lead to meaningful decisions.

OvalEdge uses a service account to connect to the data source, which allows you to crawl the data objects (Reports, Report Columns, etc.) and build Lineage.

Connector Capabilities

The Qlik Sense connector supports the following data objects:

Qlik Sense Authentication 

Qlik Sense supports the following types of Authentication, which include:

1. Windows Authentication: This authentication type requires the user's Windows credentials to grant access to the Qlik Sense environment.
2. Certificates Authentication: This authentication type requires a valid digital certificate to access the Qlik Sense environment.
3. Cookie-based Authentication: This authentication type requires a cookie to authenticate the user's identity and grant access to the Qlik Sense environment.

In this document, you will see Qlik Sense with Microsoft Windows Authentication.

Authentication with Microsoft Windows Identity

Qlik Sense Repository Service (QRS) API requests can be authenticated using a Microsoft Windows identity. If this is the case, send requests using the proxy server URL.

This authentication method does not require certificates, and the connection is made using the permissions of the Windows user. This method can be used on the Qlik Sense server or remotely (however, the API must support Windows authentication).

To activate Windows authentication in the Qlik Sense environment, enable Windows Authentication to the Qlik Sense server and retrieve the corresponding UserID and User Password to enter into the designated fields.

Prerequisites

To establish a Qlik Sense connection, the following prerequisites are required:

Service Account with Minimum Permissions

The following are the minimum privileges required for a service account to crawl a connection. 

References: To check regarding Audit Admin rights. https://help.qlik.com/en-US/sense/November2017/Subsystems/ManagementConsole/Content/default-administration-roles.htm?_ga=2.29671039.1198636087.1683012766-587182994.1683012766#Administ 

Note: To fetch the cells information, OvalEdge has to connect to Qlik Engine. To
establish connectivity to Qlik Engine OvalEdge requires customers to share the
Windows Server's remote desktop Certificate.

Establish Environment Variables (Optional)

This section describes the settings or instructions that you should be aware of prior to establishing a connection. If your environments have been configured, skip this step.

Configure Environment Names

The Environment Names allow you to select the environment configured for the specific connector from the dropdown list in the Manage Connector pop-up window. This is done to identify which environment your connector is connecting to at a glance.
You might want to consider crawling the same schema in both stage and production environments for consistency. The typical environments for crawling are PROD, STG, or Temporary, and may also include QA or other environments. 

Additionally, crawling a temporary environment can be useful for schema comparisons, which can later be deleted, especially during application upgrade assistance. 

Steps to Configure the Environment in OvalEdge:

1. Navigate to Administration | Configuration. 
2. Select the Connector tab.
3. Find the Key name “connector.environment”.
4. Enter the desired environment values (PROD, STG) in the value column. 
5. Click ✔ to save. 

Establish a connection

To set up a Qlik Sense Connection, provide the necessary information in the Manage Connector pop-up window by completing the required fields with relevant details.

1. Log into the OvalEdge application.
2. Navigate to Administration > Connectors module. The Connectors Information page is displayed.
3. Click on + New Connector. The Add Connector pop-up window is displayed.
4. Select the connection type as Qlik Sense. The Add Connector with Qlik Sense details is displayed.
   

   Field Name	Description
   Connector Type	The selected connection type Qlik Sense is displayed by default. If required, the drop-down menu allows you to change the connector type and based on the selection of the connection type, the fields associated with the selected connection type are displayed.
   License Add Ons	All the connectors will have a Base Connector License by default that allows you to crawl and profile to obtain the metadata and statistical information from a datasource.  OvalEdge supports various License Add-Ons based on the connector’s functionality requirements. Select the Auto Lineage Add-On license that enables the automatic construction of the Lineage of data objects for a connector with the Lineage feature.  Select the Data Quality Add-On license to identify, report, and resolve the data quality issues for a connector whose data supports data quality, using DQ Rules/functions, Anomaly detection, Reports, and more. Select the Data Access Add-On license that will enforce connector access via OvalEdge with Remote Data Access Management (RDAM) feature-enabled.
   Connector Environment	The environment drop-down menu allows you to select the environment configured for the connector from the drop-down list. For example, PROD, or STG (based on the configured items in the OvalEdge configuration for the connector.environment). The purpose of the environment field is to help you identify which connector is connecting what type of system environment (Production, STG, or QA).    Note: The steps to set up environment variables are explained in the prerequisite section.
   Connection Name*	Enter a connection name for the Qlik Sense connector.  You can specify a name to easily identify it on the OvalEdge Connector page. Example: Qlik Sense_test
   Authentication	Select the Windows Authentication, and enter the respective Windows User ID and Password.
   Connection URL*	Enter the Hostname or IP address of the Qlik Sense
   Qlik Sense User Id	Enter the Service Account User Id
   Qlik Sense User Password*	Enter the Service Account user password.
   Alias Host Name	Enter the host name when loading the report on the report summary page.
   Logs Path	Enter the path where all the Qlik Sense logs are stored.
   XML files generation path	Enter the path created in the OvalEdge server to generate metadata files by the node server.
   Path to store QVDS	Enter the path created in the OvalEdge server to store the metadata of QVD files.
   QVDs Path	Enter the path to copy remote QVD into the OvalEdge server box.
   Exclude UnPublished Apps (Y/N)	Enter Yes to exclude unpublished apps from the Qlik Server. Enter No to include unpublished apps from the Qlik Server.
   Default Governance Roles*	You can select a specific user or a  team from the governance roles (Steward, Custodian, Owner) that get assigned for managing the data object.  Note: The drop-down list displays all the configurable roles (single user or a team) as per the configurations made in the OvalEdge Security | Governance Roles section.
   Admin Roles*	Select the required admin roles for this connector. To add Integration Admin Roles, search for or select one or more roles from the Integration Admin options, and then click on the Apply button. The responsibility of the Integration Admin includes configuring crawling and profiling settings for the connector, as well as deleting connectors, schemas, or data objects. To add Security and Governance Admin roles, search for or select one or more roles from the list, and then click on the Apply button. The security and Governance Admin is responsible for: Configure role permissions for the connector and its associated data objects. Add admins to set permissions for roles on the connector and its associated data objects. Update governance roles. Create custom fields. Develop Service Request templates for the connector. Create Approval workflows for the templates.
   Select Bridge	To enable OvalEdge to function as a SaaS application behind a customer's firewall, the OvalEdge Bridge is necessary. The Bridge functions as a firewall at the network layer. When a bridge has been set up, it will be displayed in a drop-down menu. Users can select the required Bridge ID. The user can select "NO BRIDGE" when it is not configured. For more information, refer to Bridge Overview

5. Click on the Validate button to validate the connection details. 
6. Click on the Save button to save the connection.  Alternatively, you can also directly click on the Save & Configure button that displays the Connection Settings pop-up window to configure the settings for the selected Connector. The Save & Configure button is displayed only for the Connectors for which the settings configuration is required.

Note: * (asterisk) indicates the mandatory field required to establish a connection. Once all the parameters are entered, you can validate the details and save the connection that will get displayed on the Connector Home page. 

Note: You can either save the connection details first, or you can validate the connection first and then save it. 

Connection Validation Errors 

➤ If you have any issues creating a connection, please contact your assigned OvalEdge Customer Success Management (CSM) team.

Connector Settings 

Once the connection is established successfully, various settings are provided to retrieve and display the information from the data source.  

The Crawling of Report Group Names

A Crawl/Profile button allows you to select one or more  Report Group Names for crawling. 

1. Navigate to the Connectors page, and click Crawl/Profile. It allows you to select the Report Groups that need to be crawled.
2. The crawl option is selected by default. 
3. Click on the Run button, which gathers all metadata from the connected source into the OvalEdge Data Catalog. After a successful crawl, all the information is displayed in the Data Catalog > Report / Report Column Tab.

Note: For more information on Scheduling, refer to How to Schedule Connectors 

Copyright © 2024, OvalEdge LLC, Peachtree Corners, GA, USA.