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:
CREATE DATABASE tssg;
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.