How to call a stored procedure in Azure Synapse Analytics

[KaelDowdy]

Hi all!

I'm VERY new to Qlik Replication, so please be kind! 

I have a job replicating data from IBM Db2 to Microsoft Azure Synapse Analytics.  Is there a way to have the Qlik job call a stored procedure on the Synapse target after certain job steps? 

Part 2 bonus ?:  how can I capture certain values dynamically during run-time from within the Qlik replicate job and pass those values into input parameters in the Synapse stored procedure?

If there's documentation or threads which explain this info, I'm happy to read through it first...

Thanks!

Kael

[KellyHobson · Accepted solution]

Hey @KaelDowdy,

Welcome! Glad you are using Qlik Replicate.

At the moment, there is no functionality for Replicate to call a process on a target endpoint.

If you have access to Qlik Enterprise Manager, there is a list of API commands to get information about the task/ table status.

https://help.qlik.com/en-US/enterprise-manager/November2021/Content/EnterpriseManager/EnterpriseMana...

For question 2, again this will require some API or coding handiwork outside of Qlik Replicate.

We do support capturing some header information on the source which may be used in downstream processes.

https://help.qlik.com/en-US/replicate/May2021/Content/Global_Common/Content/SharedEMReplicate/Custom...

Hope this is helpful!

Best,

Kelly