topic Re: Creating New Data Connection in Connectivity & Data Prep

Creating New Data Connection

Thomas91 — Thu, 20 May 2021 13:47:38 GMT

Hi,

I'm trying to use Qlik Web Connectors to pull data from a file saved within SharePoint. All works fine until trying to create the Data Connection within the Qlik Sense script.

When trying to create the new Web File connection upon clicking "Create" I am getting red text stating "Peer certificate cannot be authenticated."

Does anyone know what may be causing this? I've done numerous searches on Google but unfortunately can't find an answer.

Thanks, Tom.

Re: Creating New Data Connection

PadmaPriya — Fri, 21 May 2021 18:47:00 GMT

Hello @Thomas91

Thanks for posting your query.

Cause:

This issue occurs when the Qlik Web connector does not have the proper certificate authority installed under the Trusted Server CAs option.

Login to the admin console
Navigate to System > Configuration > Certificate > Trusted Server CAs
Click Import Trusted Server CAs
Click Browse
Browse to the certificate authority file
Click Import Certificate
Navigate to System > Configuration > CA
Click Save Changes to reattempt the registration again.

Thanks,

Padma Priya

Re: Creating New Data Connection

Thomas91 — Fri, 28 May 2021 07:35:41 GMT

Hi @PadmaPriya ,

Thanks for your response.

Are the above steps within the MMC? I'm not exactly sure which certificate should be there but there does seem to be one for the QWC?

Thanks, Tom