# Ignition Architecture question

**URL:** <https://forum.inductiveautomation.com/t/ignition-architecture-question/82240>\
**Category:** Ignition\
**Tags:** database, ignition81, perspective\
**Created:** [November 22, 2023, 9:05am UTC](https://forum.inductiveautomation.com/t/ignition-architecture-question/82240 "2023-11-22T09:05:27Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![pgmo](https://avatars.discourse-cdn.com/v4/letter/p/d07c76/32.png) [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\
**Post date:** [November 22, 2023, 9:05am UTC](https://forum.inductiveautomation.com/t/ignition-architecture-question/82240/1 "2023-11-22T09:05:27Z")

</div>

Hi all,  
a customer of mine is considering the following _Cloud Hybrid_ architecture:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/0/c004638159e4d3de1396f327ab487c4c01dbd9a0.png)  
In his solution an Ignition Gateway in a _private cloud_ will run some _Perspective_ views, where some production data will be shown to his customer. My problem is:

- _production data_ are in the database which is connected to the Ignition in the _Standard Site_ in the picture;
- between the _Standard Site_ and the _private cloud_ there is a _Gateway Network_

Given that: how can Ignition in the _private cloud_ get to the data? Is there any parameter that allow to share a database connection over a Gateway Network - something similar to the _Remote Tag Provider_. I was thinking of _messaging_ to pass _datasets_ as payload between the two gateways, but it is rather heavy, I think.

Thanks in advance, regards

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [November 22, 2023, 1:04pm UTC](https://forum.inductiveautomation.com/t/ignition-architecture-question/82240/2 "2023-11-22T13:04:00Z")

</div>

> [@pgmo](#):
>
> share a database connection over a Gateway Network

A remote tag provider, unless told otherwise, will forward historian queries to the source gateway over the GAN. For any other database operations, you will need to set up some other replication solution (database-specific, typically).

If you **do** set up DB replication, then your remote tag provider can be configured to divert historian queries to your cloud replica, which can help minimize your WAN traffic.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [November 22, 2023, 3:51pm UTC](https://forum.inductiveautomation.com/t/ignition-architecture-question/82240/3 "2023-11-22T15:51:03Z")

</div>

> [@pgmo](#):
>
> I was thinking of _messaging_ to pass _datasets_ as payload between the two gateways, but it is rather heavy, I think.

This is possible, but is not the most efficient, you're correct. We have considered implementing a first party DB query routing over the gateway network, but haven't decided exactly how it will work (and the security implications are a potential issue as well).

For now, messaging or DB replication as Phil mentioned are probably the way to go.

---

<div class="post-metadata">

**Author:** ![pgmo](https://avatars.discourse-cdn.com/v4/letter/p/d07c76/32.png) [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\
**Post date:** [November 22, 2023, 4:10pm UTC](https://forum.inductiveautomation.com/t/ignition-architecture-question/82240/4 "2023-11-22T16:10:25Z")

</div>

Thanks @paul-griffith

---

<div class="post-metadata">

**Author:** ![Hari\_GB](https://avatars.discourse-cdn.com/v4/letter/h/7ab992/32.png) [@Hari\_GB](https://forum.inductiveautomation.com/u/Hari_GB)\
**Post date:** [June 6, 2024, 4:56am UTC](https://forum.inductiveautomation.com/t/ignition-architecture-question/82240/5 "2024-06-06T04:56:31Z")

</div>

@paul-griffith , @pturmel, @pgmo. Similar case for me, Any best options for me ? I want to host perspective application in the ignition cloud and the application has to use DB hosted in the standard sites.
