How to connect to and read SQL Server within Confluence Cloud

[Deleted user]

We do not want to update Confluence pages manually; the goal is to keep our information in one place (i.e., a database) and have it update in Confluence automatically.

So we want Confluence pages to read information from SQL Server tables.

We're using Confluence cloud.

I have been unable to locate a simple step-by-step procedure (or add on) to do this.

Please help!

[Shannon S]

Hello Larry,

Welcome to Atlassian Community. It's nice to meet you!

In Confluence Cloud, it is not possible to access the database as a customer. The database is located on an internal Atlassian server, and only Atlassian staff has the ability to access your database for the purpose of troubleshooting technical issues.

What is possible is if you make calls via the REST API in order to make these changes.

Per Atlassian Cloud Vs Server:

You won't have direct access to change the database structure, file system, or other server infrastructure, but we provide extensive REST APIs so you can access data programmatically

What is also possible is if you use an add-on for this, such as Scriptrunner for Confluence or Confluence Command Line Interface (CLI). I'm not personally familiar with these add-ons myself, but they allow you to manage bits of Confluence behind a command line, rather than on the UI itself. This will have a bit of a learning curve, but once you understand how the CLI works then you can do many tasks that are not possible in the Confluence UI.

Finally, if you already have a SQL database somewhere with tables and you just want Confluence to display the data in these tables, have a look at a few of our SQL related add-ons.

Let me know if you have any questions about that!

Regards,

Shannon

[Deleted user]

Hi Shannon,

My question is on accessing our own databases, not Confluence's. The link to the related add-ons is therefore appropriate, thank you.

Unfortunately, although they do provide for connecting to non-Confluence databases, these add-ons do not have the desired functionality.

Could you possibly point me to Confluence documentation that would show us how to connect to other databases, execute queries, and receive results from those queries?

Thanks,
Larry

[Shannon S]

Hello Larry,

A 3rd-party add-on is required in order to connect directly to another database other than the one you are using to store your Confluence data.

The connection steps will be within the add-on itself, and not in Confluence.

For example, in the add-on called SQL Connector, there's a separate page where you can connect to your existing databases in order to retrieve data.

We have a feature request below to be able to connect to external databases in Cloud. It isn't very popular at the moment, but if it's something you'd like to see in Confluence Cloud, please vote on it:

• CONFCLOUD-59887  Integrate external database with Confluence Cloud

Let me know if you have any questions about this.

Regards,

Shannon

[kirandeep kaur]

Hi , If I may continue this thread

Is there a  mechanism to control on usage of these queries. i.e. once queries are added into pages, there is no track, who execute these queries. Because each viewer can run these queries on database and from audit point, its concern. Can this be controlled ?