How to Connect Vertica

Getting your data to Vertica is an easy task with Dataddo. If you already have your Vertica account connected to Dataddo, and you only need instructions on how to connect it to a Data Flow, you can skip Step 1 and start from Step 2 right away.

Step 1 - How to create a Vertica Data Destination

   
Number 1

Sign in to your Dataddo account and click on Destinations at the top of the page. Home Page - Destination

Number 2

Click on Create Destination in the top right corner.Data Destination - Create Destination

Number 3 From the list of sources, choose Vertica. You can type the connector's name into the search bar to find it faster.
Vertica - step 3
Number 4 Fill out all the files on the sign-in page to give DAtaddo all the necessary information to connect your data, and click on Save. Vertica- step 4

Step 2 - How to create a Vertica Data Flow

   
Number 1

Sign in to your Dataddo account and click on Destinations at the top of the page. Home Page - Data Flow

Number 2

Click on Create Destination in the top right corner.My Flows - Create Flow

Number 3 Click on Add Source to connect it to the destination. You can type the connector's name into the search bar to find it faster.
My Flows - New Flow
Number 4 Once you select your data source, click on Add Destination.
Vertica- Flow 4
Number 5

 

From the list of destinations, select Vertica. You can also type the name of the source into the search bar.Vertica- Flow 5
Number 6 Configure the destination by filling out necessary fields and click on Save flow.
Vertica- Flow 6a

NOTE: Fill out Database Table you want to send the data to. Remember to set the synchronization time for the flow with a little delay after the synchronization of your source to let the data load.

Vertica- Flow 6b configuration

Congratulations, your new Data Destination & Data Flow are ready!


Need assistance?

Feel free to contact us or create a ticket and we will help you set up the Data Source.