We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Comments

3 comments

  • Avatar
    Adrian Williams

    Can you confirm the system you are trying to connect to using ODBC?

    The post you reference above relates to MongoDB - is that the target in your situation?

    Is your proxy a gateway used for the routing of TCP connections in general or are you referring to the use of a MongoDB 'Mongos Proxy connection'?

    0
    Comment actions Permalink
  • Avatar
    Oliver Steadman

    Adrian Williams I'm trying to connect to AWS Athena.

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    I am not familiar with the Simba Athena ODBC driver. However, if you have configured the Athena DSN then you can use the DB Query node to access the service.

     

     

    It would be necessary to configure any DB options via the DSN/ driver configuration as the DB Query node does not offer the capability to set options.

    If this is not possible you may want to consider using the Athena JDBC driver in conjunction with the JDBC Query node. The JDBC Query node allows you to specify DB options using key=value pairs within the DbOptions property or within the JDBC connection string, as required.

     

    0
    Comment actions Permalink

Please sign in to leave a comment.