Terminating connection with SQL database in Azure overnight/ weekend

[Con]

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! 🙂

[SushilKumar]

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

[avidary_qlik]

 @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...

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

[Con]

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

[DesmondWOO]

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