ODBC connection to AWS HUE using Simba Presto ODBC 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

Any advice is greatly appreciated

[jforte]

@charter747 is your server behind a Proxy/Firewall?

[charter747]

yes

[jforte]

I'd suggest validating if the traffic is allowed in the Proxy/Firewall

[charter747]

It is. 

[apathetichell]

Hey @charter747 - wish I could help more - any chance you can go back through your parameters you have set up on your ODBC 64 connection and see if you are missing something you have configured in that connection but you aren't passing through in the serverless string? I'm not sure how Presto formats tablename/schema in an DSN string... Did you read through this post?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/DSN-less-connection-string-issue/td-p/...