Qlik Sense JSON Connector

Qlik Sense JSON Connector

Happy 2020 Everyone! 2019 seemed to have gone flying by, it had been a very busy year for me – lots of really interesting Qlik projects, learnt a lot of new skills and of course, lot more about Qlik’s internal workings. With that in mind – I wanted to share an interesting concept today – how to build and deploy a “JSON” file connector using no additional tools other than what you already have installed in your Qlik Sense Enterprise on Windows environment.

Read More »

Qlik Load Script Alerts to Microsoft Teams

Qlik Sense is a great platform, however, it has its shortfalls. One of them would be the lack of push notifications out of the box from QMC. Last year, I worked on a few solutions to send alerts via emails and via APIs/webhooks to bespoke applications when there is a job failure on Qlik Sense Enterprise. I utilised the QRS API as well as REST connector and webhook technologies to achieve these goals. That got me thinking, what else can be done using webhook? At Tahola, we use Microsoft Teams as part of our collaboration suite. I thought it would be a good idea to be able to send alerts to the Teams channel directly from Qlik data load scripts (via REST connector), whether be a load completion alert or just a simple KPI summary table from the data model. So, I spent few hours building a PoC Qlik application to that goal, and thought, I should share the concept with others as it might be useful in some scenarios.

Read More »