Share this article:

Vertica Integration with DBSolo: Connection Guide

About Vertica Connection Guides

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 third-party product may work with Vertica. However, these other versions may not have been tested.

About this Document

This document explains how to connect DB Solo, a feature-rich SQL query tool, with Vertica Analytic Database.

DB Solo Overview

DB Solo is a comprehensive, visual tool for developing and managing SQL code in relational databases. Its graphical user interface lets developers and DBAs easily browse schema objects, create scripts, and perform ad hoc DDL and DML operations. DB Solo runs on multiple platforms, supports multiple character sets, and allows multiple simultaneous connections.

To learn about DB Solo, visit the DB Solo website.

Vertica and DB Solo Product Versions

The information in this document is based on the testing we have done with the following software versions:

Software Version
DB Solo 5.2 Desktop platform Windows Server 2012 R2
Vertica Client Vertica JDBC 8.0.x
Vertica Server Vertica Analytic Database 8.0.x
Server Platform Linux CentOS 6.5

Install DB Solo

To install DB Solo:

  1. Navigate to the DB Solo website.
  2. Click the Download button.
  3. Under Download Free Evaluation Version, read the instructions and the license agreement.
  4. Select your platform, and click Download.
  5. Follow the installation instructions.

Install the Vertica Client Driver

DB Solo uses JDBC to connect to Vertica. DB Solo comes bundled with its own JRE, however a connection to Vertica requires the Vertica JDBC driver. To download and install the Vertica JDBC driver, follow these steps:

  1. Go to the Vertica Client Drivers page on vertica.com.
  2. Under All Operating Systems, select the JDBC driver for Vertica 8.0.x.
  3. Follow the instructions in the Vertica documentation to install the driver.

Note Vertica drivers are forward compatible, so you can connect to the Vertica server using earlier versions of the client. For more information about client and server compatibility, see Client Driver and Server Version Compatibility in the Vertica documentation.

 

Connect Vertica to DB Solo

  1. Start DB Solo and click the icon for Add New Server Connection.

  2. Click Servers and then Add New Server.

  3. In the Add Server Connection dialog box, click the + icon.

  4. In the Add JDBC Driver dialog box, type the values as follows:
    • Name: Type a name for the connection.
    • Driver Type: Select Vertica from the drop-down list.
    • URL: DB Solo provides the value.
    • Jar File: Click the Browse button and select the location of the Vertica JDBC Jar file.
    • Driver Class: DB Solo provides the value.

  5. Click Add.
  6. In the Add Server Connection dialog box, select the Vertica driver from the drop-down list and specify the connection information for the database.

  7. Click Test.
  8. When the connection succeeds, DB Solo displays the following message:

Compare Table Data in DB Solo

The Table Data Comparison Tool in DB Solo lets you compare data in one or more pairs of tables. The tables can be in the same or different schemas/databases, and they can have the same or different names and columns. You can compare tables in different databases, for example in two instances of Vertica, or you can compare data in two different database platforms, such as Vertica and SQL Server.

To compare table data:

  1. From the Tools menu, select Compare Data.

  2. In the Compare Table Data – Select Schema/Database dialog box, select the source and destination connections that contain the data you want to compare and click Next.

  3. In the Compare Table Data – Settings dialog box, select the information about the data that you want to compare and click Next.

  4. In the Compare Table Data – Select Tables dialog box, select the tables you want to compare and click Next.

  5. View the results of the comparison.

Compare Schemas in DB Solo

The Schema Comparison Tool lets you compare database schema objects in two separate schemas/databases. The tool reports any discrepancies between schemas such as missing or mismatching tables, table columns, indexes and constraints. The Schema Comparison Tool also detects discrepancies in column attributes, including data type, nullability and default value. You can compare schema objects in different databases, for example in two instances of Vertica, or you can compare schema objects in different database platforms, such as Vertica and SQL Server.

To compare schema objects:

  1. From the Tools menu in DB Solo, select Compare Schema.

  2. In the Compare Schemas – Select Schema/Database dialog box, select the schemas you want to compare and click Next.

  3. In the Compare Schemas – Settings dialog box, select the information you want to compare.


  4. Select the tables in each database and click the folder icon to view the results of the comparison in text format.

Find More Information

To learn more about Vertica, see the following:

Vertica Resource Description
Vertica documentation Documentation for the Vertica command language, tools, and utilities
Vertica Community Edition Community edition of Vertica for download free of charge
Vertica Big Data and Analytics Community Forum, Knowledge Base, blogs, and videos about Vertica

Share this article: