Skip to content

Setup Vertica 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 followings:

    Important

    Identify the user who must have appropriate permissions in your data source. For scanning, you need a user with read permission and for processing compliance policies, you need read and write permissions. Login credentials of that user are needed for the JDBC Username and JDBC Password properties as shown below.

    • JDBC Url: jdbc:vertica://<host>:<port>/<database_name>

    • JDBC Username: <user_with_readwrite_permission>

    • JDBC Password: <login_credentials_of_identified_user>

    • JDBC Driver Class: com.vertica.jdbc.Driver

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

    Warning

    DO NOT modify the values of other properties, as they are set to their default values.

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

  7. Click SAVE

Comments