topic Re: Additional ODBC connection attributes for Azure Synapse target endpoint in Qlik Replicate

Additional ODBC connection attributes for Azure Synapse target endpoint

alessandroportaluppi — Mon, 28 Mar 2022 09:28:30 GMT

Hi everybody,

I have a problem regarding Synapse target endpoint. I need to add these additional connection parameters in order to estabilish a correct connection, but it seems that Replicate doesn't consider them, in fact it always gives me the error message "SSL Provider: The target principal name is incorrect".

I would ask if the syntax of "Additional connection properties" is set correctly in order to add parameters to the connection string.

Thank you all

Re: Additional ODBC connection attributes for Azure Synapse target endpoint

Shai_E — Mon, 28 Mar 2022 10:56:12 GMT

The syntax itself should be ok as far as i have seen
I would recommend first to do a test connection from Replicate then on the ODBC itself to see if it succeeds . if not, you are missing a detail i.e. FQDN is wrong / SSL is not set, etc..

plus why is TrustServerCertificate set to no?:

https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnectionstringbuilder.trustservercertificate?view=dotnet-plat-ext-6.0

Re: Additional ODBC connection attributes for Azure Synapse target endpoint

alessandroportaluppi — Tue, 26 Apr 2022 13:47:02 GMT

Thanks for your answer,

I've tried to estabilish connection with several clients, including ODBC endpoint, SSMS and DBeaver and it works. I have to set TrustServerCertificate = no because I need to use a different URL from FQDN (new url is mapped with a private endpoint connection via hosts file).

Re: Additional ODBC connection attributes for Azure Synapse target endpoint

lyka — Tue, 26 Apr 2022 21:59:35 GMT

Hi Alesssa,

Is this still an issue? If yes, i suggest opening a support case so we can collect verbose logging if needed

thanks
Lyka

Re: Additional ODBC connection attributes for Azure Synapse target endpoint

alessandroportaluppi — Thu, 28 Apr 2022 09:40:32 GMT

Hi Lyka,

I take this opportunity to ask how to open a support case for Qlik product

thanks

Alessandro

Re: Additional ODBC connection attributes for Azure Synapse target endpoint

JayashreeGuin — Thu, 28 Apr 2022 12:02:09 GMT

Hi Alessandro,

Please navigate to the below URL and Click on the Create Support Case. Fill in the necessary fields and submit.

thanks,
-jay