Difference between revisions of "G11NWIKITEST/Documentation/BASIC Guide/Database"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Created page with '{{Documentation/BASICGuideTOC/v2 |ShowPrevNext=block |ShowPrevPage=block |PrevPage=Documentation/BASIC Guide/Chart Types |NextPage=Documentation/BASIC Guide/SQL |base=block }} {{…')
 
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
{{Documentation/BASICGuideTOC/v2
+
{{G11NWIKITEST/Documentation/BASICGuideTOC/v2
 
|ShowPrevNext=block
 
|ShowPrevNext=block
 
|ShowPrevPage=block
 
|ShowPrevPage=block
Line 17: Line 17:
  
  
{{Documentation/Note|In 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.}}
+
{{Note|In 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.}}
  
  
 
{{InterWiki Languages BasicGuide|articletitle=Documentation/BASIC Guide/Database}}
 
{{InterWiki Languages BasicGuide|articletitle=Documentation/BASIC Guide/Database}}
 
{{PDL1}}[[Category:G11n Wiki Translation Testing]]
 
{{PDL1}}[[Category:G11n Wiki Translation Testing]]

Latest revision as of 07:35, 7 July 2018


Apache OpenOffice 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 Apache OpenOffice 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 Apache OpenOffice Developer's Guide.


Documentation note.png In 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.


Content on this page is licensed under the Public Documentation License (PDL).
Personal tools