Is it possible to have 2 separate databases used on the same page

I.E Sql Server and Postgres

Yes, it's possible. You need to add two data sources.