Vertica

Vertica

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

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 petabyte-scale 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 supports Vertica database directly.

Vertica data types we support

Integral

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

Decimal

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

Text

char, long varchar, varchar

Binary

binary, varbinary

Date/Time

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

Large objects

long varbinary (raw, bytea), long varchar

Other

boolean

Export 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.

Import data into Vertica database

Additionally, if you want to import data on a regular basis and do not want to recreate the whole target database from scratch every time, but rather do tiny targeted sync of only changes since the last run, please use Full Convert Pro or Ultimate.

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