This is an experimental page to populate a Confluence table from a database. It uses Keysight's Database Connection Plugin for Confluence.
2018-07-23 Mon - Ralph A. Navarro Jr. installed Keysight's Database Connection Plugin on this Confluence server. The database connection is as follows:
- Install Plugin: Install Keysight's free Database Connection Plugin to our Confluence server.
- As an Administrator,
- Find the Database Connector plugin from Atlassian Marketplace
- Install the Database Connector plugin by clicking on "Install" button.
- Access PostgreSQL Database
- ssh s14
- docker exec -it confluencepostgres bash
- psql -U confluencedb
- Database: Create a database called 'tssg' within the same PostgreSQL server as the 'confluencedb' database that is used by this Confluence instance. Then connect to the database.
CREATE DATABASE tssg;
- \c tssg
- Table: Created a table called 'schedule' with the following description:
CREATE TABLE schedule(
ID INT PRIMARY KEY NOT NULL,
DATE DATE NOT NULL,
VENUE_NAME TEXT,
VENUE_LINK TEXT,
COMMENT TEXT
);
Populated table 'schedule' with the following information:
INSERT INTO schedule VALUES (
1,
'2018-07-25',
'Chelmsford Public Library',
'https://www.chelmsfordlibrary.org/',
'On 7/11, JimD agreed to take care of the equipment minus the microphone (Wayne).'
);
Create a Database Connection Profile
Add a Database Connection macro somewhere on a Confluence Page.
Manage and then Create the database connection values to the local database
Verify the connection by selecting "Test the Connection"
Query: Add a SQL query to the macro to get all records from the schedule table
SELECT * FROM schedule;
The following table is an embedded macro which displays data from the schedule database table.