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:

Important: If you are using the Vertica plug-in for Informatica on Vertica Release 6.x, the Informatica user must have the PSEUDOSUPERUSER role to access the export addresses on the different network. For general information on the PSEUDOSUPERUSER role, see the Administrator’s Guide, PSEUDOSUPERUSER Role. If you are using Vertica Release 7.0.x, the Informatica user does not need the PSEUDOSUPERUSER role.