Once downloaded and installed you need to tell DBeaver which database manager you want to connect to. The screenshot to the right shows all of the different database managers that DBeaver can work with. Obviously we are going to choose Vertica on this screen.
If you haven't installed Vertica drivers on your laptop yet DBeaver gives you an opportunity to automatically do this. DBeaver automatically detects that you have no JDBC Vertica drivers installed and offers to install them for you.
You should now see the following screen:
Similar to SQL Server you need to know the host, dbname, and user/password that you want to connect to. Like SQL Server if you don't have the SQL Browser service running on your SQL Server, you will need to know the listening port. By default Vertica uses 5433.
If you are unsure of your listening port you can run
nano VMART/port.dat as dbadmin.
Once you have that you should be presented with the Database Navigator which is similar to SSMS's Object Explorer.
From here you can run queries and visually explore your Vertica database. Within 5 minutes you can install DBeaver and connect to VMart and issue your first query. I don't know how it could be any easier than that.
You have just read "[[Developing with Vertica]]" on davewentzel.com. If you found this useful please feel free to subscribe to the RSS feed.
Dave Wentzel CONTENT