Share this article: Vertica Integration with SQuirreL: 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, other versions may not have been tested. This document provides guidance using the software versions and hardware platforms described in the following topic. Vertica and SQuirreL Software Versions This document provides guidance using the software listed as follows: Software Version Partner Client SQuirreL 3.7.1 Desktop Platform Microsoft Server 2008 R2 Standard Vertica Client Vertica 9.0 JDBC driver Vertica Server Vertica Server version 9.0 Server Platform CentOS 6.7 SQuirreL SQL Client Overview SQuirreL SQL Client is a graphical Java program that allows you to browse data and schema objects and issue SQL commands in a JDBC-compliant database. SQuirreL is an open-source product. You can use plugins to extend the functionality of SQuirreL. For information about SQuirreL, visit the.

If you are new to SQuirreL, see the document that is posted there. Download and Install SQuirreL SQuirreL is available for download on the SQuirreL website,. Download the JAR file for the latest version of SQuirreL for your platform.

After you download the JAR, follow the instructions on the page to install SQuirreL. Note The installer and SQuirreL SQL Client version 3.

X require Java JRE 1.6. Optional Plugins The SQuirreL installer prompts you to select optional plugins. One of the plugins is for Vertica. You should install the Vertica plugin to obtain the following additional Vertica-specific information in SQuirreL: • Additional tabs for tables, including Content(+), Projections, and Source. • A Details tab for projections. When you choose the Vertica plugin, the installer places the plugin file in the plugins directory under install_path.

Windows 7 Download periodically updates pricing and information of SQuirrel SQL Client free download from the publisher, but some information may be out-of-date. Using cracks, warez serial numbers, registration codes or keygens for SQuirrel SQL Client license key is illegal.

The plugin file is called vertica.jar. When you choose the plugin during installation, it is activated automatically.

If you later decide you do not want to use the plugin, you can deactivate it. After deactivation, you can reactivate it. Follow the instructions in. Download and Install the Vertica Client Drivers Before you can connect to Vertica using SQuirreL, you must install the Vertica client package. This package includes the JDBC client driver that SQuirreL uses to connect to Vertica.

Download Vertica Client Drivers • Go to the page. • Download the version of the Vertica client package that is compatible with the architecture of your operating system and Vertica server version. Note Vertica drivers are forward compatible, so you can connect to the Vertica server using previous versions of the client. For more information about client and server compatibility, see in the Vertica documentation.

Install Vertica Client Drivers Based on the client package you downloaded, follow the installation steps in the Vertica documentation: • • Install the JDBC driver in a location that is easily accessible by SQuirreL. Connect SQuirreL to Vertica To configure SQuirreL to connect to Vertica you must create a driver object and an alias object.

Create a Driver Object • On the left side of the main SQuirreL window, select the Driver tab. • Click the + icon at the top of the pane to open the Add Driver dialog box. • In the Name field, enter a name for the driver.

In the examples that follow, the driver name is Vertica_9.0. • In the Example URL field, add the JDBC URL, including the driver type, IP address, port, and database name. Driver class com.vertica.jdbc.Driver successfully registered for driver definition: Vertica_9.0 • If you want to automatically connect to Vertica at startup, check the Connect at Startup box. Create an Alias Object • On the left side of the main SQuirreL window, select the Alias tab. • Click the + icon at the top of the pane to open the Add Alias dialog box. • In the Name field, enter a name for the alias. • From the Driver drop-down list, select the Vertica driver object that you created previously.

Windows Internet Explorer 7 MUI Pack for Windows XP SP2 Free Add a set of language-specific resource files to Windows with Internet Explorer 7 installed. Drivers for windows xp sp2.