Importing a Source Database Table

Note: Set up a DSN for your Vertica database before you perform the procedures that follow.

The following example that shows how to import a source table from a Vertica database.

  1. In Informatica PowerCenter Designer, select the folder in the repository where you want to create your Vertica source.

  2. Click the Source Analyzer icon.
  3. From the Sources list box, select Import from Database.

  4. From the Import Tables dialog box, choose the name of your ODBC data source, and enter Username and Password.

  5. Click Connect. Under Select tables, choose the schema public.

  6. Choose a table and Click OK. For this example, choose only the table, datatypes_src. (You can choose a number of tables.)

    The table appears in the Source Analyzer panel.

  7. Change the table's database type to VERTICA. To do so, double-click the name of the table to launch the Edit Tables dialog box.

  8. From the Table tab, Database type list box, choose VERTICA.

    Note: As of Informatica Version 9.6.1 Hot Fix 2 and later, if you want to use the version of Vertica you downloaded and installed, select the Vertica option from the dropdown menu. If you intend to use the new Vertica Connector from Informatica, select VERTICA from the dropdown menu.

  9. Click OK. You have imported a source table. Next, follow the procedure in, Importing a Target Database Table.