[QlikSense] Call an external Java/C# function in the QlikSense script

[l3malex]

Dear all,

In QlikView we were able to use vbscript macro to call external function, but in QlikView V12.5, vbscript is no more supported (https://support.qlik.com/articles/000080222)...

So, I am trying to look in the future, and I would like to replicate my functionality on QlikSense. The only way that I see, is to use Qlik Server Side Extension, do you confirm that it could be the good approach?

My functionality is quite simple, I would like to pass a string to an external function (c, c#, java,...) which return an other string. I cannot replicate the task of my function in Qlik. This function is called about 9million times by load.

If you are an expert, could you try to explain myself with an easy procedure how to develop this?

Many thanks in advance for all your answers because I am lost,

l3malexx
(Qlik dev)

$Call external function in load script $Qlik-SSE $Need experts $Qlik Server-Side-Extension $Qlik-connectivy

[Dalton_Ruer]

Qlik Sense provides an Execute command that will call something external. https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

Given that you have 9 million rows I would probably do a STORE command to save the 9 million rows to a CSV, call the Execute to have your script process all 9 million rows and have it save the output, then load it's output back in to your data model. 

You could build a Server Side Extension. It isn't getting started, but if you have some coding talent, the incomparable @rwunderlich has built a great framework for you to start with so you aren't starting at ground 0. https://github.com/RobWunderlich/qcb-qlik-sse