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?
