Linking or querying between multiple databases - is this possible?

Question

So I'm completely new to Conflience and databases, but as a DB Developer I'm well aware of the power of using Databases to store info.  With this, if someone wants to build say a process database with multiple layers - tracking Process, System, Schedule, Impacted systems, Departments affected by process, Users overseeing process, etc where each could be its own database - is there some way to create distinct databases and link these then query across them all?

Or are these "Databases" more akin to an Excel spreadsheet or SharePoint list with just a single collection of data?

Thanks for the insight and education on this.

Marc -Devoteam- · Answer

Hi @Sam Alexander

You can't compare a Confluence DB with a DB like SQL, Postgres, Oracle, etc...

Is a simplified option to store information to be used in other Confluence pages, as a source.

"Or are these "Databases" more akin to an Excel spreadsheet or SharePoint list with just a single collection of data? "

YES to the above

Steffen Burzlaff _K15t_ · Answer

Hey @Sam Alexander

you can link between databases by using a specific field type. You're able to link to entries of another database, a detail of another database entry and/or a link to that database.

You can read the docs here: https://support.atlassian.com/confluence-cloud/docs/database-fields/

Let's assume you have a database like this:

NameFirst name  AgeTeam  JohnDoe 32 ACME

The field type of "team" could be a entry link to the database "team" where "ACME" is a entry.

I hope this helps and gives you an idea what's possible.

If you have more question, happy to answer them.

Cheers,
Steffen

marc -Collabello--Phase Locked- · Answer

Confluence databases are more like a simple table than a real database.  You can manually add/remove information.  There is no API access, and very limited linking to other things.