PowerExchange for Vertica User Guide for PowerCenter

10.4.0
- 10.5.4
- 10.5

Back Next

Importing Vertica Source and Target Definitions

To import a Vertica source or target definition, use an ODBC data source.

In the Source Analyzer, click

Sources

Import from Database

. Alternatively, in the Target Designer, click

Targets

Import from Database

The

Import Tables

dialog box appears.

Select the ODBC data source that you created for the Vertica database.

Enter the user name and password to connect to the Vertica database.

If you are not the owner of the table that you want to use, specify the owner name.

Click

Connect

A list of Vertica tables appears.

Drill down through the list of database objects to view the available tables.

Select the Vertica table that you want to import into the PowerCenter repository.

You can press and hold the Shift key to select a block of tables, or press and hold the Ctrl key to make non-contiguous selections. You can also use the

Select all

and

Select none

buttons to select or clear all available targets.

Click

If you imported a Vertica source, the selected source definition appears under the Sources node in the Navigator. If you imported a Vertica target, the selected target definition appears under the Targets node in the Navigator.

The database type in the source and target definitions appears as Vertica.

Vertica Sources and Targets

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal