Connecting to the UDW

Amazon's Redshift is the technology underlying the Unizin Data Warehouse (UDW). For the most up to date information and details on connecting to the UDW, please see Amazon's documentation on connecting to a cluster.

Below are key concepts required to gets started with the UDW.

Redshift Drivers

Amazon's Redshift is based on PostgreSQL and many client tools that natively support direct connections to PostgreSQL will also connect to Redshift. This may not provide an optimal experience and Unizin recommends using Redshift drivers from Amazon when possible. Universal JDBC drivers and platform-specific ODBC drivers are available.

SSL

All connections to the UDW must be performed over Secure Socket Layer (SSL). It is recommended that the Redshift public certificates are utilized when connected to the IDWUDW Please read this article for additional details.

Connection Strings

JDBC

A JDBC 4.1 connection string for Redshift should follow this format:

jdbc:redshift:/<endpoint>:5439/<db-name>?ssl=true

• <endpoint> - The public URL of the Redshift cluster. Will typically be a friendly name such as "redshift.unizin.org". This will be provided during UDW implementation.

• <db-name> - The random-generated string name of your Redshift database. This will be provided during UDW implementation.

Your username and password will be specified outside of the connection string.

Additionally, you may append the following to the connection string if the Redshift SSL certificate is not installed, although this is not recommended.

&sslfactory=com.amazon.redshift.ssl.NonValidatingFactory

ODBC

An ODBC connection string for Redshift should follow this format:

Driver={Amazon Redshift (x64)}; Server=<endpoint>; Database=<db-name>; UID=<username>; PWD=<password>; Port=5439; SSLMode=verify-ca

• <endpoint> - The public URL of the Redshift cluster. Will typically be a friendly name such as "redshift.unizin.org". This will be provided during UDW implementation.

• <db-name> - The random-generated string name of your Redshift database. This will be provided during UDW implementation.

• <username> - A random-generated string username. A username and password will be provided via the Access Provisioning Process.

• <password> - A random-generated string password.

• SSLMode - If the Redshift SSL certificate is not installed, the SSLMode must be "require" instead of "verify-ca"