Vertica Blog

Vertica Blog

Partner Integrations

Construction site crane building a blue SQL 3D text.

Creating Vertica Functions in Third Party Tools

Third party SQL client tools that connect to Vertica often provide a SQL command window where you can type SQL commands and view the results. Most of these tools’ SQL command windows support issuing multiple commands in a single SQL block, using the semicolon as the command delimiter. Here is an example in : The...
Connecting grip

JetBrains DataGrip Offers New Vertica Connector

We are pleased to announce that JetBrains has released a Vertica connector for DataGrip! The connector, , allows SQL developers to use DataGrip to interact with Vertica. DataGrip uses Vertica’s JDBC driver to connect to Vertica. For details about connecting DataGrip to Vertica, see . is a database IDE that offers efficient schema navigation, an...
Vertica One on One with Davin Potts, CEO Appliomics, Founder KNIME, Core Python Committer

One on One with Davin Potts: 2. Advantages of KNIME and Letting Databases Do What Databases Do Best

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. I divided the conversation into multiple chunks by subject, and will post them up one subject at a time. In this second post, we discuss the advantages of KNIME for a...

Vertica Dialect for Hibernate Updated!

The Vertica dialect for Hibernate, updated for Vertica 9.2 and Hibernate 5.4.1, is now available for download. The dialect enables Hibernate to map Java classes to database tables in Vertica. Hibernate is an open-source, Object/Relational Mapping (ORM) framework for Java environments. With Hibernate, developers can create an object library that encapsulates object/relational mapping information for...

What’s New in Vertica 9.2?

Soniya Shah authored this post. The latest version of Vertica was released earlier this month and with it comes a host of new features. In Vertica 9.2, we introduced several new features including: Eon Mode Updates Management Console changes Performance improvements Upgrade and installation changes Voltage SecureData updates Management Console Changes These Management Console updates...