How to call a stored procedure in Azure Synapse Analytics

KaelDowdy — Tue, 18 Jan 2022 17:39:57 GMT

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

Re: How to call a stored procedure in Azure Synapse Analytics

KellyHobson — Wed, 09 Mar 2022 20:48:15 GMT

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/EnterpriseManager_APIGuide/PythonAPI/aem_rest_api_intro.htm

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/Customize%20Tasks/tasks_headColumns.htm

Hope this is helpful!

Best,

Kelly

topic Re: How to call a stored procedure in Azure Synapse Analytics in Qlik Replicate

How to call a stored procedure in Azure Synapse Analytics

Re: How to call a stored procedure in Azure Synapse Analytics