The following processes may connect to your database server:
- VizQL Servers (they render your reports and connect to data sources all the time)
- Data Server Processes (the act as a proxy between the client and the database and connect to data all the time if you use them)
- Backgrounders (they refresh extracts and therefore connect to databases all the time IF you use exracts)
- AppServers (they occasionally connect to your data if someone does somethink like use TabCmd to export an report as an image)
You'll need to allow traffic from any box with one of these processes running on it (in this case, your worker) to pass thorugh your firewall.
Hope this helps!
Yes, Russell, this helps me a lot! Exactly what I need to know. Thank you for sharing with me. Much appreciated!