Configuring Proxy Connections

You can configure the connector to connect through a proxy server instead of connecting directly to the Athena service.

Important:

Important:

If you are connecting to Athena through a proxy server, make sure that the proxy server does not block port 444. The result set streaming API uses port 444 on the Athena server for outbound communications. For more information, see Use Result Set Streaming.

You can set the connection properties described below in a connection string or in a DSN (in the odbc.ini file). Settings in the connection string take precedence over settings in the DSN.

To configure a proxy connection :

  1. To enable proxy connections, set the UseProxy property to 1.
  2. Set the ProxyHost property to the IP address or host name of your proxy server.
  3. Set the ProxyPort property to the number of the TCP port that the proxy server uses to listen for client connections.
  4. Set the ProxyUID property to your user name for accessing the proxy server.
  5. Set the ProxyPWD property to your password for accessing the proxy server.

If the proxy server is configured to intercept SSL-encrypted connections, then in addition to specifying the proxy server information described above, you must also export the proxy server's root certificate onto your machine and configure the connector to use it.

To export and specify the proxy server's root certificate:

  1. Export the proxy's certificate as a .pem file. You can do this using OpenSSL.

    If necessary, you can export the certificate as another format, such as .cer, and convert that file into a .pem file.

    For example:

    openssl x509 -inform der -in certificate.cer -out certificate.pem

  2. In your connection string or DSN (in the odbc.ini file), set the TrustedCerts property to the full path and name of .pem file containing the proxy server's root certificate.

Related topics