This string includes the properties you may need to connect through a proxy server with UserID/Password authentication.

jdbc:datadirect:redshift://server_name:port_number;
DatabaseName=database_name;ProxyHost=proxy_host;ProxyPassword=proxy_password;
ProxyPort=proxy_port;ProxyUser=proxy_user;User=user_name;Password=password;
[property=value[;...]];

where:

server_name

specifies either the IP address or the server name of the primary database server.

port_number
specifies the TCP port of the primary database server that is listening for connections to the database.
database_name

specifies the name of the database to which you want to connect.

proxy_host
specifies the proxy server to use for the first connection.
proxy_password
specifies the password needed to connect to a proxy server for the first connection.
proxy_port
specifies the port number where the proxy server is listening for requests for the first connection. The default is 0.
proxy_user
specifies the user name needed to connect to a proxy server for the first connection.
user_name
specifies the user ID that is used to connect to the Redshift instance. For example, jsmith@example.com.
password
specifies the password used to connect to your Redshift instance.
property=value
specifies connection property settings. Multiple properties are separated by a semi-colon.

The following example connection string includes the properties required for using a proxy server with UserID/Password authentication.

Connection conn = DriverManager.getConnection
("jdbc:datadirect:redshift://MyServer:5439;DatabaseName=MyDB;
  ProxyHost=pserver;ProxyPassword=proxysecret;ProxyPort=808;ProxyUser=PUser;
  User=jsmith;Password=secret;");