Microsoft SQL server
Use SQL Server 2012, 2014 or 2016.
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)
Note
For SQL Server 2012, you can use either SQL Server 2012 or SQL Server 2012 SP1.
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. |