ODBC connection to AWS HUE using Simba Presto ODBC Driver

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

Database Connection

Accepted answers

All comments

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/712595

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703