Vertica Blog

Vertica Blog

Integrations

Vertica text on blue background with purple jagged data line

Datadog Announces Integration with Vertica to Monitor Performance and Availability

Datadog helps customers ensure high performance and availability of their applications by providing visibility into the full application stack: infrastructure, middleware, and applications. They have achieved this by building a robust set of turn-key integrations that include SaaS and Cloud solutions, automation tools, databases and server components, and many more. Now, they have announced integration...

Introducing an Industry First – Vertica in Eon Mode for Pure Storage

This week at the Pure Accelerate conference, Vertica and Pure Storage announced the availability of Vertica in Eon Mode for Pure Storage, the industry’s first and only analytical database solution with a separation of compute and storage architecture for on-premises analytic workloads. Why is this important to you? The rush to migrate analytic workloads to...
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...
Go programming language logo and little blue beaver mascot

The Vertica SQL Driver for Go

We are happy to announce the alpha release of the Vertica SQL Driver for Go. Go, also called GoLang, is a statically-typed, high performance language, syntactically similar to C. Originating at Google, it has grown rapidly in popularity over the past decade and has become a language of choice for highspeed components. The Vertica SQL...
Data protection concept art

Data-Centric Security Rules

I just attended the Cybersecurity Summit in Dallas for the first time. I spoke a little on a small panel with a couple of customers about Voltage SecureData and Format Preserving Encryption (FPE). Then I got to go to other presentations and learned a lot. Probably the number one presentation that stuck with me, was...
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...

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

Plotting data with vsql and gnuplot

Maurizio Felici authored this post. We all know how plotting data is a very useful – and widely adopted – technique. Linux (and MacOS) offer a wonderful command line tool to plot data called gnuplot. You can install and run gnuplot on one of your Vertica nodes so you don’t have to move data out...

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

DbVisualizer Free for Vertica Distribution Updates

Stephen Crossman authored this post Recently, there have been some changes in how DbVisualizer Free for Vertica is distributed. Previously, there were standard DbVisualizer Free and Pro Edition distributions available on the DbVisualizer web site, and there was a special DbVisualizer Free for Vertica distribution available on the Vertica Marketplace. Now, in an effort to...
Three 3D arrows, different colors pointing in different directions

Exiting a DbVisualizer Script Following an Error: Quick Tip

After reading yesterday’s Vertica Quick Tip “Exiting a vsql Script Following an Error”, a client asked if the ON_ERROR_STOP variable is available in the popular third party Vertica client tool DbVisualizer. The answer to that is no, as ON_ERROR_STOP is a Vertica vsql client specific setting. However, many clients, including DbVisualizer, have a similar feature!...
Vertica and Python logos stacked

vertica-python Becomes Vertica’s First Officially Supported Open Source Database Client

Tom Wall authored this post. We are very excited to announce that vertica-python, the open source python database client for Vertica created by Uber Technologies Inc., will officially become a supported database client for Vertica! This is a great milestone for Vertica and our community of users and developers. Not only do we expect to...