PowerExchange for Vertica User Guide for PowerCenter

10.4.0
- 10.5.4
- 10.5

Back Next

Vertica Sessions Overview

After you create a Vertica mapping in the Designer, you can create a session and configure the session to read data from or write data to a Vertica database. You can also run sessions on a grid.

You can use relational mode or bulk mode to process Vertica data. To read data, you must use relational mode. To write data, you can use relational mode or bulk mode.

Relational Mode: 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.
To read data in relational mode, you must create a Vertica relational connection and configure the session to use a relational reader. Then, define the session properties for the relational reader. The session properties for relational mode are the same as that of relational sources.
Similarly, to write data in relational mode, you must create a Vertica relational connection and configure the session to use a relational writer. Then, define the session properties for the relational writer. The session properties for relational mode are the same as that of relational targets.
Bulk Mode: Use bulk mode when you want to insert large volumes of data into a Vertica target.
To write data in bulk mode, you must create a Vertica bulk connection and configure the session to use a Vertica bulk writer. Then, define the session properties that the copy command must use to write data to the Vertica target.

Rename Saved Search

Table of Contents

PowerExchange for Vertica User Guide for PowerCenter

PowerExchange for Vertica User Guide for PowerCenter

Vertica Sessions Overview

Vertica Sessions Overview