Communicating when Informatica and Vertica Are on Different Networks
This best practice concerns communication with a Vertica cluster from Informatica when Informatica and Vertica are on separate networks. If Informatica and Vertica are on the same network, you do not need to implement the changes described here.
If Informatica and Vertica are on separate networks:
-
Set up a public network for import/export and specify an export address for your individual nodes. See Using Public and Private IP Networks in the Administrator’s Guide, specifically the section, Identify the Database or Nodes Used for Import/Export. See also ALTER DATABASE and ALTER NODE in the SQL Reference manual for subnet and node-related tasks.
The Vertica plug-in for Informatica accesses the EXPORT_ADDRESS column of the V_Catalog schema. (For information on viewing the EXPORT_ADDRESS column, see the SQL Reference manual, specifically the section NODES in the V_Catalog Schema.)
-
Once the public network is set-up properly, and an export address is assigned to each node, Informatica can then read and write to a Vertica cluster on a different network.