Multiple databases

[Matrix_Engineering]

Using more than one database connection in a project

Hi, I am working in a project where I need to consult data from more than one database (Postgres and MySQL). I am not using tags because I need to change the text of the queries dinamically, so I am writing the queries as text in some invisible labels, and making my charts execute those texts as SQL queries. I have several connections defined in the gateway configuration (and they really work). The problem is that in the “Projects” menu I can choose the default database for the project, but I c…

Restricting access to specific projects

Hi, I have a couple of different projects on our gateway. Is it possible to make the projects visible depending on the user who is logging in both on the gateway and in the designer? The motivation behind this is to have the client log in to our gateway and open their project from there in order to preview it and we can present it to them like that. I am obviously not interested in showing the client the other projects we are working on. Is such an restriction possible in Ignition? I have pl…