Skip to content

Redshift#

This topic describes how to connect Redshift application to the PrivaceraCloud.

Connect Application#

  1. Go the Setting > Applications.

  2. In the Applications screen, select Redshift.

  3. Enter the application Name and Description, and then click Save.

    You can see Access Management and Data Discovery with toggle buttons.

    Note

    If you don't see Data Discovery in your application, enable it in Settings > Account > Discovery. For more information, see Discovery.

Enable Access Management#

  1. Click the toggle button to enable the Access Management for your application.

  2. In the BASIC tab, enter the values in the given fields and click Save. For property details and description, see table below:

    Note

    Make sure that the other properties are advanced and should be modified in consultation with Privacera.

    Property Description Example
    Service URL URL connection to Redshift repository. jdbc:postgresql://redshift-cluster-1.test.redshift.amazonaws.com:5439"
    Service name Connection service name.
    Service username Username database credential
    Service password Password database credential
    Service master database name
    Persist database connection

    Manage database list

    Manage schema list

    Manage user list

    Manage view list

    These three properties follow the same format. For each:

    Specify a list of zero or more names of databases, list of schemas, list of users, or list of views to be PrivaceraCloud managed.

    If left blank, all target {databases, schemas, users} in the repository will be managed.

    If set to none, no databases will be managed.

    Accepts single name or multiple names with comma separation.

    Regular expressions (Regex) can be used. (E.g. *_xx will match to names company_xx, products_xx, and so on.
    Service new user password The password value to be assigned to any new user created during policy synchronization.

  3. In the ADVANCED tab, you can add custom properties.

  4. Using the IMPORT PROPERTIES button, you can browse and import application properties.

Enable Data Discovery#

Click the toggle button to enable the Data Discovery for your application.

  1. In the BASIC tab, enter values in the following fields.

    • JDBC URL
    • JDBC Username 
    • JDBC Password

  2. In the ADVANCED tab, you can add custom properties.

  3. Using the IMPORT PROPERTIES button, you can browse and import application properties.

  4. Click the TEST CONNECTION button to check if the connection is successful, and then click Save.

Add Data Source#

To add a resources using this connection as Discovery targets, see Discovery Scan Targets.

Last update: March 29, 2022