Use two database on ignition perspective

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

On the gateway go to 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?

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

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

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).

1 Like