can we replace Analytic connection with python scripts in server with aws lamda function

[albrtjos]

We have some python scripts residing in one of the qlik nodes which is connected to qlik sense (which resides in aws server) through analytic connection
is it possible to move those scripts to aws lambda function and establish a connection from Qlik sense enterprise windows ? I believe AWS lambda connector will work with Qlik cloud only.

[igoralcantara]

Yes, I have done it a few times using a REST Connection.

One example of how I use it:

Let vControl = '[' & Peek('NotSmokersChol', 0) & ']';
Drop Table NotCurrSmokersChol;

Let vTest = '[' & Peek('SmokersChol', 0) & ']';
Drop Table CurrSmokersChol;

// Prepare call

LET vRequestBody ='{';

Let vRequestBody = vRequestBody& '""control"":$(vControl),';

Let vRequestBody = vRequestBody&'""test"":$(vTest)';

Let vRequestBody = vRequestBody & '}';

LIB CONNECT TO 'Lambda_TTest';

RestConnectorMasterTable:

SQL SELECT 

"t",

"p",

    "df"

FROM JSON (wrap on) "root"

WITH CONNECTION 

( BODY "$(vRequestBody)" );

[igoralcantara]

Hey, did my answer helped you?