Skip to content

Setup Redshift on Privacera Portal

These steps apply to both Self-Managed and Data Plane deployments..

  1. For Self-Managed, log in to the Privacera Portal; for Data Plane, log in to the Privacera Discovery Admin Console.
  2. Navigate to Settings > Data Source Registration
  3. Under the system name you added here, click the more icon. Select Add Application > JDBC APPLICATION
  4. Under Configure JDBC Application, provide values for the Application Name and Application Code fields.

  5. Under Application Properties, provide values for the following:

    • JDBC Url: jdbc:redshift://<domainName>:<port>/<dbname>

    • JDBC Username: <user_with_read_permission>

    • JDBC Password: <user password>

    • JDBC Driver Class: com.amazon.redshift.jdbc42.Driver

    For more information about Driver Class You can refer List of JDBC Driver Class for all datasources

    Tip

    You don't need to update any other fields during the initial setup. You can update them later as needed.

  6. Click TEST CONNECTION. Ensure that a message named success is displayed.

  7. Click SAVE
Resource format for RedShift

Resources can be added in the following formats for Discovery Scanning:

  • redshift_schema_name/redshift_table_name
  • */redshift_table_name
  • redshift_schema_name/*
  • *_schema_*/*_table_*

Comments