Connecting to a AWS Redshift instance via Masking engine extended connector (KBA7728)
KBA
KBA# 7728
Issue
The Masking engine does not provide a connector for AWS Redshift out of the box.
Prerequisites
- Access to an AWS Redshift instance.
- Delphix masking engine 6.0.6.0+.
- Please note our support policy on extended connector: Delphix Extensibility Support
Applicable Delphix Versions
- Click here to view the versions of the Delphix engine to which this article applies
-
Major Release All Sub Releases 6.0 6.0.6.0, 6.0.6.1, 6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0, 6.0.10.0, 6.0.10.1
Resolution
- Download the latest version of the AWS Redshift JDBC driver: Download redshift JDBC Driver.
- Upload an extended driver as per our documentation: Managing Extended Connectors.
Please make sure that the zip file contains all the required files to have the driver to work.
- AWS Redshift requires you trust their certificate to allow the connection: Connecting SSL Support.
The certificate can be added to the Delphix engine via the Server Setup application as described here: Certificate Management Truststore Settings.
- Restart the Masking service once the certificate has been uploaded: Restarting Masking Engine Service and Nonresponsive Issues (KBA5906). Please make sure there are no running jobs before initiating the restart.
Related Articles
The following articles may provide more information or related information to this article: