Alteryx Server - Data connections

[KanakaMohan]

In our environment we have controller, worker node & gallery nodes running on separate machines.

When users publish & schedules their workflow onto gallery node, the data source connections( used in workflow) to source & target databases(Ex: Oracle) will they get initiated from Gallery node, worker node or controller node ? The reason I ask is our source/target databases are behind firewall and I want to request port open between the Alterxy node machines and database. But I'm not sure from which node(gallery or controller or worker) will the connection originate to user mentioned database.

Thanks,

KM

[ArtApa]

Hi @KanakaMohan - On the Server, the connections go out from the Worker component.

Here is a high-level architecture:

The Gallery component is a web-based application that allows users to publish, share, and execute workflows and apps in a browser.

The Controller acts as an orchestrator of workflow executions and is responsible for the management of the service settings and the delegation of work to the Alteryx Service Workers.

The Worker contains an instance of the Engine and is responsible for executing the workflows.