Working With Multiple Databases

Since a SQL Query can include both the database and schema, as long as GlobalForms is configured with a user that has permissions to each database, multiple databases can be specified for various routes.  Note that the first route below is using the "default" database supplied in the connection setup.  The second route specifies the database in the connection string.  Given the user has permissions, both routes will work without issue at the same time.

Open

In this case, the Schema is left blank, but depending on the use case, it may be required.