The HP Vertica Client Packages for Community Edition download includes utilities for you to connect many client facing applications (Microsoft Excel, Power Pivot and Power Query to name a few) to your HP Vertica Community Edition Virtual Machine or cluster, and import data for reporting and analysis. All client packages contain the ODBC driver, the JDBC driver, and the Vertica vsql client software for the specified operating system. 64-Bit packages contain both 32-Bit and 64-Bit installers. Use the steps below to below to install the HP Vertica 7.0.1 Client Packages for the Community Edition. This tutorial assumes that you at minimum have access a running version of the HP Vertica 7.0.1 Community Edition Virtual Machine.
Navigate to my.vertica.com, log in using your MyVertica account credentials, and click the download
tab. Choose the appropriate link to the package for your specific operating system from the "Download HP Vertica 7.0.1 Client Packages for the Community
Edition" section, to begin the download. Once you have obtained the installer, navigate to your download path and double click.
Once the install begins you will be presented with the welcome screen below:
Click next and choose your destination folder.
Ensure that the features you wish to install are selected. In the below screen shot, all features are enabled for installation.
The ODBC interface enables connectivity for applications and clients written in C, Python, PHP, Perl, and most other languages. The JDBC interface enables connectivity for clients written in the Java programming language. The VSQL CLI Client enables you to connect to your HP Vertica VM directly through a Windows Command Prompt.
Click through the installation wizard to complete the installation. Once the installation is completed, you should set up either a User or System DSN for connectivity from your client applications. Go to your ODBC Data Source Administrator utility which should be located in your Administrative Tools menu. Opening the tool brings up the dialog below:
Click the "Add" button to create a new data source. Choose the Vertica driver that was just installed.
Specify the DSN name, the HP Vertica DB Server's IP address, Database, User name and Password. Also, ensure that port 5433 is specified if it is not automatically filled in.
Click the test connection button and ensure that your connection properties are correct. If everything is set correctly, you will received a connection succeeded message.
Click OK, and you should see the new DSN has been added as in the dialog below:
That's all to it. You should now be able to connect to your HP Vertica VM through any ODBC/JDBC compliant application. additionally, you will now have the capability to run VSQL from a Windows Command Prompt.
Let's test out the shell option. Assuming the server is up, and the database specified in the driver is running (the VM can only have a single database running at a time), Open a Command Prompt, type in the following command, and hit enter:
vsql -h192.XXX.XXX.XXX -Udbadmin
When the vsql prompt appears (dbadmin=>) type in any SQL of your choosing, and hit enter:
You are now ready to import data from your HP Vertica Community Edition Virtual Machine.
Happy coding!
Labels: Community Edition, HP Vertica, ODBC, vsql
