Alteryx Server Data Connections - How to set up an ODBC connection with SSL mode as allow?

[calvinwongalteryx]

Hi,

Hope someone can help with this.

I'm trying to set up an ODBC connection in the Alteryx server. I have gone through some other post and found that I can use the following to connect. However, in my case, I also need to choose the SSL mode as "allow" or "require". Does any one know what string do I need to add on in order to do so?

Much appreciate your help in advance.

[Amy_smart]

Here is a SSL helpful article: Denodo | Alteryx Help

[calvinwongalteryx]

My connection is not for Denodo. So this is not applicable in my situation. I will need the connection string itself as there are no options for SSL mode in this case.

[calvinwongalteryx · Accepted solution]

Actually I figured it out myself. I just have to type in "; sslMode=require"