This string includes the properties used to connect with the user ID/password authentication.

jdbc:datadirect:redshift://server_name:port_number;DatabaseName=database_name;
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.
user_name
specifies the user ID that is used to connect to the Redshift database.
password
specifies a password that is used to connect to your Redshift database.
property=value
specifies connection property settings. Multiple properties are separated by a semi-colon.

The following example connection string includes the properties required for connecting with the user ID/password authentication.

Connection conn = DriverManager.getConnection
("jdbc:datadirect:redshift://MyServer:5439;DatabaseName=MyDB;
  User=JSmith;Password=secret;");