How to connect Confluence to external database to read from the database?

[Karen Cheung]

Is there a way/plugin to connect to an external database (SQL Server) with company data?

I would like to connect with and read from the database.

[Alex Yasurek]

Hi,

There are plugins that can do that on the marketplace. Here is a popular one:

 https://marketplace.atlassian.com/plugins/org.swift.confluence.sql/server/overview 

[Karen Cheung]

Thanks Alex, I also found this one:

https://marketplace.atlassian.com/plugins/de.scandio.confluence.plugins.pocketquery/server/overview

I'll look into both!

[Jonas Andersson]

Just adding a data source can be done in the server.xml if you don't want to pay a license for it, and are prepared to restart the server when adding or removing data sources.

<Resource name="jdbc/DATASOURCE_NAME_GOES_HERE"
    auth="Container"
    type="javax.sql.DataSource"
    driverClassName="com.mysql.jdbc.Driver"
    url="jdbc:mysql://DB_SERVER_NAME_HERE:3306/DB_NAME_HERE?autoReconnect=true"
    username="USERNAME_HERE"
    password="PASSWORD_HERE"
    maxActive="25"
    maxIdle="5"
    maxWait="10000"
/>