Connecting to the UDW
Last updated
Last updated
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 .
Below are key concepts required to gets started with the UDW.
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 drivers and platform-specific drivers are available.
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 for additional details.
A JDBC 4.1 connection string for Redshift should follow this format:
<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.
An ODBC connection string for Redshift should follow this format:
<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.
<password> - A random-generated string password.
SSLMode - If the Redshift SSL certificate is not installed, the SSLMode must be "require" instead of "verify-ca"
<username> - A random-generated string username. A username and password will be provided via the .