Vertica Integration with Dataddo: Connection Guide

About Vertica Connection Guides

Vertica connection guides provide basic instructions for connecting a third-party partner product to Vertica. Connection guides are based on our testing with specific versions of Vertica and the partner product.

Vertica and Dataddo: Latest Versions Tested

Software Version
Partner Product

Dataddo

Partner Product Platform On Cloud
Vertica Client Vertica SQL Driver for GO (vertica-sql-go-1.1.1-21533) (Bundled with the Cloud version)
Vertica Server Vertica Analytic Database 11.1.0
Vertica Server platform Red Hat Enterprise Linux 7.3

Dataddo Overview

Dataddo is a cloud based data integration and management platform. Dataddo is a no-code data integration platform designed to connect your analytic and business data to any BI application, database, or storage.

Creating a Dataddo Account

You can create a trial account for 14 days.

  1. Navigate to https://app.dataddo.com and sign up to create an account.
  2. Provide your email address and activate your account by filling the registration details.

Connecting Dataddo to Vertica

Dataddo uses Vertica SQL Driver for GO to connect to your Vertica database. Vertica-sql-go is packaged with Dataddo, so you do not need to install the Vertica driver separately.

  1. Navigate to https://app.dataddo.com and log in with your Dataddo account.
  2. Click Destinations > Create Destination.

  3. Select the destination as Vertica from the list of destinations.

  4. Provide the connection information: DESTINATION NAME, DB HOST, DATABASE, USERNAME, and PASSWORD.

  5. Click Save.

Creating a Vertica Data Flow

In this example, we created a flow which reads data from JSON and processes the data into a Vertica destination.

Note Dataddo only supports Vertica as a Destination.

  1. Click Flow > Create Flow.

  2. Click Add Source and select a source from the list or click Create New Source.

  3. Click Add Destination to add the Vertica target.

  4. Select the Vertica destination that you created earlier.

  5. Configure the destination by providing the following information: DATABASE TABLE, SYNC FREQUENCY, TIMEZONE based on your requirement.

  6. Click Save Flow.

Known Limitations

Note BINARY, VARBINARY, LONG VARBINARY, and LONG VARCHAR data types are not tested yet.

For More Information