# Use two database on ignition perspective

**URL:** <https://forum.inductiveautomation.com/t/use-two-database-on-ignition-perspective/59391>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [May 10, 2022, 8:34am UTC](https://forum.inductiveautomation.com/t/use-two-database-on-ignition-perspective/59391 "2022-05-10T08:34:13Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![sebastien\_ng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sebastien_ng/32/55297_2.png) [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\
**Post date:** [May 10, 2022, 8:34am UTC](https://forum.inductiveautomation.com/t/use-two-database-on-ignition-perspective/59391/1 "2022-05-10T08:34:13Z")

</div>

Hello,

I want to know if it is possible to connecte two ,databases on ignition perspective?

1. Database for document management
2. Database to storage my other data.

if it is possible, how can I do it

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 10, 2022, 8:51am UTC](https://forum.inductiveautomation.com/t/use-two-database-on-ignition-perspective/59391/2 "2022-05-10T08:51:12Z")

</div>

On the gateway go to **Config** , **Databases** , **Connections** , **Create new Database Connection…**

---

<div class="post-metadata">

**Author:** ![sebastien\_ng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sebastien_ng/32/55297_2.png) [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\
**Post date:** [May 10, 2022, 8:58am UTC](https://forum.inductiveautomation.com/t/use-two-database-on-ignition-perspective/59391/3 "2022-05-10T08:58:13Z")

</div>

> [@Transistor](#):
>
> **Config** , **Databases** , **Connections** , **Create new Database Connection…**

thank you for your reply. I have already created both databases. And, would it be possible to make a query in both bases at the same time?

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [May 10, 2022, 9:02am UTC](https://forum.inductiveautomation.com/t/use-two-database-on-ignition-perspective/59391/4 "2022-05-10T09:02:24Z")

</div>

What do you mean by “at the same time” ? What’s your use case ?

---

<div class="post-metadata">

**Author:** ![sebastien\_ng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sebastien_ng/32/55297_2.png) [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\
**Post date:** [May 10, 2022, 9:23am UTC](https://forum.inductiveautomation.com/t/use-two-database-on-ignition-perspective/59391/5 "2022-05-10T09:23:05Z")

</div>

I meant for exemple if I want to do a SQL request (select data on two different database)

---

<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:** [May 10, 2022, 10:27am UTC](https://forum.inductiveautomation.com/t/use-two-database-on-ignition-perspective/59391/6 "2022-05-10T10:27:52Z")

</div>

No. Any given SQL goes to one connection. If you need to combine data from two sources, you will need to use two queries, then script the join (or whatever).