Is it possible to set up a relational database - one database using data from a completely separate database?

With the cloud version.

You can use the Rest API to do something  that.

or a shared view from one DB, to be consumed by another DB.