---
title: "How to Connect Vertica"
slug: "vertica"
description: "Connect Vertica to your data with Dataddo. Easily create a Vertica Data Destination & Data Flow with our step-by-step guide. Get help from our experts."
updated: 2025-08-06T20:22:20Z
published: 2025-08-06T20:22:20Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Vertica

**Vertica** is a columnar analytics database management system designed for high-speed data analysis and storage. It excels at handling large volumes of data and executing complex queries quickly, making it suitable for businesses and organizations that require rapid and efficient data processing for analytical insights.

          **DATADDO TIP**

          

Dataddo supports **Vertica** as both a cloud-managed and an on-premises source or destination.

## Prerequisites

          
          

- You have a running Vertica database.

## Authorize Connection to Vertica

1. In the **Authorizers** tab, click on [Authorize New Service](https://app.dataddo.com/service/new) and select **Vertica**.
2. You will be asked to fill the following fields
  1. **Server IP or Hostname**: Public IP or hostname of your Vertica Server.
  2. **Database**: Name of the database used for writing or reading data.
  3. **Username**: Database username.
  4. **Password**. Database password.
  5. **Port**: Port to connect to SQL Server. The default value is **5433**.
3. [Optional] Configure your destination using an existing SSH tunnel or [create a new one](/docs/ssh-tunnelling).
4. Click on **Save**.

## Create a New Vertica Destination

1. On the **Destinations** page, click on the [**Create Destination**](https://app.dataddo.com/destinations) button and select the destination from the list.
2. Select your ***authorizer*** from the drop-down menu.
3. Name your ***destination*** and click on **Save**.

          Need to authorize another connection?

          

Click on **Add new Account** in drop-down menu during ***authorizer*** selection and follow the on-screen prompts. You can also go to the **Authorizers** tab and click on [**Add New Service**](https://app.dataddo.com/service/new).

## Create a Flow to Vertica

1. Navigate to **Flows** and click on [**Create Flow**](https://app.dataddo.com/flow/new).
2. Click on **Connect Your Data** to add your ***source(s)***.
3. Click on **Connect Your Data Destination** to add the ***destination***.
4. Choose the [write mode](https://docs.dataddo.com/docs/data-storages#write-modes) and fill in the other required information.
5. Check the **Data Preview** to see if your configuration is correct.
6. **Name** your flow and click on **Create Flow** to finish the setup.

### Table Naming Convention

When naming your table, please make sure the table name:

- Starts with an upper-case letter.
- Contains only:
  - Letters
  - Numbers
  - Underscores
  - Dashes
  - Non-Latin characters

---

## Related Articles

- [Data Backfilling to Storages](https://docs.dataddo.com/docs/data-backfilling-to-storages)
- [Write Modes](https://docs.dataddo.com/docs/data-storages#write-modes)
- [Implementation of Batch Ingestion to Data Warehouses](https://docs.dataddo.com/docs/ingestion-to-data-warehouses)
- [Network Access Control List (ACL) Configuration](https://docs.dataddo.com/docs/network-acl)
- [SSH Tunnelling](https://docs.dataddo.com/docs/ssh-tunnelling)
- [Data Transformations](https://docs.dataddo.com/docs/data-transformations)
- [Data Quality Firewall](https://docs.dataddo.com/docs/data-quality-firewall)