Databases

From OpenOffice.org Wiki

Jump to: navigation, search

This article needs to be checked for accuracy and style.

doc OOo
PAGE_TITLE: RGF0YWJhc2Vz

OpenOffice.org has an integrated database interface (independent of any systems) called Star Database Connectivity (SDBC). The objective of developing this interface was to provide access to as many different data sources as possible.

To make this possible, data sources are accessed by drivers. The sources from which the drivers take their data is irrelevant to a SDBC user. Some drivers access file-based databases and take the data directly from them. Others use standard interfaces such as JDBC or ODBC. There are, however, also special drivers which access the MAPI address book, LDAP directories or OpenOffice.org spreadsheets as data sources.

Since the drivers are based on UNO components, other drivers can be developed and therefore open up new data sources. You will find details about this in the OpenOffice.org Developer's Guide.

Image:documentation_note.pngIn terms of its concept, SDBC is comparable with the ADO and DAO libraries available in VBA. It permits high level access to databases, regardless of the underlying database backends.
Image:documentation_note.pngThe database interface of OpenOffice.org has grown through the launch of OpenOffice.org 2.x. Although in the past, databases were primarily accessed using a range of methods of the Application object, the interface in OpenOffice.org 2.x sub-divides into several objects. A DatabaseContext is used as the root object for the database functions.
Content on this page is licensed under the Public Documentation License (PDL).
Personal tools