Qlik Replciate - Export using QEM APIs - Endpoints issue

[ghassan1]

Hi,

We are using Qlik enterprise manager APIs for exporting/importing Qlik replicate tasks from DEV to QA. We are using following methods:

Export: https://{host}/attunityenterprisemanager/api/v1/servers/{ServerName}?action=export

Import: https://{Host}/attunityenterprisemanager/api/v1/servers/{ServerName}?action=import

Using above we were able to migrate all tasks and endpoints from DEV to QA. Using python we changed IPs from DEV to QA in JSON, then manually set passwords in QA (because passwords are encrypted in JSON).

Problem here is next time when we will again import repository it will overwrite passwords and we have to manually set again.

Is there any way to export all tasks using 1 API but it should not impact endpoints only update tasks?

Looking forward for guidance on this please.

Regards,

Ghassan

[john_wang]

Hello Ghassan, @ghassan1 

Do you mean that after the initial import, the endpoints remained unchanged and only other task settings were modified (for example, adding or removing tables)? In other words, the endpoint password was never changed, but each import still affected it, requiring you to re-enter the password repeatedly.

If that is the scenario, you may want to use the export&withendpoints option.

Hope this helps.

John.

[ghassan1]

Hi @john_wang ,

Initially QA Qlik replicate was empty. After initial export everything on DEV was migrated to QA including end points. Before importing  a script was used to update IPs of endpoints, then I updated passwords manually in "manage endpoints".

Problem is next time I want to import tasks only, I do not want to update endpoints. 

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

Above export method do have "withendpoints" option, but using this I have to mention task name, I have around 500 tasks on DEV. How can I use this API to extarct all tasks (Do not want to loop each task), is any such option available with exportrepository ? so I only run 1 API and it exports only tasks in JSON?

Thanks,

Ghassan

[john_wang]

Hello Ghassan, @ghassan1 

I understand your pain point now: you need to manually update the endpoint passwords in the GUI after each import.

For the moment, let's set aside the withendpoints option, as there is a better solution available for you.

You can specify the endpoint passwords in plain text within the JSON file. During the import process, Qlik Replicate will automatically encrypt the passwords and store the encrypted values in the repository. You need NOT to type password manually again.

Please note that this approach introduces a security risk, as the JSON file will contain passwords in plain text. Therefore, you should ensure that the file is properly protected and either securely stored or removed after the import is completed.

Hope this helps.

John.