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 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:
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.