topic Re: Set up schedule full load job for multiple SQL source endpoint with different windows authentication service account in Qlik Replicate

Set up schedule full load job for multiple SQL source endpoint with different windows authentication service account

AKV0524 — Wed, 27 Mar 2024 13:10:21 GMT

Hi Team,

can we set schedule full load jobs in Qlik Replicate for multiple windows authentication service account for SQL Server source.

Thanks

Amit

Re: Set up schedule full load job for multiple SQL source endpoint with different windows authentication service account

Shai_E — Wed, 27 Mar 2024 14:16:34 GMT

Hi @AKV0524 ,

You can schedule tasks, but i do not understand the second part of the question.

Best Regards

Re: Set up schedule full load job for multiple SQL source endpoint with different windows authentication service account

DesmondWOO — Wed, 27 Mar 2024 16:14:17 GMT

Hi @AKV0524 ,

For Windows authentication, you need to set the Qlik Replicate user as the "Log on as" user for the "Qlik Replicate Server" service account. Since we have only one Qlik Replicate Service, it is not possible to configure multiple Windows Authentication. In such case, I recommend using "SQL Server Authentication" instead.

Please find this link for details.

Regards,
Desmond

Re: Set up schedule full load job for multiple SQL source endpoint with different windows authentication service account

AKV0524 — Wed, 27 Mar 2024 16:19:50 GMT

thanks for the clarification desmond