topic Re: can we replace Analytic connection with python scripts in server with aws lamda function in App Development

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

albrtjos — Thu, 09 May 2024 06:22:35 GMT

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.

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

igoralcantara — Thu, 09 May 2024 13:44:36 GMT

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)" );

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

igoralcantara — Fri, 10 May 2024 15:37:19 GMT

Hey, did my answer helped you?