Operations and Performance
Base can connect to a variety of existing databases, including the following:
Microsoft Access,MySQL, Oracle JDBC,Adabas D, Spreadsheet, dBase, Text,JDBC, ODBC,ADO, Mozilla Address Book, Thunderbird Address Book, LDAP Address Book, Microsoft Outlook Address Book, Microsoft Windows Address Book, andMicrosoft Access 2007.
Spreadsheet, Text, and Address book data is read only access to Base. Base has good integration with the other applications in OpenOffice. For example, you can call a Base .odb file as the source for a mail merge (e-mail or postal address) using Writer, the OpenOffice Word Processing application. It makes good use of XML also.
The interface is very basic with buttons for Tables, Queries, Forms and Reports in a pane on the left. I would like to see a little more in the initial ‘dashboard’ presentation in Base. One area where Base is superior to Microsoft Access is its platform independence. Base, as part of OpenOffice, can be installed on Linux, Mac OS and Windows operating systems. If installed on Linux, however, Base cannot work with Access database files. Base makes good use of Wizards for creating components in all aspects of the program from Tables, Table Views, Queries, Forms, and Reports. Base enjoys solid supporting documentation from OpenOffice and a passionate peer community. Working through the creation of a Contacts database, I did not come across any pain points or areas where I could not figure out how to accomplish something that I am familiar with in Access. Finally, when opening a file using the File | Open command, the drop down list for file types is very granular with a long list of extensions to specifically search for.