With the parser, differences between SQL dialects, such as case sensitivity, can be handled if the query composer is used. LibreOffice API has a built-in parser that tests and adjusts the syntax to be standard SQL. This section discusses how the LibreOffice API handles various SQL dialects and how it integrates with data sources that do not understand SQL. The LibreOffice 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 LibreOffice API.įunctioning of the LibreOffice API Database Integration The concept makes it possible to integrate database connectivity for MAPI address books, LDAP directories and LibreOffice Calc into the current version of LibreOffice 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 LibreOffice 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 LibreOffice API database integration is to provide platform independent database connectivity for LibreOffice API.

Libreoffice database examples