Connect ETL Job and Task Setup - 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

Consider the following workflow when implementing the ODBC job implementation strategy

  1. At the Database Connection dialog in the Task Editor, add and verify the database connection within Connect ETL.

    For information on adding a database connection and verifying the connection, see the “Database connection dialog” topic in the Connect ETL help.

  2. In the Task Editor, create the input data source and the target.
When defining the target in the Target database dialog, do the following:
  1. At the Connection field, select the database connection that you added at the Database Connection dialog.
  2. In the Tables section, select the Vertica table to which you will load data.
  3. In the Fields and Values section, map the input data source fields to the corresponding Vertica table fields.

When initiated, the task accesses the data from the defined source and loads it through the established ODBC connection to the Vertica database target.

For information on defining the task through the Task Editor, see the “Task Editor” topic in the Connect ETL help.