Configure firewall rules for secure agent access

Firewall expectations

For a database to be successfully accessed by Informatica Data Management Cloud (IDMC), it must first accept connections from the IDMC Secure Agent. If the database has a firewall associated with it, any connection attempt without the appropriate firewall rule will most likely result in an error (returning only the vague message "Connection Refused" within IDMC).

To establish a successful connection, the database admin must edit the firewall to allow traffic from the Secure Agent. There are two Secure Agents running under the label ei.secureagent.wisc.edu — one for the test organization and one for production — and each has a separate IP address. These addresses are listed below.

Once the connection in IDMC and the firewall rules on the database are configured, you can test them using the Test Connection button in IDMC. If the connection fails, double-check the connection properties within IDMC and review the firewall traffic logs on the database to confirm no connection attempts are being blocked.

Note that an additional firewall layer within UW-Madison's edge routers governs all inbound traffic to the UW system. Traffic on certain ports — notably 1433 — will be blocked at the edge router. If you suspect this is the case, contact the Integration Team at integration-platform@doit.wisc.edu for support.