nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Connect to Confluence via ODBC

john.duchock

I need to connect to our confluence database for a simple data extraction, however it seems that this is not possible without using a paid third-party middleware.

Is there an ODBC driver for Confluence that customers can download in order to connect to the Confluence database for reporting purposes such as Crystal Reports or MS Excel? The goal is to retrieve data one time for a single report...

Accepted answers

Former user

Hi @john.duchock,

what type of database is your Confluence running on? (e.g. MySQL, PostgreSQL, etc.) You should be able to connect directly to your database using a client for your DBMS.

Cheers,
Sven

All comments

Former user

Hi @john.duchock,

what type of database is your Confluence running on? (e.g. MySQL, PostgreSQL, etc.) You should be able to connect directly to your database using a client for your DBMS.

Cheers,
Sven

john.duchock

I am unable to find anyone in our company that can answer that question. Is there a .CFG file on the confluence server that can help me answer that question?

Former user

This article should help you find it: https://confluence.atlassian.com/confkb/how-to-find-confluence-s-database-connection-parameters-779172320.html

john.duchock

I was looking for a client side ODBC driver, but i guess this will have to do.

Any idea where i can get the jdbc driver JAR file?

john.duchock

Aye, the problem is now on our end. It seems that when Atlassian worked with us to do the install years ago, it was basically a "drop and run" and we have no documentation or internal resources that can shed light on how this was configured. As a result, i only have connection to the BKUP database and no one knows the DB schema well enough to find the data that i need...

I am finding it may be a better approach to hire a temp to copy/paste the data from the Confluence pages rather than to additional days trying to reverse engineer this installation...

I will be glad when Atlassian is out of our business environment as it is entirely unsupportable...and i expect to find the same result with Jira as well ....

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server