How to connect two Gateways

Ignition
1

I have two gateways set up. Gateway1 contains the database and the Tag Provider. Gateway2 is used to host my Perspective screens.

I'm trying to create a table that displays data from the Audit Profile. The Audit Profile is already configured and running.

The issue is that Gateway2 cannot access the database on Gateway1, so I’m unable to query the Audit_Events table from Gateway2.

If I can set up a database connection on Gateway2 that points to the database on Gateway1, I should be able to run a query and build the table I need.

Can someone provide step-by-step instructions on how to set up this remote database connection?

2

Ignition doesn't have any capability to expose a "remote" database provider; if you want a general purpose database connection on Gateway2, you will need to add a direct connection from Gateway2 to your primary database.

However, for the specific problem described, you can use a remote audit profile over the gateway network:

Connect the two gateways, set up your service security appropriately, and then create a "remote" audit profile on Gateway2 that points back to the DB on gateway 1. Ignition will transparently issue reads (and optionally writes) to the audit log back to gateway 1/the database.

1 Like