Databricks OAUTH token Issue

[gopikrishnan06]

Hi All,

While connect from the person token Qlik replicate working fine. But here need to connect from the Oauth token but its not working.

Qlik replicate to target Databricks on GCP cloud.

• SYS-E-HTTPFAIL, Cannot connect to Cloud server.
• SYS,GENERAL_EXCEPTION,Cannot connect to Cloud server,RetCode: SQL_ERROR SqlState: 08001 NativeError: 10380 Message: [Simba][ODBC] (10380) Unable to establish connection with data source. Missing settings: {[Auth_AccessToken]}

Kindly respond it will helpful.

Thank you,

Gopi

[DesmondWOO]

Hi @gopikrishnan06 ,

Thank you for reaching out to the Qlik Community. 

Could you try using ODBC DSN if you are able connect to Databricks?

Regards,
Desmond

[gopikrishnan06]

Hi All,  How to connect Oauth in the Databricks, Even Port all are added perfect..

Able to work from Qlik replicate using Databricks ODBC access. In that 2 options are there

1) Personal auth token-- Working fine

2) Oauth token -- not working.

Error as 

• SYS-E-HTTPFAIL, Cannot connect to Cloud server.
• SYS,GENERAL_EXCEPTION,Cannot connect to Cloud server,RetCode: SQL_ERROR SqlState: 08001 NativeError: 10380 Message: [Simba][ODBC] (10380) Unable to establish connection with data source. Missing settings: {[Auth_AccessToken]}

[john_wang]

Hello @gopikrishnan06 ,

We’ve encountered similar errors in the past, and in most cases the issue was related to the Simba ODBC Driver version. Please refer to the Qlik Replicate User Guide to ensure that the certified ODBC driver version is installed. After installation, make sure to restart the Replicate service.

Good luck,

John.

[gopikrishnan06]

Hi John,

Here latest version are installed. Qlik able to connect using the Personal auth token and working fine.

HERE ISSUE WITH OAUTH TOKEN.

Going to connect to server 3776110770776746.6.gcp.databricks.com database janus_jde_sa_arg (cloud_imp.c:4791)

00957509: 2025-08-26T07:45:38 [METADATA_MANAGE ]I: Target endpoint 'Databricks Lakehouse (Delta)' is using provider syntax 'DatabricksDelta' (provider_syntax_manager.c:977)

00957509: 2025-08-26T07:45:38 [METADATA_MANAGE ]I: ODBC driver version: '2.9.2.1008' (ar_odbc_conn.c:633)

00957509: 2025-08-26T07:45:39 [METADATA_MANAGE ]I:

[john_wang]

Hello @gopikrishnan06 ,

Thanks for the update.

Could you please uninstall version 2.9.2.1008 and reinstall version 2.8.2 instead? After completing the installation, please restart the Replicate services.

Regards,

John.

[gopikrishnan06]

Hi John,

i can see the ODBC driver as 2.9 as latest as we plan to upgrade the May 2025 version. currently we are using May 2024 version for that Qlik replicate Oauth verification not working. Kindly advise on it

[john_wang · Accepted solution]

Hello @gopikrishnan06 ,

Thanks for the update - Yes, even in Replicate 2025.5, the ODBC Driver 2.8.2 is required.

Regards,

John.

[john_wang · Accepted solution]

Hello @gopikrishnan06 ,

Any update on this issue? Could you please confirm whether the error was resolved after installing version 2.9.2.1008? Your feedback would be greatly appreciated.

thank you,

John.