topic Re: QlikSense (NON CLOUD VERSION) integretion in .NET application in Integration, Extension & APIs

QlikSense (NON CLOUD VERSION) integretion in .NET application

NanuNic993799 — Thu, 12 Sep 2024 13:33:10 GMT

Hi everyone,

As I mentioned in the post title, I'm trying to implement some QlikSense API in a .NET console application to easily produce a monthly updated version of some reports.

I've seen in several posts and links that this is possible, but the issue is that I don't have the SaaS version of Qlik, only the On-Premise version.

I've tried every possible solution (both HttpRequest and SDK; for the SDK, I've tried every method indicated in the GitHub repo), and I always get this Exception: 'One or more errors occurred. (Unable to establish websocket connection.) (Unable to establish websocket connection.) (Unable to establish websocket connection.) (Unable to establish websocket connection.)'. I've tried to check if I have to add my pc to the WhiteList inside the QMC, but I only can find the Host Allow List, inside the Virtual Proxy

I'd like to try using an API key, but I can't find a way to generate one (I really hope this option isn't limited to the Cloud version).

Can anyone help me?

Re: QlikSense (NON CLOUD VERSION) integretion in .NET application

rwunderlich — Thu, 12 Sep 2024 18:08:53 GMT

When you say you've tried every SDK method in the repo, do you mean this repo?

https://github.com/AptkQlik/PublicExamples

There are some great examples there of connecting using the SDK. For on-prem, you can't connect with an API key. The equivalent might be making a certificate connection as shown here
https://github.com/AptkQlik/PublicExamples/tree/master/ConnectDirectRemoteServer

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

Re: QlikSense (NON CLOUD VERSION) integretion in .NET application

NanuNic993799 — Fri, 13 Sep 2024 07:52:46 GMT

I've tried that one to...

Re: QlikSense (NON CLOUD VERSION) integretion in .NET application

rwunderlich — Fri, 13 Sep 2024 17:46:15 GMT

When making the direct connection, is the port 4747 open on the Qlik server? Is there an inner exception in the websocket exception?

A good place to get help with the sdk is the qlik dev slack channel at qlikdeveloper.slack.com.

-Rob

Re: QlikSense (NON CLOUD VERSION) integretion in .NET application

marksouzacosta — Fri, 13 Sep 2024 18:05:08 GMT

Hi @NanuNic993799,

Have you tried this Qlik Rest SDK?
GitHub - kolsrud/qlik_rest_sdk: SDK for accessing the Qlik Sense REST APIs

This may also help you: qlik-cli | Qlik Developer Portal

Anyway, can you please share your whole .NET SDK Code, the part where you try to setup your connection?

@hugo_andrade may be able to help you as well on Qlik Security Settings.

Re: QlikSense (NON CLOUD VERSION) integretion in .NET application

Øystein_Kolsrud — Mon, 16 Sep 2024 07:05:19 GMT

As @marksouzacosta writes, if you post the code you use to configure your connection, then we might figure out what is wrong. In the mean time I'd recommend that you check your firewall settings.

Re: QlikSense (NON CLOUD VERSION) integretion in .NET application

hugo_andrade — Mon, 16 Sep 2024 14:37:03 GMT

Hi @NanuNic993799 ,

A few items to help you move forward:

For Qlik Sense on Windows authentication I would recommend using the certificates method. Super powerful and simpler to use. Start with that: https://help.qlik.com/en-US/sense-developer/May2024/Subsystems/ProxyServiceAPI/Content/Sense_ProxyServiceAPI/ProxyServiceAPI-Connect-API-Authenticate-Requests_Certificate.htm
The Qlik CLI (API Keys) are meant for Qlik Cloud only. There's a different CLI for Qlik Sense on Windows, you can find more information here: https://community.qlik.com/t5/Official-Support-Articles/How-to-install-Qlik-CLI-for-Qlik-Sense-on-Windows/ta-p/1715387
I saw your note about Allow List and Whitelist. These are the same. The name differs based on the version of Qlik Sense. The current language adopted by IT in general is allow list, but you will still find references of whitelist in older documentation.
Regarding the websocket connection, I would recommend using a valid SSL/TLS certificate, and avoid using self-signed ones. Try to establish the connection using HTTPS instead of HTTP. Lastly, add a flag to skip certificate validation if you can't get a valid SSL/TLS certificate loaded on the Qlik Sense Proxy service.

Keep us posted on your progress fellow Qlikker!