When connecting to Vertica via ODBC, on Linux as of Vertica version 6, and on Windows as of Vertica version 7, Connect uses Vertica COPY LOCAL to load data, which provides the best possible load performance. If running Vertica 6 on Windows, it uses multi-stream SQL INSERT.