Microsoft visual studio

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.

Important

Important: You must have Visual Studio and the matching SDK installed to use the Visual Studio plug-in.

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.

Note

For Visual Studio 2015, you do not need to download the SDK separately as it is included as an installation option with the Visual Studio installation. For more information, refer to the Microsoft documentation.

For the Microsoft Visual Studio 2008 SDK:

http://www.microsoft.com/en-us/download/details.aspx?id=508
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.

Configuring BIDS or SSDT-BI integration

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.