Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

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 Connector for SSL

Configure Amazon Redshift Connector for SSL

To use SSL to connect to Amazon Redshift, you need to configure the Secure Agent for SSL and enable SSL through the JDBC URL in the Amazon Redshift connection properties.
  1. Download the SSL certificate for Amazon Redshift.
  2. To add the certificate file to the key store, run the following command in the command prompt:
    ${JAVA_HOME}/bin/keytool –keystore {JAVA_HOME}/lib/security/cacerts -import -alias <alias_name> -file <certificate_filepath>
    When prompted, enter the keystore password.
  3. Log in to your Informatica Intelligent Cloud Services account.
  4. In
    Administrator
    , click
    Runtime Environments
    .
  5. Select the Secure Agent and click
    Edit Secure Agent
    in the Actions menu.
  6. In the
    System Configuration Details
    section, configure the following properties:
    1. Select the
      Service
      as
      Data Integration Server
      .
    2. Select the
      Type
      as
      DTM
      .
    3. Click the
      Edit Agent Configuration
      icon next to
      JVMOption1
      and add the following value:
      -Djavax.net.ssl.trustStore=<trustore_path>
    4. Click the
      Edit Agent Configuration
      icon next to
      JVMOption2
      and add the following command:
      -Djavax.net.ssl.trustStorePassword=<password>
      Specify the same password you used when importing the certificate in step 2.
  7. Click
    Save
    .
  8. In
    Administrator
    , click
    Connections
    .
  9. Edit your Amazon Redshift connection and add the following parameter to the JDBC URL:
    ssl=true
    .
    For example,
    jdbc:redshift://mycluster.xyz789.us-west- 2.redshift.amazonaws.com:5439/dev?ssl=true
    .
  10. Click
    Save
    .

0 COMMENTS

We’d like to hear from you!
Pramod Paranjape - July 23, 2025

This kb is incomplete
I needed a support engineer for every step

Informatica Documentation Team - July 24, 2025

Hi Pramod,

We'd like to get some more information about your comment. Could you please clarify and let us know what is missing in this topic?

Regards,

Informatica Documentation Team