Reading external data sources with OpenOffice.org
The OpenOffice.org suite has positioned itself as a competitive alternative to proprietary products such as Microsoft Office and Corel's WordPerfect Office. One of OpenOffice.org's more advanced features is its ability to access external data sources from within its applications. Information repositories abound in both users' desktops and in a company's IT infrastructure. OpenOffice.org offers access to a whole gamut of data sources, ranging from standard OBDC/JDBC connection capabilities to localized access into text files, spreadsheets, and address books. The real highlight in being able to connect from OOo into a data source lies in its robust GUI for consulting and performing comprehensive searches. Users can make SQL-based queries or simple sort/filter searches and use the retrieved information within text documents or spreadsheets.