Please help improve this article by expanding it. Further information might be found on the talk page. (July 2008)

OpenOffice.org Base

OpenOffice.org Base 3
Developer(s)	Sun Microsystems
Stable release	3.1.1 / 2009-08-31; 4 months ago
Operating system	Cross-platform
Platform	Java
Development status	Active
Type	Database
License	GNU Lesser General Public License
Website	www.openoffice.org

OpenOffice.org Base is the database module initially released with OpenOffice.org version 2.0. Currently it is based on the HSQLDB database engine written in Java. Note that another database engine, SQLite, had been considered^{[citation needed]} but the OpenOffice.org team decided to go with HSQLDB after evaluating the features, connectivity and embed quality of both database engines.

The HSQLDB developers have suggested only 76% of the target has been met in the 1.8.0 release^[1], which is the version that was integrated with OOo 2.0. They have been appealing for contributions^[2] to fulfill all the feature targets, since the core database engine itself is an independent project with no external funding.

OpenOffice.org users, however, can choose to connect to external full-featured SQL database such as MySQL, PostgreSQL and even Oracle through ODBC or JDBC drivers. OpenOffice.org Base can hence act as a GUI frontend for SQL views, table design and query. In addition, OpenOffice.org has its own Form wizard to create dialog windows for form filling and updates.

Starting with version 2.3, Base offers report generation based on Pentaho software.^[3]

Released under the terms of the GNU Lesser General Public Licence, Base is free software.

Contents 1 The product specifications 2 Documentation 3 See also 4 Notes and references 5 External links 5.1 General articles and resources 5.2 Database connection articles

[edit] The product specifications

This section requires expansion.

[edit] Documentation

This section requires expansion.

[edit] See also

• HSQLDB
• Kexi - a similar free software/open source application
• Comparison of office suites

[edit] Notes and references

[edit] External links

This article's external links may not follow Wikipedia's content policies or guidelines. Please improve this article by removing excessive or inappropriate external links. (December 2009)

Wikibooks has a book on the topic of OpenOffice.org/Base

Wikimedia Commons has media related to: OpenOffice.org Base

• Base information page
  • OpenOffice.org Base 2.0 project discussion
  • OpenOffice.org Database Access Project
• HSQL and OpenOffice.org
• User resources at OOo Wiki
• Tutorials for new and intermediate ooBase users, from Sheepdog Guides

[edit] General articles and resources

• OpenOffice.org database application: A first look review
• OpenOffice.org Base by Kevin Shockey, from TuxMagazine issue 10, p.41-46 (free PDF download after registration, lesson on creating new table and form in Base)
• OpenOffice.org Writer Does More Than Just Word Processing by Kevin Shockey, from TuxMagazine issue 11, p.23-29 (lesson on Mail Merge that combines Base with Writer to provide new powerful functionality)
• OpenOffice.org Base forum, with links to several tutorials and guides
• Andrew Pitonyak's documents on using Macros with OOo Base
• OpenOffice.org Base 2.0 (a book published in German)
• Tutorials on using ooBase from Sheepdog Guides

• SearchOpenSource articles on OOoBase
  • Using Functions in Base Queries
  • Importing Data Into Base
  • Exporting Data From Base
  • Base and Mail Merges
• OpenOffice.org Blog

[edit] Database connection articles

• Getting Started with Base: Introduction to Data Sources (pdf)
• Also from Database Access Project:
  External Resources, Specific problems, and Database Drivers for connecting to third-party database
• Other articles
  • Plug OpenOffice.org into PostgreSQL (via postgresql-sdbc-driver)
  • Using SQLite Database with OpenOffice.org (via sqliteodbc or sqlite-sdbc-driver)
• StarOffice 7 Setting Up Database Connections Guide - a little dated for OOo 2.0, provided here for reference

v • d • e OpenOffice.org Writer · Calc · Impress · Base · Draw · Math