Reporting

QlikSense

Connectivity Summary

Qlik Sense allows you to create interactive reports and dashboards with clear charts and graphs. Data analysis is simplified for faster business decisions. In the OvalEdge application, the Qliksense Connector is used for crawling and lineage building. 

Pre-requisites

To use the connector, the following prerequisites are needed:

  • Install Node server: This will be used by OvalEdge to connect to the QlikSense engine. Please contact the OvalEdge team for the installation package. Use the node server to connect to the QlikSense engine and get the remote details.
  • Service account with the read privilege.

Connector Capabilities

The connector capabilities are shown below:

Crawling

Please see this article Crawling Data, for more details on crawling. Supported objects for Crawling are:

Feature Supported Objects Remarks
Crawling Reports QVD Builder / Presentation Layer reports
Report Columns  
Dashboards  
Sheets  
Cells  

Profiling

There is no profiling as we are not supporting profiling for report frameworks.

Lineage Building

  • How does OvalEdge fetch lineage information:

    • Presentation Layer Apps: By using an Application's log file, OvalEdge finds the QVD Builders and their L1 and L2 applications. 
    • QVD Builder: By using an Application's log file, OvalEdge finds the sources of a resident table.
Lineage Entities Details

Report  lineage

Supported

Report Column lineage

Supported

Lineage Sources

QVD Builders, Tables 

Connection Details

The following connection settings should be added for connecting to a Qlik Sense:

  • Database Type: QlikSense
  • Connection Name: Select a Connection name for the Qlik Sense. You specify a reference name to identify your Qlik Sense connection in OvalEdge easily.
    Example: Qlik Sense Connection
  • QlikSense User Id: QlikSense user id
  • QlikSense User Directory: QlikSense Repository directory
  • QlikSense User Password: Password
  • QlikSense Port: Port that which QlikSense server engine is using
  • QlikSense Certs Path: Certs path to connect the engine
  • Logs Path: Logs path where all the QlikSense logs stored
  • XML files generation path: Path to generate source info  xmls for each remote app from the node server
  • Path to store QVDS: Path to copy remote QVDs into the ovaledge server box
  • QVDs Path:  The path in QlikSense where QVDs  exists

Once connectivity is established, additional configurations for Crawling and Profiling can be specified.

Crawler Options

Reports

To fetch only reports(By default)

Report Columns

To fetch the report column(Need to check while crawling)

Profile Options

No profile Option

Crawler Rules

 

Include Report Regex

Includes only reports that match regex with the report name

Exclude Report Regex

Excludes reports which match regex with the report name