Vertica Blog
Kathy Taylor smiling

Kathy Taylor

Information Technology Developer, Vertica

Kathy has worked as the technical writer and information developer for the Vertica Partner Engineering team for the past four years. She has many years of experience in the field of database documentation, including 20 years at Oracle. Kathy holds a Masters of Computer Science from Binghamton University and a BA in English and Creative Writing from Vassar College.

Connect With Kathy on

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 DbVisualizer: 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, introduced in DataGrip 2019.1, 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 Vertica Integration with DataGrip: Connection Guide. DataGrip is...
teammates looking at analytical data

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

Try Vertica in a Virtual Machine

Curious about Vertica? Check out the Vertica Community Edition VM! It’s a free, quick, and an easy hands-on introduction. In the VM, you’ll find everything up and running. You won’t have any setup to do. You’ll find a single-node installation of Vertica Community Edition with the VMart example database, the Vertica client tools, and a...

Microsoft Power BI: Latest Release Enhances Connection to Vertica

We are excited to announce the new Vertica connector introduced in the October 2018 release of Microsoft Power BI: • With PowerBI Desktop, Vertica is now fully supported using DirectQuery Mode (push-down optimization). • With Power BI Service (Cloud Offering - Saas), DirectQuery mode is now supported with Vertica using the Power BI On-Premises Gateway....