How to set Port Number when setting up Data Connection in Alteryx Gallery?

avanibhatnagar

I am trying to set up a Data Connection in Alteryx Gallery. I have been able to do this before when there is a default port number with the connection. But this new Data Connection that I need to set up needs a port number specified. I do not see any way of specifying port number in the New Data Connection. I have tried putting it in after the host name separated by a comma and a colon and neither work.
(HOSTNAME:PORTNUMBER and HOSTNAME,PORTNUMBER) - neither of these 2 work in Alteryx. For this to work on my local machine I have to specify the port number after the hostname separated by the comma. Not sure how to make it work here.

Thanks for your suggestions in advance  

fmvizcaino

Hey @avanibhatnagar ,

You will need to customize the connection string.

Please configure the connection and save it without testing. For the database, select the option to type the database name as image below.

Then click the connection name and edit. Here you are allowed to customize the string and add the needed parameters.

For SQL Server, this is the correct structure for non-standard port:

Driver={ODBC Driver 17 for SQL Server};Server=myServerName,myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword;

You can find more here.

https://www.connectionstrings.com/microsoft-odbc-driver-17-for-sql-server/

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-format-common-ODBC-DSN-less-connection-strings/ta-p/467506

Best,

Fernando Vizcaino