VistaDB 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 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.
It's very easy to copy existing database tables into your Vertica database. Just point Full Convert to your source database, select your target and let it copy things over.
Tutorials showing how to copy data from another database into Vertica:
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.
Tutorials showing how to copy data from Vertica to another database: