Building the Connection URL

Use the connection URL to supply connection information to the data store that you are accessing. The following is the format of the connection URL for the Simba Amazon Redshift JDBC Driver, where [Host] the endpoint of the Redshift server and [Port] is the number of the TCP port that the server uses to listen for client requests:

jdbc:redshift://[Host]:[Port]

Note:

By default, Redshift uses port 5439.

You can specify optional settings such as the schema to use or any of the connection properties supported by the connector.

The following is the format of a connection URL that specifies some optional settings:

jdbc:redshift://[Host]:[Port]/[Schema];[Property1]=[Value];[Property2]=[Value];...

For example, to connect to port 9000 on a Redshift server in the us-west-1 region on AWS, access the schema named Default, and authenticate the connection using a user name and password, you would use the following connection URL:

jdbc:redshift://redshift.company.us-west-1.redshift.amazonaws.com:9000/Default;UID=simba;PWD=simba

Important:

Do not duplicate properties in the connection URL.