10.3.1 Amazon RedShift

• About Amazon RedShift
  
• Before You Begin
  
• Create and Validate an Amazon RedShift Connection
  
• Use an Amazon RedShift Connection in Replicat
  

10.3.1.1 About Amazon RedShift

An Amazon Redshift connection stores the information that Oracle GoldenGate for DAA uses to connect to an Amazon Redshift cluster. After the connection is created and validated, you can reuse it when configuring Replicat processes that deliver transactional data to Amazon Redshift. Amazon Redshift is a fully managed cloud data warehouse service that Oracle GoldenGate supports through the Redshift Event Handler.

The connection definition stores the endpoint and authentication information separately from the Replicat configuration, allowing multiple Replicat processes to use the same validated connection.

10.3.1.2 Before You Begin

Before creating an Amazon Redshift connection, ensure that you have the following:

• An Oracle GoldenGate for DAA deployment.
• Network connectivity between the Oracle GoldenGate for DAA deployment and the Amazon Redshift cluster.
• A valid Amazon Redshift JDBC connection URL.
• An Amazon Redshift user name and password.
• The Amazon Redshift JDBC driver and any required client libraries, if they are not already available in the deployment.
  • To download the required dependencies, use the GG DAA Dependency Downloader:

    {GGforDAA install}/DependencyDownloader/redshift.sh 
                  2.1.0.30

  • Download the supported Amazon Redshift JDBC driver from:

    https://mvnrepository.com/artifact/com.amazon.redshift/redshift-jdbc42/2.1.0.30

  • After downloading the dependencies, configure the gg.classpath property in the Java Adapter properties file to include the downloaded libraries before starting the Replicat process.
• Configure common runtime settings, such as the runtime classpath, if additional libraries are required.
• Proxy information if the deployment accesses Amazon Redshift through an HTTP proxy.

10.3.1.3 Create and Validate an Amazon RedShift Connection

Use the Add Connection page to create an Amazon Redshift connection.

Procedure

1. In the navigation menu, select DB Connections.
2. Click Add Connection.
3. In Connection Alias, enter a unique name for the connection.

   From Technology Type, select Amazon Redshift.

4. In the Technology Settings section, provide the Amazon Redshift connection information.
   • Connection URL: Specifies the JDBC connection URL used to connect to the Amazon Redshift cluster. This field is required.
   • Username: Specifies the Amazon Redshift user name that Oracle GoldenGate uses to establish the connection.
   • Password: Specifies the password associated with the user name. This field is treated as sensitive information and is displayed as a password field.
5. Configure Common Settings, if additional runtime configuration is required.

   Classpath: (Required) Specify the full path to client libraries are required by the replicat type. You can use Dependency Downloader to download client libraries.

6. (Optional) Configure Proxy Settings if the Oracle GoldenGate deployment accesses Amazon Redshift through an HTTP proxy.
   • Proxy URL – Specifies the URL or host name of the proxy server used to access Amazon RedShift.
   • Proxy Port – Specifies the port number of the proxy server.
   • Proxy Username – Specifies the user name for proxy authentication, if required.
   • Proxy Password – Specifies the password for proxy authentication. This field is treated as sensitive information.
   • Truststore – Specifies the Java truststore file that contains the certificate authority (CA) certificates used to validate the proxy server certificate, when required.
   • Truststore Password – Specifies the password associated with the truststore.
   • Keystore – Specifies the Java keystore file containing the client certificate and private key used for client authentication, when required.
   • Keystore Password – Specifies the password associated with the keystore.
   • SSL Key Password – Specifies the password protecting the private key stored in the keystore when it differs from the keystore password.

   Note:

   If the Oracle GoldenGate deployment has direct network connectivity to Amazon Redshift, leave the Proxy Settings blank.
7. Click Submit
8. On the DB Connections page, click DB Login to validate the connection.

Note:

A successful DB Login validates only the saved connection information. It does not validate the Replicat configuration or Amazon Redshift Event Handler configuration. After successful validation, the connection is available for selection during Replicat creation.

10.3.1.4 Use an Amazon RedShift Connection in Replicat

After the Amazon Redshift connection has been successfully validated:

1. Create or edit a Replicat.
2. Select Amazon Redshift as the target technology.
3. Select the validated Amazon Redshift connection.
4. Complete the remaining Replicat configuration.
5. Create the Replicat.
6. Configure the remaining Amazon Redshift Event Handler properties, including the required runtime classpath and any staging configuration required by your deployment.