badpm.blogg.se

This section discusses how the Apache OpenOffice API handles various SQL dialects and how it integrates with data sources that do not understand SQL.Īpache OpenOffice API has a built-in parser that tests and adjusts the syntax to be standard SQL. The Apache OpenOffice API database integration is based on SQL. Since SDBC drivers are UNO components, it is possible to write drivers for data sources and thus extend the database connectivity of Apache OpenOffice API.įunctioning of the Apache OpenOffice API Database Integration The concept makes it possible to integrate database connectivity for MAPI address books, LDAP directories and Apache OpenOffice Calc into the current version of Apache OpenOffice API. Some drivers handle files themselves, others use a standard driver model, or existing drivers to retrieve data.

Each SDBC driver knows how to get data from a particular source. The Apache OpenOffice API database integration reaches this goal through an abstraction above the abstractions with the Star Database Connectivity (SDBC). While it is necessary to access database abstraction layers, such as JDBC and ODBC, it is also desirable to have direct access to arbitrary data sources, if required. The goal of the Apache OpenOffice API database integration is to provide platform independent database connectivity for Apache OpenOffice API.