In some environments, your application may need to connect through a proxy server, for example, if your application accesses an external resource such as a Web service. At a minimum, your application needs to provide the following connection information when you invoke the JVM if the application connects through a proxy server:

  • Server name or IP address of the proxy server
  • Port number on which the proxy server is listening for HTTP/HTTPS requests

In addition, if authentication is required, your application may need to provide a valid user ID and password for the proxy server. Consult with your system administrator for the required information.

For example, the following command invokes the JVM while specifying a proxy server named pserver, a port of 808, and provides a user ID and password for authentication:

java -Dhttp.proxyHost=pserver -Dhttp.proxyPort=808 -Dhttp.proxyUser=smith -Dhttp.proxyPassword=secret -cp greenplum.jar com.acme.myapp.Main

Alternatively, you can use the Proxy Host (ProxyHost), Proxy Port (ProxyPort), Proxy User (ProxyUser), and Proxy Password (ProxyPassword) connection options. See "Connection Option Descriptions" for details about these attributes.

To configure the driver to connect through a proxy server with the user ID/password authentication:

  • Set the Host Name (HostName) option to specify the name or the IP address of the server to which you want to connect.
  • Set the Proxy Host (ProxyHost) option to specify the proxy server to use for the first connection.
  • Set the Proxy Password (ProxyPassword) option to specify the password needed to connect to a proxy server for the first connection.
  • Set the Proxy Port (ProxyPort) option to specify the port number where the proxy server is listening for requests for the first connection. The default is 0.
  • Set the Proxy User (ProxyUser) option to specify the user name needed to connect to a proxy server for the first connection.
  • Set the User Name (LogonID) option to specify your user name.
  • Set the Password option to specify your password.

The following examples include the options required for using a proxy server with the user ID/password authentication.

Connection string

DRIVER=DataDirect 8.0 Greenplum Wire Protocol;HostName=MyServer;
ProxyHost=pserver;ProxyPassword=proxys3cr3t;ProxyPort=1234;
ProxyUser=jsmith;LogonID=jsmith@abc.com;Password=secret;

odbc.ini

[Greenplum Wire Protocol]
Driver=ODBCHOME/lib/xxgplm28.yy
...
HostName=myserver
...
ProxyHost=pserver
...
ProxyPassword=proxys3cr3t
...
ProxyPort=1234
...
ProxyUser=jsmith
...
LogonID=jsmith@abc.com
...
Password=secret
...
Note: The LogonID and Password options are not required to be stored in the connection string. They can also be sent separately by the application using the SQLConnect ODBC API. For SQLDriverConnect and SQLBrowseConnect, they will need to be specified in the connection string.