Vertica is very fast columnar database designed by a legendary Michael Stonebraker.

We support Vertica directly in our products! You don't need separate drivers and can immediately connect to your database.

Vertica is designed to run on clusters and is used mainly for analytical purposes and data warehousing. Query performance is impressive, it's highly available and able to handle many terabytes of databases on commodity hardware. As database is internally organized in columnar fashion instead of common row-based one, aggregate data is typically returned several orders of magnitude faster.

Vertica exposes standard SQL interface with a lot of analytics capabilities built-in. A range of BI, data visualization, and ETL tools are certified to work with and integrate with the Vertica Analytics Platform..

In 2011, Vertica was acquired by Hewlett Packard.

Full Convert Pro Omni Loader

We support Vertica directly. No additional drivers are required.

Vertica data types we support


bigint (integer, int, int8, smallint, tinyint)


decimal (numeric, number), double precision (float8), float (real), money


char, long varchar, varchar


binary, varbinary


date, time (time withtimezone), timestamp (datetime, smalldatetime), timestamp withtimezone (timestamptz)

Large objects

long varbinary (raw, bytea), long varchar



Export your Vertica database

It may make sense to migrate your data away from Vertica. You may want to do it permanently or just need to share your tables with a collague in a different format.

We will copy all your tables with their data and apply indexing and relationships exactly as they are in your current Vertica database. In a nutshell, you get exactly the same database in another database engine. Each time you run the migration, we will copy all the tables again. Of course, we have a built-in scheduler, so you can run this overnight and have a fresh database copy in the morning.

Take a look at the quick tutorials below to see how it's done using Full Convert.

Export Vertica to: