topic Source Destination: Do you support Azure Synapse serverless SQL pool SQL edition in Qlik Replicate

Source Destination: Do you support Azure Synapse serverless SQL pool SQL edition

EdWu — Mon, 18 Sep 2023 19:37:54 GMT

Hi,

I installed the latest version for

- ODBC Driver 18 for SQL Server

- QLIK Replicate 2023.5.0.322

But I cannot connect to Azure Synapse serverless SQL pool edition. Below is the error:

SYS-E-HTTPFAIL, Failed to sample server version.
SYS,GENERAL_EXCEPTION,Failed to sample server version,Azure Synapse serverless SQL pool SQL edition is not supported

Can you please let me if Qlik Replicate support Azure Synapse Serverless?

Thanks in advance for all the help!

Sincerely,

Edward

Re: Source Destination: Do you support Azure Synapse serverless SQL pool SQL edition

john_wang — Tue, 19 Sep 2023 03:46:37 GMT

Hello @EdWu ,

Welcome to Qlik Community forum and thanks for reaching out here!

Qlik Replicate supports Synapse as target endpoint only (see Qlik Replicate Support Matrix) however this is no a prebuilt driver to support it as source endpoint yet. The workaround is using generic ODBC (Using ODBC to connect to a source, or Using ODBC with CDC as a source). To use the generic ODBC endpoint, Please reach out to your account manager or region sales manager for help.

Hope this helps.

Regards,

John.