Connect to a Vertica Database Using the Connect ETL Vertica Load Example Files - Connect_ETL - 9.13

Connect ETL Vertica Load Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect (ETL, Sort, AppMod, Big Data)
Version
9.13
Language
English
Product name
Connect ETL
Title
Connect ETL Vertica Load Guide
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-11
ft:lastPublication
2023-09-11T19:09:11.694437

The Connect ETL Vertica load example files interface with a standard input connection and generate a native Vertica vsql command, which reads data from the connection and loads the data in parallel data streams directly to initiator nodes within the Vertica database.

The Connect ETL Vertica load example files enable the following: reuse and flexibility by allowing you to specify environment variable values based on your system configuration; direct access to the Vertica database; and enhanced optimization by bypassing the primary Vertica master director node and enabling direct communication with distributed Vertica initiator nodes.

For information on Connect ETL Vertica load example files connectivity, see Connect to Vertica Using the Connect ETL Vertica Load Example Files.

Location of Installed Connect ETL Vertica Load Example Files

The Connect ETL Vertica load example files are located in the Connect ETL home directory: <connect_install>\Examples\Database\Vertica\Target.