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 for which you want to increase memory from the list of available 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 you specified in your Amazon Redshift 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.