How to access a Microsoft Access database via Confluence?

David A1

We have created some databases within our Confluence 3.5 instance for internal project management. I am not sure how they work but they make extensive use of plugins and macros.  Upgrading these pages to Confluence 5 is quite a headache.

The ability to create databases within Confluence seems powerful but I am wondering whether it would be better for us to use a tool designed explicitly for the purpose, such as Microsoft Access.  However, to publish Access databases on our intranet requires SharePoint, which is expensive and seemingly inappropriate since we use Confluence for collaboration.

Is it possible for Confluence to publish a Microsoft Access database?  (i.e. to mimic SharePoint's Access services?)

Any suggestions would be appreciated.

Adrien Ragot 2

Hi David,

I think Access databases can be accessed via JDBC (SQL). You can use any SQL client for Confluence but they will be read-only: Bob Swift's SQL macro (paid), PocketQuery (free). I'm excluding the last SQL client, Play SQL Base, because it specifically targets Postgres and not Access.

I am also the author of Play SQL Spreadsheets, which can read and write in a database. It intends to offer the same service as Access in Confluence: People can create tables and forms to manage their data, and they're backed by a real database. It requires PostgreSQL, though.

Best regards,

Adrien Ragot