topic SQL Server Standalone as source in Qlik Replicate

SQL Server Standalone as source

marcioribeiro — Thu, 17 Mar 2022 13:09:57 GMT

Hi,

Can someone provide me an example of how to configure QLik Replicate using SQL Server in standalone mode as source ?

I'm following the documentation, but I'm getting this error in Replicate:

Failed to initialize function for capturing data from an AlwaysOn Availability Group. AlwaysOn Availability Group is currently not ready to interact with REPLICATE.

I don't have AlwaysOn Availability Group in my environment. Thats why I'm trying to find a documentation for standalone mode.

Re: SQL Server Standalone as source

john_wang — Thu, 17 Mar 2022 13:27:14 GMT

Hello @marcioribeiro ,

To skip AlwaysOn configuration check you can add an internal parameter

AlwaysOnSharedSynchedBackupIsEnabled

in Source endpoint > Advanced > Internal Parameter, add the parameter, check the box to skip AlwaysOn configuration.

Hope this helps.

Regards,

John.

Re: SQL Server Standalone as source

SwathiPulagam — Thu, 17 Mar 2022 13:30:15 GMT

Hi @marcioribeiro ,

Replicate will run a couple of SQL commands to check whether the AlwaysOn setup exists or not on the server level. Maybe the database that you are using doesn't have an always-on setup but it could be enabled on the server level. Please check with DBA.

For now, you can use AlwaysOnSharedSynchedBackupIsEnabled Internl Parameter on the SQL endpoint. This will make sure replicate will skip the Always On validation step.

Thanks,

Swathi

Re: SQL Server Standalone as source

marcioribeiro — Thu, 17 Mar 2022 16:23:18 GMT

Thank you for your help. 👍