Qlik Sense connection

Setup in Qlik Sense

To configure the appropriate security rules and to create a certificate for use in MANTA Automated Data Lineage:

1. As a Qlik Sense, log in to the Qlik Management Console (QMC). The default address is https://<Qlik server name>/qmc.

2. On the QMC start page, go to Security Rules and create a rule with the following settings:

   • To apply this rule to all resources, set the resource filter to *.
   • To grant read access to the resources, select Read as action.
   • Set the context where the rule is applied to Both in hub and QMC.

3. Edit the user that you want to use in the Qlik Sense connection in Cloud Pak for Data and add the new security rule to the user profile. You can edit the user in the Users section of the QMC.

4. On the QMC start page, go to Certificates and provide the following information:

   • In the Machine name field, enter a name. You can choose any name; it is used to identify the folder where the certificates are stored.
   • Set a password for the certificate. This password is later used as the keystore password in MANTA Automated Data Lineage.
   • Select Windows as the export format. The file format is .pfx.

   Then, click Export certificates in the action bar.

   The following certificate files are written to the C:\ProgramData\Qlik\Sense\Repository\Exported Certificates\<machine name> directory on the Qlik Sense server: client.pfx, root.cer, server.pfx.

   Back up these files before you proceed.

5. On the QMC start page, go to Virtual Proxies and create a virtual proxy with the following settings:

   • IDENTIFICATION section:

     • Enter an arbitrary description.
     • Leave the Prefix field empty, which is the default.
     • Set the session inactivity timeout to 30 minutes.
     • As the session cookie header name, enter X-Qlik-Session.

   • AUTHENTICATION section:

     • Set the anonymous access mode to Allow anonymous user.
     • Set the authentication method to Header authentication static user directory
     • Set the header authentication header name to Administrator.
     • Set the header authentication static user directory to metrical1.

   • ADVANCED section:

     • Make sure that the Has secure attribute (https) option is selected.
     • For the SameSite attribute (https) option, select Lax.
     • For the SameSite attribute (http) option, select No attribute.

   For all other settings, accept the default values.

Proceed to configure the required settings in MANTA Automated Data Lineage.

Setup in MANTA Automated Data Lineage

To configure the truststore and keystore settings for the Qlik Sense connection:

1. Open the MANTA Automated Data Lineage Admin UI:

   https://<CPD-HOSTNAME>/manta-admin-gui/
   

2. Go to Configuration > CLI > Common > Common Config and edit the configuration that is common for all source systems.

3. In the SSL section, click Edit next to MANTA Flow CLI Connectors Truststore Settings. Then, click Add entry.

4. Upload the root.cer file that you created in the QMC and enter the password that you set for the certificate as the file password.

5. Set a different alias and click Confirm.

6. To manage the keystore settings, create a temporary Qlik Sense connection:

   1. Go to Connections and click Add connection.
   2. Select Qlik Sense from Reporting & BI.
   3. In the Connection section of the create window, select Enterprise as the extractor connection type.
   4. Edit the keystore settings and click Recreate next to the Store file field.
   5. Make sure to remember the keystore file path and the password and click Confirm.
   6. In the Edit keystore settings window, click Add entry.
   7. Upload the client.pfx file that you created in the QMC and enter the password that you set for the certificate as the file password.
   8. After the file is uploaded, click Confirm.
   9. In the Create a new Qlik Sense Connection window, click VALIDATE to evaluate your changes. If the validation is successful, you can create a Qlik Sense connection in Cloud Pak for Data.

Choose the method for creating a connection based on where you are in the platform

In a project

Click Assets > New asset > Data access tools > Connection. See Adding a connection to a project.

In a catalog

Click Add to catalog > Connection. See Adding a connection asset to a catalog.

In the Platform assets catalog

Click New connection. For more information, see Adding platform connections.

Next step: Add assets from the connection

• In a project, create and run a metadata import with the Import BI report or the Get BI report lineage goal to add assets to a catalog. For more information, see Importing business intelligence reports and Getting lineage for business intelligence reports.

Federal Information Processing Standards (FIPS) compliance

The Qlik Sense connection cannot be created in a FIPS environment.