This is the multi-page printable view of this section. Click here to print.
This section details how to install the client drivers and tools on Windows.
For connectivity through a JDBC connection, see Installing the JDBC client driver for windows. For all other client drivers and tools, see The Vertica client drivers and tools for windows.
To install the Vertica JDBC driver on your Windows client system, download the cross-platform JDBC driver .jar file to your system from the Vertica driver downloads page.
For your Java client application to use the Vertica JDBC driver, the Java interpreter must be able to find the driver's library file. Choose one of these methods to tell the Java interpreter where to look for the library:
Copy the JDBC .jar file you downloaded to the system-wide Java Extensions folder (for example, C:\Program Files\Java\jrex.x.x_x\lib\ext).
Add the directory containing the JDBC .jar file to the CLASSPATH environment variable (see Modifying the Java CLASSPATH).
Specify the directory containing the JDBC .jar using the -cp argument in the Java command line you use to start your Java application.
Download the Vertica Client Drivers and Tools for Windows installer from the Vertica driver downloads page. You can run the installer on a 32-bit or 64-bit system.
The Vertica Client Drivers and Tools for Windows installs the following components on your system:
Read System prerequisites before you proceed.
The Vertica Client Drivers and Tools for Windows has basic system prerequisite requirements. The pack also requires that specific Microsoft components be installed for full integration.
For a list of all prerequisites, see Client drivers support in the Supported Platforms document.
Before you install the Vertica driver package, verify that your system is fully up to date with all Windows updates and patches. See the documentation for your version of Windows for instructions on how to run Windows update. The Vertica client libraries and vsql executable install updated Windows libraries that depend on Windows service packs. Be sure to resolve any issues that block the installation of Windows updates.
If your system is not fully up-to-date, you may receive error messages about missing libraries such as api-ms-win-crt-runtime-l1-1-0.dll when starting vsql.
The .NET framework is not bundled into the Vertica Client Drivers and Tools for Windows. However, during installation, a web installer launches if Microsoft .NET 3.5 SP1 is not detected on your system. You then have the opportunity to download the framework. Also, if your operating system version includes .NET 3.5 SP1, but it is not turned on, the installer turns on the feature.
If you have Visual Studio 2010 or 2012 installed, your system already includes Microsoft .NET Framework 4.0 or 4.5, respectively. You also need Microsoft .NET 3.5 SP1 to use the Vertica Client Drivers and Tools for Windows integration features.
Use the following links to download the appropriate version of .NET framework directly from Microsoft:
For .NET Framework 3.5 SP1:
For .NET Framework 4.0:
http://www.microsoft.com/en-us/download/details.aspx?id=17851
For .NET Framework 4.5:
http://www.microsoft.com/en-us/download/details.aspx?id=17851
The Vertica Client Drivers and Tools for Windows installer provides a Visual Studio plug-in which allows you to use Vertica as a Visual Studio Data Source for Visual Studio 2008, 2010, 2012, 2013, or 2015. The connection properties for the plug-in are the same as ADO.NET connection properties.
After installing the plug-in, you can use it to access your Vertica database from within Visual Studio. If you do not have the SDK installed, download the SDK specific to your version of Visual Studio.
For the Microsoft Visual Studio 2008 SDK:
For the Microsoft Visual Studio 2008 SP1 SDK:
http://www.microsoft.com/en-us/download/details.aspx?id=21827
For the Microsoft Visual Studio 2010 SDK:
http://www.microsoft.com/en-us/download/details.aspx?id=2680
For the Microsoft Visual Studio 2010 SP1 SDK:
http://www.microsoft.com/en-us/download/details.aspx?id=21835
For the Microsoft Visual Studio 2012 SDK:
http://www.microsoft.com/en-us/download/details.aspx?id=30668
For the Microsoft Visual Studio 2013 SDK:
http://www.microsoft.com/en-us/download/details.aspx?id=40758
If the Microsoft Visual Studio SDK is missing when you begin the installation, a dialog box opens to tell you so. You can choose to ignore this dialog box.
The Vertica Client Drivers and Tools for Windows installer provides BIDS (Visual Studio 2008) or SSDT-BI (Visual Studio 2010, 2012, 2013, or 2015) integration. To use BIDS or SSDT-BI, follow this process:
Install the BIDS or SSDT-BI development tool add-on for Visual Studio.
Verify that SQL Server is installed on the same or a different machine.
Verify that the SQL Server Shared Features for BIDS or SSDT-BI have been activated.
You can then develop packages using BIDS or SSDT-BI, creating your projects using SQL Server’s SSIS, SSAS, SSRS features. To use these features, you must connect to Vertica through the Vertica ADO.NET driver (for SSIS and SSRS) or the OLE DB driver (for SSAS).
For more information, see Microsoft components.
Use SQL Server 2012, 2014 or 2016. The Vertica Client Drivers and Tools for Windows installer enables support for the following:
SQL Server 2012, 2014, and 2016:
SQL Server Integration Services (SSIS)
SQL Server Reporting Services (SSRS)
SQL Server Analysis Services (SSAS)
SQL Server using Visual Studio 2010, 2012, 2013, and 2015—SQL Server Data Tool - Business Intelligence (SSDT-BI)
To use the enhanced Vertica .NET support, you must first install SQL Server. Then, you can install the Client Drivers and Tools for Windows. The following components must be installed on the SQL server:
| For... | Install... |
|---|---|
| SSAS | The Analysis Services Instance Feature. |
| SSRS | The Reporting Services Instance Feature. |
| SSIS (Data Type Mappings) | The SQL Server Integration Services Shared Feature. |
| BIDS (for Visual Studio 2008) | Business Intelligence Development Studio Shared Feature only after installing Microsoft Visual Studio 2008. |
| SSDT-BI (Visual Studio 2010, 2012, 2013, or 2015) | SQL Server Data Tool - Business Intelligence Shared Feature only after installing Microsoft Visual Studio 2010, 2012, 2013, or 2015. |
The Vertica driver downloads page has the client drivers for all currently-supported versions of Vertica. The installation package works on both 32-bit and 64-bit versions of Windows.
You can install or upgrade the Windows client drivers and tools with the Windows installer or from the command line.
As Windows Administrator, double-click the Windows installer to start the installation. Follow the installer prompts as it guides you through each step of the process.
By default, the installer installs the client drivers and tools in C:\Program Files\Vertica Systems. You can change this location during installation.
As Windows Administrator, open a command-line session.
Navigate to the folder that contains the installer.
Run this command:
VerticaSetup.exe -q -install InstallFolder="C:\Program Files\Vertica Systems"
The client drivers and tools are silently installed in C:\Program Files\Vertica Systems.
After you install the Vertica Client Drivers and Tools for Windows, there are additional steps you must take for the ODBC driver and vsql client to function correctly.
ODBC Driver — After installing the ODBC driver, you must create a DSN to be able to connect to your Vertica database. For the procedure, see Creating an ODBC DSN for windows clients.
vsql Client — The vsql client does not have a shortcut. Before you can start using vsql, you must add the vsql executable to the Windows PATH environment variable. The method for altering the PATH environment variable depends on the version of the Microsoft Windows operating system you are running. To start vsql and show the help list, open a command window, and type vsql -? at the command prompt. See Using vsql for windows users for important details about using vsql in a Windows console.
To uninstall, modify, or repair the client drivers and tools, run the Client Drivers and Tools for Windows installer.
The installer provides three options:
| Action | Description |
|---|---|
| Modify | Remove installed client drivers and tools or install missing client drivers and tools. |
| Repair | Reinstall already-installed client drivers and tools. |
| Uninstall | Uninstall all of the client drivers and tools. |
As a Windows Administrator, open a command-line session, and change directory to the folder that contains the installer.
Run the command:
VerticaSetup.exe -q -uninstall
The client drivers and tools are silently uninstalled.