Vertica - Connect_ETL - 9.13

Connect ETL Installation Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect (ETL, Sort, AppMod, Big Data)
Version
9.13
ft:locale
en-US
Product name
Connect ETL
ft:title
Connect ETL Installation Guide
Copyright
2025
First publish date
2003
ft:lastEdition
2025-08-19
ft:lastPublication
2025-08-19T19:38:31.719000
L1_Product_Gateway
Integrate
L2_Product_Segment
Data Integration
L3_Product_Brand
Precisely Connect
L4_Investment_Segment
Application Data Integration
L5_Product_Group
ADI - Connect
L6_Product_Name
Connect ETL

The primary way to connect to Vertica databases is via ODBC. With Vertica version 7 or later, Connect establishes parallel connections using Vertica COPY LOCAL, providing optimal performance, ease-of-use, and dynamic tuning.

With older versions of Vertica, there are cases when the Connect Vertica Load Example Files method may perform better than the ODBC method, as described at the end of this topic in "Choosing a Method."