More than one Database

[David Soldan]

Hey everyone,

i wanted to ask if it is in general possible to connect more than one database to confluence besides the existing one with wich confluence is connected .

Im asking because i got the problem that there is information on different access-databases in different departments of my firm. I have to display the tables in the wiki .

Can anyone help me ?

greetings

[Nic Brough -Adaptavist- · Accepted solution]

At a very basic level, yes. Just add the database connections to the Tomcat (or other application server), and you'll be able to access the databases.

There is nothing built into Confluence that actually uses them, so you'll need some code that actually uses them.

[David Soldan]

And then when the Databases are connected how i can include staff from the databases to confluence pages??? With the sql plugin/macros??

Am i one the right way if i follow http://confluence.atlassian.com/display/DOC/Configuring+a+MySQL+Datasource+in+Apache+Tomcat and this https://studio.plugins.atlassian.com/wiki/display/SQL/SQL+plugin+datasource+configuration ??

[Nic Brough -Adaptavist-]

Yes. the instructions are in the docs for the database plugin as you've already found.