Sage Line 50 and LibreOffice Base
Posted: 24 Nov 2023, 13:21
Looking through the threads I saw some questions and doubt about using LibreOffice Base to connect to Sage.
I tend to use LibreOffice to query Sage when a problem arises with the data transferred into my MariaDB instance via PowerShell script.
So yes it can be done using the Sage ODBC drivers.
Assuming you you have the connection to Sage, the tables are listed under the Tables menu but I've never been able to open them directly.
Instead go to the Queries menu and click 'Create Query in SQL View' you can then type SQL select statement against a table name you saw listed in the Table menu.
For example : select * from tax_code
IMPORTANT - before you hit the run SQL Query button ensure that the 'Run SQL command directly' button is clicked - see the image below which also shows the retrieved data.
I tend to use LibreOffice to query Sage when a problem arises with the data transferred into my MariaDB instance via PowerShell script.
So yes it can be done using the Sage ODBC drivers.
Assuming you you have the connection to Sage, the tables are listed under the Tables menu but I've never been able to open them directly.
Instead go to the Queries menu and click 'Create Query in SQL View' you can then type SQL select statement against a table name you saw listed in the Table menu.
For example : select * from tax_code
IMPORTANT - before you hit the run SQL Query button ensure that the 'Run SQL command directly' button is clicked - see the image below which also shows the retrieved data.