Partner Integration

How Cisco and Vertica empower high performance analytics for the most demanding workloads

This blog post was authored by Steve Sarsfield. Hadoop and HDFS is capable of storing massive volumes of data, but performing analytics on Hadoop can be challenging. Despite the apparent low-cost cost of Hadoop, it is best suited for data lake and data science solutions, where the number of concurrent analytical users is low. In […]

Integrating with Apache Spark

This blog post was authored by Soniya Shah. The Vertica Connector for Apache Spark is a fast parallel connector that allows you to use Apache Spark for pre-processing data. Apache Spark is an open-source, general purpose, cluster-computing framework. The Spark framework is based on Resilient Distributed Datasets (RDDs), which are logical collections of data partitioned […]

The Right Tool for the Job: Using Apache Hadoop with Vertica for Big Data Analytics

I have an entrepreneur friend who used to carry a butter knife around.  He claimed this “almighty” tool was the only one he ever needed!  While the butter knife does serve a wide range of purposes (especially with a stretch of the imagination), in practice it doesn’t’ always yield optimal results.  For example, as a screwdriver, it may work for common screws, but certainly not a Phillips (unless you push down very hard and hope not to strip the screw).  As a hammer, you may be able to drive finishing nails, but your success and mileage may vary.  As a pry bar, well, I think you get my point!  Clearly one tool isn’t sufficient for all purposes – a good toolbox includes various tools each fulfilling a specific purpose.

Jump Start your BI Dashboard Development with Vertica

Do you develop BI dashboards for Vertica? Or would you like to give it a try?

To help you get started, the Vertica Partner Engineering team has created a set of QuickStart BI sample apps. You can download them for free from the Microfocus Big Data Marketplace.

Jump Start your ETL Application Development with Vertica

Interested in exploring the Vertica Analytic Database in the context of data movement and transformation? To get a feel for it, try our new ETL QuickStart sample apps. You’ll find them on the Big Data Marketplace. Our Partner Engineering team develops QuickStart apps using tools from our technology partners. Currently we have ETL QuickStarts for […]

Vertica and OpenStack

Recently, several different customers have asked about deploying Vertica on an OpenStack cloud platform. This is an interesting situation, so to clear up any misconceptions, first we’ll go through a brief description of OpenStack. Then, we’ll suggest questions that you should ask yourself and your OpenStack administrator when deploying Vertica in an OpenStack environment.

Jump Start your BI Dashboard Development

Do you develop BI dashboards for Vertica? Or would you like to give it a try?

To help you get started, the Vertica Partner Engineering team has created a set of QuickStart BI sample apps.

Jump Start your BI Dashboard Development

Do you develop BI dashboards for Vertica? Or would you like to give it a try?

Installing Vertica SQL on Hadoop

Interested in adding Vertica’s analytic capabilities to your Hadoop cluster? Watch this tutorial video to learn how you can install Vertica on Hadoop, giving it faster access to your data!

Using Looker to Leverage Vertica Capabilities: ORC Reader, Flex Tables, and Place

Want some hints about how to use Looker to visualize data in your Vertica database? The Looker user community, known as Looker Discourse, has published three articles that explain how to use Looker with these Vertica features: ORC reader, Flex tables, and Geospatial functions and data

Using the Informatica PowerCenter Connector for Vertica

Have you been using the plug-in (Java or Native) that Vertica developed to connect to your Vertica database using Informatica PowerCenter? Now there’s a better option that provides additional functionality.

Kerberos Authentication for Hadoop Integration: Keeping your data safe

Like all Vertica releases, 7.1.2 includes a bunch of new features. One specific feature can help make your HDFS data safer: Kerberos integration for Hadoop. This blog will give you an overview of using Kerberos authentication with Vertica for SQL on Hadoop.

Vertica and Qlik Team Up to Hack for a Cause

On November 17 2014, Vertica took part in the annual Qlik Hackathon in Orlando, Florida. The hackathon, which took place the day before the Qlik World Conference, brought together engineers, developers, and Qlik experts from all over the world. The challenge was simple: leverage features from Qlik and its partners to create an application to aid the United Nations in their commitment to maintain international peace and security.

Using the Vertica ORC Reader with Business Intelligence Tools

What we are going to discuss is the new functionality introduced in Vertica 7.1 SP2 that allows customers to access files in HDFS stored in ORC format and achieve significant performance benefits compared to raw text files.

The Benefits of Vertica for SQL on Hadoop

If you store large data sets in Hadoop, you undoubtedly face many challenges in managing and analyzing that data. Did you know that Vertica for SQL on Hadoop can help ? Check out the scenario that follows to learn how.

Automatic Vertica Database Loader for AWS S3

Are you using Amazon Web Services for your Vertica cluster(s)? Are you staging your source data files on AWS S3 storage? If so, this AWS S3 loader for Vertica may be just the thing for you! It will automatically pick up files as they are dropped into S3, and load them into target tables in one or more Vertica clusters.

Vertica Storage Location for HDFS

Do you find yourself running low on disk space on your Vertica database? You could delete older data, but that sacrifices your ability to perform historical queries. You could add new nodes to your cluster or add storage to your existing nodes. However, these options require additional expense.

The Vertica Storage Locations for HDFS feature introduced in Vertica Version 7.1 offers you a new solution: storing data on an Apache Hadoop cluster. You can use this feature to store data in a Hadoop Distributed File System (HDFS) while still being able to query it through Vertica.