Skip to main content

Configure Connectivity for Amazon RDS

This section outlines additional configuration that may be required to create connections between the Designer Cloud Powered by Trifacta platform and your relational instances hosted on Amazon RDS.

Configure SSL Connections

You can configure your connection to use SSL for interactions with your Amazon RDS database.

Database server configuration: On the database side, you must disable SSL certificate validation. For more information, see https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.SSL.html.

Trifacta Application: Since you cannot upload your own SSL certificate to the Designer Cloud Powered by Trifacta platform, you must perform the following steps to disable SSL validation. These steps must be applied to any database connection in the Trifacta Application to an Amazon RDS database instance.

Steps:

  1. In the Connections page, select the Amazon RDS database connection that you wish to modify.

  2. In the Edit Connection window:

    1. Select the Enable SSL checkbox.

    2. For the Connect String Options:

      1. Find the appropriate connect string to disable client certification validation. See the documentation that was provided with your database distribution.

      2. Add that value to any existing value for the Connect String Options.

    3. Test the connection.

  3. Save your changes.

When the above is performed, the Trifacta Application is no longer expecting a valid certificate and can use SSL to communicate.