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 and password authentication:

  • Configure the minimum options required for a connection:
    • Set the Account Name (AccountName) to specify the name of your account and the region where it is hosted. For example, my_account.us-east-1.
    • Set the Database Name (DatabaseName) option to specify the name of database to which you want to connect.
    • Set the Warehouse (Warehouse) option to specify the name of the virtual warehouse to use, or an empty string.
    • Optionally, set the Schema (Schema) option to specify the schema to use for the specified database.
    • Configure your authentication related options. See "Authentication" for more information on these options.
  • 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.

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

Connection string

DRIVER=DataDirect 8.0 Snowflake;AccountName=MyAccountName.us-east-1;
   DatabaseName=MyDB;Schema=MySchema;Warehouse=MyWH;User=JohnQPublic;
   Password=SECRET;ProxyHost=pserver;ProxyPassword=proxys3cr3t;
   ProxyPort=1234;ProxyUser=jsmith;

odbc.ini

[Snowflake]
Driver=ODBCHOME/lib/xxsnowflake28.yy
...
AccountName=MyAccountName.us-east-1
...
DatabaseName=MyDB
...
HostName=myserver
...
Password=secret
...
ProxyHost=pserver
...
ProxyPassword=proxys3cr3t
...
ProxyPort=1234
...
ProxyUser=jsmith
...
Schema=MySchema
...
User=JohnQPublic
...
Warehouse=MyWH
...
Note: The User 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.