Databricks token update

[HarshulB]

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!

[SwathiPulagam]

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_A...

https://help.qlik.com/en-US/enterprise-manager/May2023/Content/EnterpriseManager/EnterpriseManager_A...

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...

Thanks,

Swathi

[HarshulB]

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

[john_wang]

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.

[DesmondWOO]

Hi @HarshulB ,

Please test if PatchEndpoint API meets your need.

Regards,
Desmond