ODBC via proxy

Follow

Oliver Steadman

• December 10, 2019 18:48

ODBC connections are possible from Analayze (e.g. https://support.infogix.com/hc/en-us/community/posts/360029355654). However I can't find an example of anybody managing this over a proxy. I need to use a proxy. Can you help?

 

E.g. if using Simba as my ODBC driver (it has straightforward proxy configurations) then how in Analyze do I specify that I'm using Simba?

0

• 

  Adrian Williams

  • December 11, 2019 16:51

  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
• 

  Oliver Steadman

  • December 13, 2019 12:00

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

  0

  Comment actions Permalink
• 

  Adrian Williams

  • December 13, 2019 14:50

  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.