# Vertica[¶](https://doc.dataiku.com/dss/latest/connecting/sql/vertica.html#vertica "Permalink to this headline")

Note

You might want to start with our detailed tutorial for your first steps with SQL databases in DSS.

You might want to start with that tutorial. The rest of this page is reference information for Vertica.

DSS supports the full range of features on Vertica:

* Reading and writing datasets

* Executing SQL recipes

* Performing visual recipes in-database

* Using live engine for charts

DSS is tested on Vertica 7.1 and 7.2

## Installing the JDBC driver[¶](https://doc.dataiku.com/dss/latest/connecting/sql/vertica.html#installing-the-jdbc-driver "Permalink to this headline")

The Vertica JDBC driver can be downloaded from the Vertica website.

* If your database version is 7.1 or below, you need the 7.1 driver

* Else, we recommend the latest driver

The driver is a single JAR file called `vertica-driver-VERSION.jar`

* Copy the JAR file to the `lib/jdbc` driver of DSS

* Restart DSS

## Timezones support[¶](https://doc.dataiku.com/dss/latest/connecting/sql/vertica.html#timezones-support "Permalink to this headline")

Versions of the JDBC driver below 8.0 have some bugs related to timezones handling when reading “Timestamp (no timezone)” or “Date” kind of fields. Please use a more recent driver for full timezone support.
