PowerExchange for Vertica User Guide for PowerCenter

PowerExchange for Vertica User Guide for PowerCenter

PowerExchange for Vertica Configuration Overview

PowerExchange for Vertica Configuration Overview

PowerExchange for Vertica is installed with PowerCenter.
You must configure PowerExchange for Vertica before you read data from or write data to a Vertica database. You can configure PowerExchange for Vertica on Windows and Linux operating systems.
To configure PowerExchange for Vertica, perform the following steps:
  1. Complete the prerequisites.
  2. Define the configuration options that the Vertica ODBC driver must use based on the operating system you use.
    • If you use Linux operating systems, create a configuration file named
      vertica.ini
      and define the Vertica configuration options in it. Define the VERTICAINI environment variable and set it to the path where you stored the
      vertica.ini
      configuration file.
    • If you use Windows operating systems, define the configuration options in the ODBC data source that you create to access the Vertica database.
  3. If you use bulk mode to write data, register the PowerExchange for Vertica plug-in with the PowerCenter repository.

0 COMMENTS

We’d like to hear from you!