Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Configure Amazon Redshift for SSL

Configure Amazon Redshift for SSL

You can configure the Secure Agent to support an SSL connection to Amazon Redshift.
  1. Download the Amazon Redshift certificate from the following location: https://s3.amazonaws.com/redshift-downloads/redshift-ssl-ca-cert.pem.
  2. Run the following command to add the certificate file to the key store:
    ${JAVA_HOME}/bin/keytool –keystore {JAVA_HOME}/lib/security/cacerts -import -alias <string_value> -file <certificate_filepath>
    .
  3. In
    Administrator
    , select
    Runtime Environments
    .
  4. Select the Secure Agent from the list of Secure Agents.
  5. In the upper-right corner, click
    Edit
    .
  6. In the
    System Configuration Details
    section, change the
    Type
    to
    DTM
    .
  7. Click the
    Edit Agent Configuration
    icon next to
    JVMOption1
    and add the following command:
    - Djavax.net.ssl.trustStore=<keystore_name>
    .
  8. Click the
    Edit Agent Configuration
    icon next to
    JVMOption2
    and add the following command:
    - Djavax.net.ssl.trustStorePassword=<password>
    .
  9. Add the following parameter to the JDBC URL that you specify in the Amazon Redshift V2 connection properties:
    ssl=true
    . For example,
    jdbc:redshift://mycluster.xyz789.us-west- 2.redshift.amazonaws.com:5439/dev?ssl=true
    .
  10. Click
    OK
    to save your changes.