You can use relational mode or bulk mode to process Vertica data.

In bulk mode, you can use PowerExchange for Vertica to write large volumes of data to a Vertica database. You can then run queries on the Vertica database to analyze the data. You use an ODBC data source to connect to the Vertica database. When you run a Vertica session in bulk mode, the PowerCenter Integration Service creates a pipe, runs the copy command, and writes the data to a pipe. The copy command reads the data from the pipe and writes the data to the Vertica target.

You can also use relational mode to read or write data. Use relational mode when you want to read large volumes of data from a Vertica source or when you want to update or delete data in a Vertica target.