Skip to main content

Redshift

Following are the options specific to Redshift:

  • Connection Name: Enter a unique Connection Name. This fields accepts letters, numbers, and symbols.

  • SSL: For an additional layer of security check the SSL (Secure Socket Layer) checkbox. For details on how to setup SSL please refer to PK Protect Installation Guide.

  • Hostname: Enter the Hostname of the Redshift server or select from the list of available IPs.

  • Group/IP Range: Select the Group/IP range from the drop-down. For details on how to create and assign an IP range, please refer to the PK Protect Installation Guide.

  • AWS Secrets Manager: check this option, if you want to authenticate the connection using AWS secrets Manager.

  • Authentication Option: Select the authentication option from the drop-down.

    • Azure AD user with IAM Role – Select this option from the drop-down if you want to authenticate connection using Azure AD user with IAM Role.

  • Secret’s ARN: Enter the secret in this field.

  • Port Number: Enter the Port Number for establishing a connection. You can also edit the port number later, if required. This field is disable when AWS Secret’s Manager checkbox is checked.

  • Database Name: Enter the name of the database.

  • Username: Enter the database username. This field is disable when AWS Secret’s Manager checkbox is checked.

  • Password: Enter the database password. This field is disable when AWS Secret’s Manager checkbox is checked.

  • Use Connection String: A Connection String specifies the information about the data source and the means of connecting to it. Check the Use Connection String checkbox and provide the connection string. Use this option if you want to connect using the connection string instead of hostname and port number.

  • Connection Attribute: Select the attribute name from the Connection Attribute drop-down. This functionality allows you to add tags to the created connection.

  • Databases/Schemas: Enter the name of the database in the Filter By Schema/DB Name text box and press enter. This lists down the existing databases for the selected connection. Check the Include System Schema/DB Name checkbox if you want to include the system schema in the panel. It will list down the available databases/schemas for the connection.


Check the checkbox next to the name of the databases/schemas that you want to add as the target databases/schemas. The checked databases or schemas will be appeared in the Target Databases/Schemas panel.

To proceed further for remaining steps, refer Step 3 in AWS Detection.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.