Skip to content

Setup for Vertica Connector

This section describes how to set up the Vertica connector in Privacera. Make sure you have completed the prerequisites before you start the setup.

Perform following steps to configure Vertica connector for PolicySync.

  1. SSH to the instance where Privacera is installed.

  2. Run the following command to navigate to the /config directory.

    Bash
    1
    cd ~/privacera/privacera-manager/config

  3. Run the following command to create a new directory:

    Bash
    1
    mkdir -p custom-vars/connectors/vertica/instance1`

  4. Copy the sample connector configuration file to your custom directory:

    Bash
    1
    cp sample-vars/vars.connector.vertica.yml custom-vars/connectors/vertica/instance1/

  5. Open the .YAML file for editing to customize it according to your configurations:

    Bash
    1
    vi custom-vars/connectors/vertica/instance1/vars.connector.vertica.yml

  6. Modify the following properties:

    • CONNECTOR_VERTICA_JDBC_URL - Enter the JDBC URL for connecting to the Vertica database
    • CONNECTOR_VERTICA_JDBC_DB - Enter the database where the connection will be established within Vertica.
    • CONNECTOR_VERTICA_JDBC_USERNAME - Enter the username for the Vertica database with admin privileges.
    • CONNECTOR_VERTICA_JDBC_PASSWORD - Enter the password for the Vertica database user used for connection.
    • CONNECTOR_VERTICA_DEFAULT_USER_PASSWORD - The default password assigned to new users created by Privacera in Vertica. If SSO is used for Vertica, set this value to none.
    • CONNECTOR_VERTICA_OWNER_ROLE - User to be set as owner for all the Vertica resources managed by privacera. Generally value of this should be same as Vertica JDBC username.

  1. Make the required changes in the file, save and exit the text editor.

  2. Once the properties are configured, run the following commands to apply your changes through Privacera Manager:

    Bash
    1
2
    cd ~/privacera/privacera-manager
./privacera-manager.sh update

  1. In PrivaceraCloud, go to Settings -> Applications.

  2. On the Applications screen, select Vertica.

  3. Enter the application Name and Description. Click Save. Name could be any name of your choice. E.g. Vertica Connector for account 123456.

  4. Open the Vertica application.

  5. Enable the Access Management option with toggle button.

  6. Under the BASIC tab, enter the values for:

  7. Vertica JDBC URL : jdbc:vertica://<vertica-host>:5433/<database-name>

  8. Vertica database to connect : <database-name> Database where the connection will be established within Vertica.
  9. Vertica JDBC username : vertica Username for the Vertica database with admin privileges.
  10. Vertica JDBC password : password Password for the Vertica database user used for connection.
  11. Default password for new vertica user : password for new users created by Privacera in Vertica. If SSO is used for Vertica, set this value to none.

  12. Vertica owner role : vertica User to be set as owner for all the Vertica resources managed by privacera. Generally value of this should be same as Vertica JDBC username.

  13. Click SAVE.

  14. The configured Vertica connector appears under Applications.

  15. Once saved and enabled, the Vertica connector will start. Then you can hover on the VIEW LOGS button to check the status, either Running or Stopped.

  16. Perform following steps to restart the Vertica connector application:

    1. Go to Settings → Applications → select the Vertica connector application.

    2. Edit the application → Disable it → and Save it.

    3. Open the same application again and then: Enable it → and Save it.

Comments