Configure LibreOffice to use Jdk 17
Click on tools
Options, then in the Options - LibreOffice - User Data dialog, click on
Advanced in the tree.
Use a Java runtime environment must be checked, and verify a JRE version 17 is detected.
If not, install Java 17 and repeat the process. You can click on
Add button and follow the procedure if it is not detected, but you know it is installed.
Add the Jar Driver
Go back to the advanced dialog.
Class Path…, in the Dialog, click on
Add Archive…, select the file you downloaded.
Create a LibreOffice Base File
Open LibreOffice, Click on
Enter Driver Location in Jar
Replace localhost and port by your instance URL and port.
JDBC driver class:
User name must be an active user of your Intranet application (with
Finish button, set a file name
Usage In Base
Open the file saved on previous step, enter your password when prompted.
Click on Queries button, then on
Create Query in SQL View
|Do not use wizard. The Intranet use TQL Language for querying data, LibreOffice does not know about this language.|
Before being able to type queries, click on
Run SQL Command directly
Now, you can type your TQL queries…
See TQL Queries.
Usage In Calc
Once you create some queries, and saved them, you can access data directly from Calc.
Open Query as a pivot table
Pivot Table then
Data source in registered Calc
Select the file you save your Queries, enter your Intranet password, then you have to select the Datasource.
Here I choose Query, and select Users query.
That’s it. You can edit your pivot table according to your needs.
As a datasource