How to Connect to Vertica

Connecting to the database will require to enter the host, port, database user and password as explained in the Connection Dialog.
Tip Firewalls & anti-viruses may block database connections. Read How to enable Firewall connections.

Guided Installation

Download Vertica virtual machine ( .ova ) from Also download and install Virtual Box. Import the ova file in Virtual box. Starting the machine will ask for password. Enter 'password' in the input field. Turn network on:


Use 'admintools' to create and start a database, for example 'test'. When creating the database you will be asked for a password for the database.

Connect from DbSchema using the user dbadmin and the password used to create the database.


In admintools you can get also a database prompt. Please notice, the CREATE TABLE statements have to be in CAPITAL LETTERS.


Firewall can be stopped using
sudo service iptables stop