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 https://my.vertica.com/dashboard/ 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:

How to enable Vertica network

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.

How to connect to Vertica database

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

How to use Vertica Admintools

Firewall can be stopped using
sudo service iptables stop