topic Re: Terminating connection with SQL database in Azure overnight/ weekend in Qlik Replicate

Terminating connection with SQL database in Azure overnight/ weekend

Con — Fri, 15 Nov 2024 21:27:59 GMT

Hi all, just working on a use case and got to know the client uses qlik replicate for datareplication. due to being a real time update tool it always has open connection with the SQL database in Azure. for our non-prod database resources, we want to terminate qlik replicate connections after hours and on weekends to enable the datatbase going into auto-pause. Does qlik replicate allow this temporary terminmation of connection on a periodical basis? thanks in advance! 🙂

Re: Terminating connection with SQL database in Azure overnight/ weekend

SushilKumar — Wed, 16 Aug 2023 07:46:17 GMT

Hello Team,

Qlik replicate opens connection with the configured endpoints as and when its required. if you want to terminate Qlik replicate connections after hours and on weekends to enable the database going into auto-pause. Then The best practice is to stop all the Qlik replicate task gracefully and do the cleanup of replicate connections on the configured endpoints.

Regards,
Sushil Kumar

Re: Terminating connection with SQL database in Azure overnight/ weekend

avidary_qlik — Wed, 16 Aug 2023 07:47:16 GMT

@Con ,

Thank you for approaching the community.

You can use the Qlik Replicate Scheduler to schedule a one-time job or a recurrent job for specific Replicate task operations

you can read more about it on the link below.

https://help.qlik.com/en-US/replicate/May2023/Content/Global_Common/Content/SharedEMReplicate/Server%20Settings/schedule_jobs.htm#Scheduling%20jobs

Please let us know if you need any more assistance
Thank you
Avidar

Re: Terminating connection with SQL database in Azure overnight/ weekend

Con — Thu, 17 Aug 2023 00:14:02 GMT

Hi @SushilKumar

thank you for the response. are you able to tell what are the implications when we resume the connections later? is there an automated native option for this where you could schedule this in advance? Thanks

Con

Re: Terminating connection with SQL database in Azure overnight/ weekend

DesmondWOO — Thu, 17 Aug 2023 10:01:33 GMT

Hi @Con ,

You can create two scheduled jobs: one job for stop task and one job for run task.

Your post does not specify the particular source endpoint being used. In general, resuming the task should suffice as Replicate is designed to save the last stream position. However, while Replicate is stopped, it is important to ensure transaction log is not archived or moved.

Regards,
Desmond