External API to trigger Qlik Replicate task

chandraprakash_j_volvo — Wed, 03 Jul 2024 05:18:19 GMT

Hello

Source : MS SQL Server (MS Replicate)

Target: Azure SQL Server

In source there are tables needs to gets truncated on daily basis. As replication is enabled on the source side truncate is getting blocked. So we disable the replication and do the truncate. Challenging part is truncate happens on different time for every table. So after truncate happens we will be notified. After that Full load hae to be done from the qlik replicate.

So my question here is:

1. After notification, can we use the external api to trigger the task in qlik replicate?

2. If above approach is possible,can we do Full load for particular table alone after each notification by using qlik? or external API?

Re: External API to trigger Qlik Replicate task

OritA — Thu, 04 Jul 2024 07:45:29 GMT

Hi,

QEM includes APIs that allow you to perform different actions in Replicate.
FYI - here is a link to the QEM documenation that lists the available options:
https://help.qlik.com/en-US/enterprise-manager/May2024/Content/EnterpriseManager/EnterpriseManager_APIGuide/Introduction/AEM_Intro.htm

As of QEM 2024.5 it is also possible to use QEM API for reloading one specific table within a task (reloadTable API) for further details please refer to the QEM user guide under:
https://help.qlik.com/en-US/enterprise-manager/May2024/Content/EnterpriseManager/EnterpriseManager_APIGuide/CurlAPI/api_reloadTable.htm

Regards,

Orit

topic External API to trigger Qlik Replicate task in Qlik Replicate

External API to trigger Qlik Replicate task

Re: External API to trigger Qlik Replicate task