SQL Server Integration Services (SSIS) Support
BIDS or SSDT-BI includes the Integration Services project for developing ETL solutions. This project type includes templates for:
- Data sources
- Data source views
It also provides the tools for working with these objects.
You can find support for using Vertica as a data source and target from both SSIS and the import/export wizard. You must install mapping files specific to Vertica on the Integration Server and BIDS or SSDT-BI workstation to enable this capability. The Vertica Client Drivers and Tools for Windows installs these mapping files as the "SQL Server Type Mappings" component(s) in both 32-bit and 64-bit versions.