Best Practice when Informatica and HP Vertica are on different networks
This best practice concerns communication with an HP Vertica cluster from Informatica when Informatica and HP Vertica are on separate networks. If Informatica and HP Vertica are on the same network, you do not need to implement the changes described here.
If Informatica and HP 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 Node Used for Import/Export. See also ALTER DATABASE and ALTER NODE in the SQL Reference manual for subnet and node-related tasks.
- The HP 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.)