In this section, we present how to connect Confluence to MindsDB.

Confluence is a popular collaboration and documentation tool developed by Atlassian, a software company known for its suite of productivity and project management software. Confluence is designed to help teams and organizations collaborate, share information, and create and manage various types of content.

Data from Confluence can be utilized within MindsDB to train AI models and make predictions.

Prerequisites

Before proceeding, ensure the following prerequisites are met:

  1. Install MindsDB locally via Docker or use MindsDB Cloud.
  2. To connect Confluence to MindsDB, install the required dependencies following this instruction.
  3. Install or ensure access to Confluence.

Connection

This handler is implemented using atlassian-python-api, a library that provides a simple and convenient way to interact with Atlassian products.

The required arguments to establish a connection are as follows:

  • url is a Confluence-hosted URL instance.
  • confluence_api_token is a token used to authenticate.

Please follow this link to generate the token for accessing the Confluence API.

In order to make use of this handler and connect the Confluence app to MindsDB, the following syntax can be used:

CREATE DATABASE mindsdb_confluence
WITH
    ENGINE = 'confluence',
    PARAMETERS = {
    "url": "your_confluence_url",
    "username": "your_username",
    "password":"access_token"
    };

It creates a database that comes with the pages table.

Usage

Now you can query your data, like this:

SELECT id, key, name, type
FROM mindsdb_confluence.pages
WHERE type = "personal"
ORDER BY id ASC, name DESC
LIMIT 10;

For more information about available actions and development plans, visit this page.