MySQL Connector for OpenOffice.org
The MySQL Connector for OpenOffice.org installs a native MySQL database driver. It is faster, seamless integrated, easier to administrate and there is no need to install and setup a JDBC or ODBC driver separately. It was never easier to use MySQL databases in OpenOffice.org Base. Create new database tables or use the powerful SQL query editor of OpenOffice.org to visually build MySQL database queries without learning SQL commands. Not to forget the database forms, that allow you to display and manipulate data.
You might also want to check out the Oracle Report Builder to create stylish, smart-looking database reports. The flexible report editor can define group and page headers as well as group and page footers and even calculation fields are available to accomplish complex database reports.
Please note that this extension requires an OpenOffice.org 3.1/StarOffice 9.1/StarSuite 9.1 or newer and a MySQL Server 5.1 or newer.
Version for OpenOffice 4.0: see here.
More details about advantages and how to use it can be found on the OpenOffice.org Wiki website.
The source code for this extension was transferred to the Apache OpenOffice project in 2011. If you are interested in volunteering to develop this extension, please contact the Apache OpenOffice mailing list: ooo-dev at incubator.apache.org
This extensions has known bugs with Apache OpenOffice 3.4 (Mac and Linux 64 bit versions only); use ODBC or JDBC connectors to MySQL databases in these cases.