Create an integration to manage access to a Vertica database

Vertica is a scalable and high-performance analytics database optimized for fast querying and analysis of large datasets. It delivers speed and flexibility for business intelligence and data warehousing applications.

Through this integration, Apono helps you securely manage access to your Vertica database and just-in-time (JIT) access to built-in and custom roles.


Apono ConnectorOn-prem connection serving as a bridge between a Vertica database instance and Apono:
Vertica InfoInformation for the database instance to be integrated:
  • Hostname
  • Port number
  • Database name

Create a Vertica user

You must create a user in your Vertica database instance for the Apono connector and grant that user permissions to the database resources.

Follow these steps to create a user and grant it permissions:

  1. In your preferred client tool, create a new user. Be sure to set a strong password for the user.

    CREATE USER apono_connector IDENTIFIED BY 'password';

  2. Grant the dbadmin role to the user. This allows Apono to create or drop tables and manage user roles and permissions within the Vertica database.

    GRANT dbadmin TO apono_connector;

  1. Using the credentials from step 1, create a secret for the database instance:

You can now integrate your Vertica database.

Integrate Vertica

Follow these steps to complete the integration:

  1. On the Catalog tab, click Vertica Database. The Connect Vertica Database page appears.
  2. From the dropdown menu, select a connector.


    If the desired connector is not listed, click + Add new connector and follow the instructions for creating a connector (AWS, Azure, GCP, Kubernetes).

  1. Click Next. The Complete setup page appears.
  2. Enter a unique, alphanumeric, user-friendly Integration Name. This name is used to identify this integration when constructing an Access Flow.
  3. Enter the Hostname of the Vertica database instance to connect.
  4. (Optional) Enter the Port value for the database. By default, Apono sets this value to 5433.
  5. Enter the Database Name.
  6. (Optional) In the Credentials rotation period (in days) field, enter the number of days after which the database credentials must be rotated.
  7. Under Secret Store, associate the secret:
  8. Click Connect.

Now that you have completed this integration, you can create access flows that grant permission to your Vertica database.