ODBC via proxy
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?
-
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'?
-
Adrian Williams I'm trying to connect to AWS Athena.
-
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.
Please sign in to leave a comment.
Comments
3 comments