Syntax

After registering the driver, the required connection information must be passed in the form of a connection URL. 

jdbc:datadirect:redshift://servername:[port][;property=value[;...]]
where:
servername
specifies the name or the IP address of the server to which you want to connect.
port
specifies the port number of the server listener. The default is 5439.
property=value
specifies connection property settings. Multiple properties are separated by a semi-colon. For more information on connection properties, see "Using Connection Properties".

The install_dir/samples directory, where install_dir is your product installation directory, contains a sample application that illustrates the steps of connecting to an Amazon Redshift database.

This example shows how to establish a connection to an Amazon Redshift database with user ID/password authentication:

Connection conn = DriverManager.getConnection
 ("jdbc:datadirect:redshift://Server3:5439;
  DatabaseName=Test;User=admin;Password=adminpass");