Share this article:

Vertica Integration with DbVisualizer: Connection Guide

For Vertica 7.1.x 

Introduction

DbVis Software's core product is DbVisualizer, a database tool. DbVisualizer lets you manage and administer database systems visually. This document lists the steps for connecting the DbVisualizer database tool to your Vertica database. To do so, you use the Vertica JDBC driver that is packaged with the DbVisualizer software.

About Vertica Connection Documents

Vertica connection guides provide basic information about setting up connections to Vertica from software that our technology partners create. These documents provide guidance using one specific version of Vertica and one specific version of the third-party vendor's software. Other versions of the partner product may work with Vertica. However, other versions may not have been tested.

Before You Begin

For clarification, there are three editions of DbVisualizer:

  • The DbVisualizer Free for Vertica edition is available on the Big Data Marketplace. This DbVisualizer Free for Vertica version includes several advanced functions of the DbVisualizer Pro version, along with Vertica customizations. This DbVisualizer Free for Vertica edition is the focus of this document.
  • The DbVisualizer Free edition is available on the DbVis Software site. This version does not include the advanced functions.
  • The DbVisualizer Pro edition is also available from the DbVis Software site. The Pro version includes Vertica customizations and, of course, all Pro features.

If you are upgrading from a pre-9.1.10 version of DbVisualizer Pro, see the section, Upgrading DbVisualizer Pro.

Versions Used in This Document

This document addresses these versions:

  • Vertica 7.1.x (DbVisualizer also works with Vertica versions 6.1.3 and 7.0.)
  • DbVisualizer 9.1.10 (DbVisualizer Free for Vertica Edition)

The DbVisualizer Free for Vertica edition provided on the Big Data Marketplace includes Vertica-specific enhancements. These enhancements are not available in the free edition you can download from the DbVisualizer site. For more information, see the description on the Big Data Marketplace.

You can use DbVisualizer on a number of platforms. This document leads you through configuring DbVisualizer on Microsoft Windows. For more information on DbVisualizer and a full list of supported platforms, see http://www.dbvis.com/download/.

Note The DbVisualizer Free for Vertica version includes the Vertica JDBC driver for release 6.1.x. Drivers are forward compatible. However, if you are using a later version of Vertica and want to access the new features in the latest release, download the latest driver from my.vertica.com.

Setting Up a Connection

For a short introduction on connecting to DbVisualizer, watch this connection video: 

Before you use DbVisualizer with Vertica:

  1. Go to the DbVisualizer Free for Vertica page on the Big Data Marketplace.
  2. Set your browser to allow pop-ups, and click the Free button on the upper right of the page.
  3. Type your Marketplace credentials.
  4. Download DbVisualizer. (You can choose to open or save the download.)

  5. Begin the DbVisualizer installation.

    Note If you need to install the Java Runtime Environment on your system, the DbVisualizer installation prompts you to do so and provides an opportunity to download it.

  6. When the Select Components wizard page opens, select the check box, Database Drivers to install the JDBC driver used to connect to Vertica.

  7. Connect your Vertica database. To do so, on the New Connection Wizard page, enter an alias for your new database connection, and click Next.
  8. On the Select Database Driver page, choose the Vertica driver from the list box, and click Next.
  9. On the next wizard page, enter the information specific to your Vertica database, as shown in the following figure. Then, click Finish.

    • Database Userid

    • Database Password
    • Database Server
    • Database Port
    • Database (name)

     

    database-info-fields.png

    To verify that you are using the DbVisualizer Free for Vertica version, check the DbVisualizer product name at the top of the screen.

    DbVisFreeforVertica.png

    Note The DbVisualizer Free for Vertica version includes the Vertica JDBC driver for release 6.1.x. Drivers are forward compatible. However, if you are using a later version of Vertica and want to access new features in the latest release, download the latest driver from my.vertica.com.

Once Connected to the Database

Once you have successfully created your new connection, DbVisualizer opens and you see your database connections listed on the Databases tab, under Connections.

If you select the database, connection details for that specific connection appear on the right.

To connect to your Vertica database, click the expand icon to the left of the database name. Once you click the icon, a successful connection shows a green checkmark and the database hierarchy expands.

DbVis-connect-screen.png

Once connected, you can review and work with your data. The DbVisualizer Free for Vertica version includes a number of Pro features. The following example uses a sample database named Vertica-test.

  1. Expand Schemas by clicking on the expansion icon.
  2. Expand Tables, and then expand a specific table.

    DbVis-projection1.png

  3. View a standard projection for a table by clicking it.

    DbVis-projection2.png

  4. Available only in the DbVisualizer Free for Vertica version, you can also click a specific projection for a column of the table.

    DbVis-project-column.png

There are a number of other Pro features available in the DbVisualizer Free for Vertica version.

For more information on using DbVisualizer, refer to the DbVisualizer documentation.

For information about the Vertica Analytics Platform, see the Vertica documentation.

Displaying Multilingual Characters

If multilingual characters from Vertica appear corrupted, it is probably because your font cannot display them correctly. To change the font, navigate to Tool Properties > General > Appearance > Fonts.

The following image shows some fonts that usually display multilingual characters as expected:

dbvis_fonts.png

Upgrading DbVisualizer Pro

If you are upgrading from a pre-9.1.10 version of DbVisualizer Pro, perform the following steps to make sure you can access the latest Vertica release functionality.

  1. On the Connection tab, for Database Type, choose Vertica from the list box.
  2. For Driver (JDBC), choose the Vertica packaged driver from the list box.

    DbVisProChange.png

If you do not make these changes, pre-existing connections continue to work. However, Vertica customizations do not appear.

Share this article: