How to switch ODBC connection string when have to deploy an App

gianluca89 — Mon, 06 Nov 2023 14:40:23 GMT

Hi Team

We recently began to develop QlikSense App using Cloudera Impala ODBC connector in Single Sign On

(Configuring SSO for the Cloudera Impala connector | Qlik Connectors Help)

So It means that We are able to use our personal user account to create personal OBDC connection to develop. In the Data Load editor the script take this structure:

LIB CONNECT TO [Sample Cloudera Impala DSN (personal_account)]

Well, all it works fine until we want to deploy the app and generate a scheduling task with it using a the QMC Service Account.

Infact when we do it, we obtain this error message:

20231106T152907.893+0100 0047 LIB CONNECT TO [Sample Cloudera Impala DSN (ocr_puccig)]
20231106T152907.971+0100 0049 [r_sla_reporting_tickets]:
20231106T152907.971+0100 0050 SQL SELECT `periodo`,
20231106T152907.971+0100 0051 `macro_servizio`,
20231106T152907.971+0100 0052 `cod_iq`,
20231106T152907.971+0100 0053 `id_ticket`,
20231106T152907.971+0100 0054 `durata_min`,
20231106T152907.971+0100 0055 `soglia_min`,
20231106T152907.971+0100 0056 `in_target`,
20231106T152907.971+0100 0057 `tkt_id`,
20231106T152907.971+0100 0058 `tms_caricamento`
20231106T152907.971+0100 0059 FROM `IMPALA`.`db_servicenow_raw`.`r_sla_reporting_tickets`
20231106T152907.971+0100 Error: There is no open data connection.
20231106T152907.971+0100 Execution Failed
20231106T152907.972+0100 Execution finished.

So we ask to us: is there a way to switch to a Service Account ODBC connection in the act to deploy the app after the development phase is end?

Thank you very much

Gianluca

topic How to switch ODBC connection string when have to deploy an App in Management & Governance

How to switch ODBC connection string when have to deploy an App