ODBC connection string using SIMBA Presto driver

[charter747]

Hello. I need to connect to our AWS HUE environment from Alteryx server. I can get this to work if I connect using the named ODBC connection on my local. But once published, this will not work.

Can someone help me build the connection string?

This is what Alteryx uses to connect from my local:

odbc:DSN=EIM_Datamart;UID=username;PWD=pwd

This is my attempt:

odbc:DRIVER=Simba Presto ODBC Driver;Host=emr.eim.faa.gov;Port=8446;UID=username;PWD=pwd|||rdsfeeds

Am I missing parenthesis, brackets, ....

The error I'm getting with my attempt is:

Error: Input Data (5): Error SQLDriverConnect: [Simba][Presto] (1020) Error with HTTP API at http://emr.eim.faa.gov:8446/v1/statement : Unsupported protocol

To have the widest audience possible, I also posted this question on the "Server" side of the Alteryx Community.

Any advice is greatly appreciated

[apathetichell]

is the odbc driver set up and configured in odbc 64 - and if so do you have the name?

[charter747]

Yes, it is set-up on my laptop and it has a name; everything works perfectly on my laptop. But I don't want to refer to that name in the connection string since the odbc connection is not set-up on the server. The workflow will break once published to the server since that named connection does not exist. 

This is why I want to make a DSN-less connection. To do that, I need to know how to format the connection string.