Create Qlik Sense Enterprise connection

To create a connection to your system, follow these steps:

1. Navigate to Settings  > Data Ingestion > Connections.
2. In the top-right corner, click New connection, find your system, and click Connect.

General configuration

In the general connection configuration step:

1. Name your connection for easier identification in Dawiso. Use a unique and descriptive name like the combination of the server name and your local environment naming (e.g., server1_prod).
2. Provide a description (purpose of the connection).
3. Select a Connection type.
   • Shared: Source is accessible from the public internet and you can share your credentials with Dawiso.
   • Private: Source is not accessible from the public internet and you cannot share your credentials with Dawiso. For more information, see the Create a private connection article.
4. Click Next.

Host configuration

In the host configuration step, provide the following information:

1. Host Name: FQDN of your Qlik Sense central node. E.g. your-qlik-server.company.com.
2. QRS Port: Repository Service REST API port. Default 4242. Used for certificate authentication.
3. Engine Port: Engine JSON API port. Default 4747. Used for certificate authentication.

Authentication

1. Authentication Method: choose how Dawiso connects.
   • Certificate (default): connects directly to the QRS and Engine ports using client certificates exported from the QMC.
   • Windows: connects through the Qlik Proxy Service (typically port 443) using the Windows identity of the Dawiso ingestion service. When selected, the certificate fields below are not required.
2. For Certificate authentication, provide the certificates exported in [[slug
   ]]:
   1. Certificate Format: PEM (default) or PFX.
   2. Client Certificate: the client.pem file (PEM) or the client.pfx file (PFX). You may paste the PEM contents directly or provide a file path.
   3. Client Key: the client_key.pem file (PEM only — leave empty for PFX, which already contains the key).
   4. Root Certificate: the root.pem file (PEM) or the root.cer file (PFX).
   5. Certificate Password: the password for the PFX file (PFX only).
3. User Directory and User ID: the identity Dawiso presents to Qlik (the X-Qlik-User header). Defaults are INTERNAL and sa_repository. Change these only if you use a dedicated service account.

Server certificate validation

If your Qlik server uses a certificate that the ingestion host’s operating system does not trust, enable Trust Server Certificate to accept it. Leave it off to validate the server certificate against the Root Certificate you provided.

Test and save connection

If your connection is shared, click on Test connection and wait for a few seconds.

• If successful, there will be a green checkmark next to the button.
• In case of failure, there will be a red error icon. Hover over it for a detailed error message. For more information, see the troubleshooting section. You are still able to save your connection.

Finally, Save the connection and proceed to the next step: using the connection to create a data source. During this process, you will specify what metadata to ingest.