Sage Line 50 and LibreOffice Base

[Dogeron]

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.

QRY_Tax_Code_LibreOfficeBase_Query_Design.png

[brucedenney]

I seem to remember the Data Pilot didn't work, this is because Sage uses a delimiter in the ODBC driver that makes the SQL ambiguous.

What I found was that you could do the query, in MSQuery with Excel, then copy the SQL and it works fine.

I have not used LibreOffice for a long time so I can't comment on todays experience.

I hope this helps.