Local Ignition gateway to cloud database outbound only

Ignition
1

Hi,

I have a local gateway with a Microsoft SQLServer cloud database. My boss insists that the connection should be outbound only and we should use MQTT/Sparkplug B to connect to it.

Is that really necessary to have the connection outbound only?

Thanks

2

I suppose that if the local ignition instance will never need to read from the database then write only access is possible….although I personally have never seen this requirement. It seems to me this would limit you to the “C” in CRUD.

Custom CRUD restrictions such as this would be best accomplished in the database security settings, not Ignition.

I do not think it is possible to read or write to a SQL database via MQTT (although maybe someone can prove me wrong). Data should be written to a MS SQL database from Ignition via a scripted SQL query, a scripted named query, or Transaction Group.