Access live WooCommerce data in LibreOffice via JDBC
Connecting LibreOffice to a CData JDBC connector is a relatively smooth process that can be done in just a few steps. In this walkthrough I will be using the WooCommerce JDBC connector. First, launch LibreOffice and in the top left, navigate from Tools -> Options -> LibreOffice -> Advanced, and ensure Libre has access to your 64 bit java run time environment installed on your machine. Click “Add” in the top right, and navigate to JRE’s installed directory, which defaults to C:\Program Files\Java\jre<jre version here> Next, we must let Libre know where the CData JDBC driver is by adding a Class Path on that same advanced settings page. Click “Add Archive…” and navigate to the driver’s jar file. The driver installer defaults to something like C:\Program Files\CData\CData JDBC Driver for WooCommerce 2025\lib\cdata.jdbc.woocommerce.jar Click “Ok” on the Class Path window, apply the Advanced Settings changes we made and then click “Ok” again. The next step is defi