topic Databricks token update in Qlik Replicate

Databricks token update

HarshulB — Tue, 08 Aug 2023 09:13:17 GMT

I have too many cdc pipelines currently running, with databricks aws as target, it is getting difficult to update token manually every 30 days so i have to 2 questions

1. Is it possible to update the token using rest api's?

2. Can i update the token using python script using selenium webdriver library ? If yes any additional precautions?

Thanks!

Re: Databricks token update

SwathiPulagam — Tue, 08 Aug 2023 15:45:04 GMT

Hi @HarshulB ,

You can export the task using below QEM API call and update the token before importing back to the Replicate.

https://help.qlik.com/en-US/enterprise-manager/May2023/Content/EnterpriseManager/EnterpriseManager_APIGuide/PythonAPI/api_exportTask.htm

https://help.qlik.com/en-US/enterprise-manager/May2023/Content/EnterpriseManager/EnterpriseManager_APIGuide/PythonAPI/api_importTask.htm

Note: Make sure to stop and resume the task if the token got expired already.

LIMITATION as below:

If a connectivity-token to Databricks expires during a task, you must stop and resume the task once the new token is set.

https://help.qlik.com/en-US/replicate/May2023/Content/Replicate/Main/Databricks%20Lakehouse%20(Delta)/databricks_delta_lakehouse_limitations.htm

Thanks,

Swathi

Re: Databricks token update

HarshulB — Wed, 09 Aug 2023 10:07:39 GMT

Hi Swathi,
I tried the method you mentioned
i am using below mentioned rest api

https://{Host}/attunityenterprisemanager/api/v1/servers/{ServerName}/tasks/{TaskName}?action=export&withendpoints={withendpoints}

For testing purpose, i changed the token/password manually(i.e without script) and tried to import the task back, but the test connection is not working. From the password in the json i suppose, there is some type of password encryption in the file.

Please let me know for further details

Re: Databricks token update

john_wang — Sat, 12 Aug 2023 07:37:14 GMT

Hello @HarshulB ,

Besides @SwathiPulagam comments, I'd like to show a feature enhancement request link, Create automatically new Databricks Token - Qlik Replicate. You may vote for it, or open a new one.

Regards,

John.

Re: Databricks token update

DesmondWOO — Mon, 14 Aug 2023 10:20:56 GMT

Hi @HarshulB ,

Please test if PatchEndpoint API meets your need.

Regards,
Desmond