topic Re: Databricks OAUTH token Issue in Qlik Replicate

Databricks OAUTH token Issue

gopikrishnan06 — Mon, 25 Aug 2025 07:03:42 GMT

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

Re: Databricks OAUTH token Issue

DesmondWOO — Mon, 25 Aug 2025 08:31:32 GMT

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

Re: Databricks OAUTH token Issue

gopikrishnan06 — Mon, 25 Aug 2025 12:27:46 GMT

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]}

Re: Databricks OAUTH token Issue

john_wang — Tue, 26 Aug 2025 00:26:58 GMT

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.

Re: Databricks OAUTH token Issue

gopikrishnan06 — Tue, 26 Aug 2025 08:08:18 GMT

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:

Re: Databricks OAUTH token Issue

john_wang — Tue, 26 Aug 2025 08:37:50 GMT

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.

Re: Databricks OAUTH token Issue

gopikrishnan06 — Tue, 26 Aug 2025 09:46:48 GMT

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

Re: Databricks OAUTH token Issue

john_wang — Mon, 01 Sep 2025 01:19:03 GMT

Hello @gopikrishnan06 ,

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

Regards,

John.

Re: Databricks OAUTH token Issue

john_wang — Tue, 16 Sep 2025 03:28:37 GMT

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.