Connect using ODBC - 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-01-24
ft:lastPublication
2025-01-24T21:47:52.840000

When connecting to Vertica databases using ODBC, Connect uses different load methods based on the Vertica version, as shown in the following overview table:

Vertica Version Load Method
7 or later Multi-stream Vertica COPY LOCAL via ODBC on both Windows and Linux
6 or later

Linux: Multi-stream Vertica COPY LOCAL via ODBC

Windows: Multi-stream SQL INSERT via ODBC

Earlier than 6 Single-stream SQL INSERT via ODBC