QRS API to create ODBC connection to Databricks on AWS

[Jakub000]

Hi - is it possible to create ODBC connection to Databricks for Qliksense on prem with OAuth option. I want to skip DSN creation part on the server and put all info through API. ODBC based on DSN works very well btw.

I've been trying with the body below. The connection is being created in Qlik but is useless with the error below as well.

We have Databricks on AWS and in qlik default connectors there is only OAuth for azure now so wondering if it will work with an API.

body:

{

  "name": "Databricks_Auto_Customer",

  "connectionstring": "CUSTOM CONNECT TO \"provider=QvOdbcConnectorPackage.exe;driver=odbc;connectionString=Driver={Databricks ODBC Driver};Host=[host].cloud.databricks.com;Port=443;HTTPPath=[path];SSL=1;AuthMech=11;Auth_Flow=1;Auth_Client_ID=[client];Auth_Client_Secret=[psswd];ThriftTransport=2;\"",

  "type": "ODBC",

  "username": "token",

  "password": "psswd",

  "engineObjectId": "501064b7-b724-4f14-8815-80a37a60565a",

  "logOn": 0

}

error:

The error occurred here:

CUSTOM CONNECT TO ***