Security

Paige Roberts, Vertica Open Source Relations Manager
June 27, 2019

I just attended the for the first time. I spoke a little on a small panel with a couple of customers about 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 of , the presenter who put...

Machine learning robot studying equations and graphs

Doing In-Database Machine Learning 1 – Why Would You Do That?

Waqas Dhillon, Product Manager - Machine Learning, Vertica
April 22, 2019

Co-authored with Paige Roberts. A lot of modern like Vertica allow you to do machine learning from end to end, right in the database, rather than moving and transforming the data first into something like a Spark dataframe or a Python data structure. Whenever people hear about this capability, they have two questions. The first...

Revoke Access to Multiple System Tables from Multiple Users with a New Role

Jim Knicely, Vertica Principal Solution Architect
March 1, 2019

Vertica provides an API (application programming interface) for monitoring various features and functions within a database in the form of system tables. These tables provide a robust, stable set of views that let you monitor information about your system's resources, background processes, workload, and performance, allowing you to more efficiently profile, diagnose, and view historical...

Three 3D arrows, different colors pointing in different directions

Revoke Access From Just One System Table

Jim Knicely, Vertica Principal Solution Architect
February 28, 2019

Vertica provides an API (application programming interface) for monitoring various features and functions within a database in the form of system tables. These tables provide a robust, stable set of views that let you monitor information about your system's resources, background processes, workload, and performance, allowing you to more efficiently profile, diagnose, and view historical...

Single Sign-On for Support: New Login for Passport Users

Sarah Lemaire, Manager, Vertica Documentation
February 27, 2019

As part of the Micro Focus ongoing IT transformation, we have consolidated single sign-on systems to improve your experience of interacting with Micro Focus. All Passport users need to create a new account. To maintain your current access rights, you need to register with the same e-mail address you used with passport. If you use...

Multi-Factor Authentication for Vertica with Kerberos and Duo

Elizabeth Michaud, Principal Information Developer
January 30, 2019

This blog post was authored by Poojan Khanpara, Tom Wall, and Elizabeth Michaud. Multi-factor authentication (MFA) provides a secure method for validating users on login. And as we mentioned in another recent post, , the full implementation of GDPR may soon make multi-factor authentication a legal necessity for vendors doing business in the European Union....

What You Never Knew About Vertica Could Surprise You

Paige Roberts, Vertica Open Source Relations Manager
December 17, 2018

I just started working on the Vertica team. As the “new guy,” my first few weeks of work have been largely about cramming as much Vertica information into my brain as possible in the shortest time possible. That’s my favorite part of working in the big data analysis world. You always have to keep learning....

What’s New in Vertica 9.2?

Soniya Shah, Information Developer
December 5, 2018

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

Enabling Inter-Node Spread Encryption: Quick Tip

Phil Molea, Sr. Information Developer, Vertica
September 20, 2018

Jim Knicely authored this tip Internode SSL allows you to use SSL to secure communication between nodes within a Vertica cluster. It is important to secure communications between Vertica nodes if you do not trust the network between the nodes. The EncryptSpreadComm configuration parameter enables encryption on the control channel. dbadmin=> SELECT SET_CONFIG_PARAMETER('EncryptSpreadComm', 'vertica'); SET_CONFIG_PARAMETER...

GDPR READY RECIPE

Soniya Shah, Information Developer
June 25, 2018

This blog post was authored by Moshe Goldberg. Disclaimer This document content is for informational purposes only. The content here should not be relied upon as legal advice, or to determine how GDPR applies to your organization or you. We strongly advise working with a qualified legal GDPR professional to understand how the regulation applies...

What’s New in 9.1: Voltage SecureData Integration

Gary
June 6, 2018

Vertica Version 9.1 introduces a new integration with Voltage SecureData. This feature lets you use encryption to protect sensitive data within your Vertica database. It works within your existing database schema and clients. You can even automate data decryption. This automation makes decryption transparent and removes the need to change your existing SQL queries. What...

UPDATE: Vertica Test Results with Microcode Patches for the Meltdown and Spectre Security Flaws

Soniya Shah, Information Developer
May 21, 2018

This blog post was authored by Michael Leuchtenburg. Introduction Vertica engineers tested database performance with and without Meltdown and Spectre mitigations on both Haswell and Skylake microprocessors. As compared to no mitigation, with the fastest settings, we found a minimal, average 1% slowdown on Haswell, and an average 25% slowdown on Skylake. These results are...

Vertica Blog