Difference between revisions of "Documentation/Database"

From Apache OpenOffice Wiki
Jump to: navigation, search
(FAQ)
(User Documentation: identified dead link)
(7 intermediate revisions by 4 users not shown)
Line 1: Line 1:
{{Documentation/Lang|Database}}
+
{{Database/Lang|Documentation/Database}}
On this page you find links to Base documentation ordered by languages and topics. It may be helpful for authors and translators.
+
'''OpenOffice.org Base''' is the database application of [[OpenOffice.org]], similar to [[MSA-Base_Faq|Microsoft Access]].  Base allows the creation and manipulation of databases and the building of forms and reports to provide easy access to data for end-users.  As with Access, Base is able to work as a front-end to a variety of database systems, including Access databases (JET), [[ODBC]] data sources, [[wikipedia:MySQL|MySQL]], and [[wikipedia:PostgreSQL|PostgreSQL]].
  
This page is considered to be "Work in Progress". Please add documents you are missing to this list.
+
Base was not available in the 1.x versions of OpenOffice.org, becoming part of the suite starting with version 2.0.  Base enables you to manipulate database data seamlessly within OpenOffice.org. Create and modify tables, forms, queries, and reports, either using your own database or Base’s own built-in [[wikipedia:HSQLDB|HSQLDB]] database engine. Base offers a choice of using Wizards, Design Views, or SQL Views for beginners, intermediate, and advanced users.
  
Resources related to OpenOffice.org Base:
+
==Features==
 +
With Base, you can:
  
= English =
+
* Create new tables for your data - and also change them as your needs change
== Manuals ==
+
* Maintain indexes on the tables to make data access faster
=== General ===
+
* View a table in an editing grid and add, change, and delete records
* Base
+
* Use the Report Wizard to produce impressive reports from your data
: [http://wiki.services.openoffice.org/wiki/Base Base]
+
* Use the Form Wizard to create 'instant' database applications
: Description of Base (short overview)
+
  
* OpenOffice.org User Guides (Getting started with Base) - ''PDF''
+
Using Base, you can not only browse your data, but also:
: [http://documentation.openoffice.org/manuals/oooauthors2/0110GS-GettingStartedWithBase.pdf  GettingStartedWithBase]
+
: ''description follows''
+
  
* OpenOffice.org Base Manual
+
* Perform simple (single column) or complex (multi-column) sorts
: [http://nothickmanuals.info/doku.php/articles:ooobaseprimer OpenOffice.org Base primer]
+
* View subsets of your data with simple (one-click) or complex (logical query) filters
: ''description follows''
+
* Create powerful queries to show your data in new ways, including summaries and multi-table views
 +
* Produce reports
 +
** The Base module includes the Report Wizard for creating quick tabular reprts
 +
** With Version 2.3 the [[SUN Report Builder]] is available as an extension for more complex reporting needs
 +
* Base allows you to extend it's functionality via built in scripting capabilities
  
* OpenOffice.org Base Manual (Andrew Pitonyak and Drew Jensen)
+
BASE includes a full version of the [http://hsqldb.org/ HSQL] database engine. It can also access [[dBASE]] files natively for simple database work, but it cannot open MS-Access files natively.
: [http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Base_Guide/Planning Base Guide Planning]
+
: ''description follows''
+
  
*Base videos from chapter 7 of the user guide
+
For more advanced requirements, Base supports many popular databases database natively (Adabas D, ADO, Microsoft Access, MySQL), or any database through industry-standard [[ODBC]] and [[JDBC]] drivers. It also supports any [[LDAP]] compliant address book, as well as common formats such as Microsoft Outlook, Microsoft Windows, and [[Mozilla]].
: [http://wiki.services.openoffice.org/wiki/Documentation/Tutorials Tutorial]  
+
: ''description follows''
+
  
* Beginners - Example Database - Base Tutorial
+
==Resources==
: [http://www.oooforum.org/forum/viewtopic.phtml?t=25060 Example]
+
===User Documentation===
: Initial author: Andrew 'Drew' Jensen
+
* [[Documentation/OOoAuthors User Manual/Getting Started/Getting Started with Base|Getting Started with Base]] on the wiki.
:This tutorial covers creating a first database using OOoBase. It is intended for those that have not used Base before or those that have never used any database manager.  
+
:: http://documentation.openoffice.org/manuals/oooauthors2/0110GS-GettingStartedWithBase.pdf '''''(link 404s)''''' Getting started with Base as single PDF file.
 +
:: [http://documentation.openoffice.org/manuals/OOo2.x/user_guide2_draft.pdf OOo2 User Guide] as single PDF file.
 +
* [http://www.pitonyak.org/database/ Andrew Pitonyak's Base documents]
 +
* [http://sheepdogguides.com/fdb/fdb1main.htm Tutorials on using ooBase] from Sheepdog Guides
 +
* [[/connectivity|Connecting]] with non-embedded databases
 +
* [[/Reports|Working with reports]]
  
* Mid Level OpenOffice.org Base tutorial
+
====Wiki Articles and more====
: [http://wiki.services.openoffice.org/wiki/Documentation/Dashboard/Tutorials/Base_%28Mariano%29 Tutorials]  
+
* The embedded data engine HSQLdb
: ''description followes''
+
** [[HSQLDB:Tips and Tricks]]
 +
** [[HSQLDB Localization]]
 +
** [[HSQL Text Table Integration]]
 +
* [[SUN Report Builder]]
 +
** DesktopLinux.com article April 2007[[http://www.desktoplinux.com/news/NS5712122864.html Chris Preimesberger]]
 +
* [[Built-in functions and Stored Procedures|Base Query functions]]
 +
* [[MSA-Base Faq|Working with MS Access files]]
 +
* [[Standard Distributed Schema]]
 +
* [[Bibliographic Database]]
 +
* [[A club membership database]]
 +
* DerbyToursDB [[User:HCPotter]]
  
* [http://www.pitonyak.org/database/ Pitonyak's document]
+
===Technical Documentation===
 +
* [http://dba.openoffice.org/specifications/index.html Specification Documents]
 +
** [http://dba.openoffice.org/specifications/ReportDesigner.odt Sun Report Builder (SRB)]
 +
** [http://dba.openoffice.org/specifications/Conditional%20Formatting.odt Conditional formatting dialog in SRB]
 +
* [[Base New Driver Tutorial]]
 +
*[[Logging JDBC Activity|Logging JDBC Activity]] new feature 2.?
  
*  Database: "ooBase", aka "Base"
+
== Official sites ==
: [http://sheepdogguides.com/fdb/fdb1main.htm sheepdogguides]
+
  
* Simpler Exporting Data From OpenOffice Base to a Spreadsheet
+
* [http://dba.openoffice.org/ Base project page]
: [http://openoffice.blogs.com/openoffice/2007/04/farrrrrr_simple.openoffice.blogs.com]
+
* [http://www.openoffice.org/product/base.html Base marketing page]
 +
* [http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html Base QA]
  
* Bringing data into OpenOffice 2.0's database
+
* '''the mailto and owner would need to be changed appropriately'''
: [http://searchenterpriselinux.techtarget.com/tip/0,289483,sid39_gci1222186,00.html Database]
+
: ''Maintainer: [mailto:atjensen@openoffice.org?subject:OOoWiki Base page] [[User:DrewJensen|Drew]] 21:01, 11 September 2007 (CEST) ''
 
+
: This page is under [http://creativecommons.org/licenses/by-sa/3.0/legalcode CC by-sa] since 2009-02-02
=== Tables ===
+
: ''Please do not change the logical content of this site without acknowledge of the author or the [http://wiki.services.openoffice.org/wiki/Project_Lead OOo QA Project Lead/Co-Leads].''
 
+
<div id="Template_CC-BY-SA">
* [http://wiki.services.openoffice.org/wiki/Standard_Distributed_Schema Standard Distributed Schema]
+
{|align="left" width="100%" border="0" cellspacing="4" cellpadding="0" style="border-top: 1px solid #666; font-size: xx-small; margin-top: 20px; text-align: right;"
 
+
| Content on this page is licensed under the [http://creativecommons.org/licenses/by-sa/3.0/legalcode Creative Common Attribution 3.0 license (CC BY-SA)].
=== Reports ===
+
|}
* Sun Report Builder
+
</div>
: [http://wiki.services.openoffice.org/wiki/SUN_Report_Builder SUN_Report_Builder]
+
: ''description followed''
+
 
+
* Sun Report Builder (Reference)
+
: [http://wiki.pentaho.org/display/Reporting/Pentaho+Reporting+Latest Reference]
+
: ''description follow''''
+
 
+
* Functions in Reports
+
: [http://wiki.pentaho.org/display/Reporting/08.+Functions+and+Expressions Functions and Expressions]
+
: ''description follow
+
 
+
=== Developer ===
+
* Working basis to make the user guide better
+
: [http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Getting_Started/Getting_Started_with_Base Getting_Started/Getting_Started_with_Base]
+
: ''description followed''
+
 
+
=== FAQ ===
+
* FAQ
+
: [http://wiki.services.openoffice.org/wiki/FAQ_%28Base%29 FAQ Base]
+
:
+
 
+
* Common tasks
+
: [http://wiki.services.openoffice.org/wiki/Common_tasks Common_tasks]
+
: Initial author: Andrew 'Drew' Jensen
+
: Many good questions, no answers.
+
 
+
=== Misc ===
+
* HSQLDB Tips and Tricks
+
: [http://wiki.services.openoffice.org/wiki/HSQLDB:Tips_and_Tricks Tips_and_Tricks]
+
: ''description followed''
+
 
+
* [http://nothickmanuals.info/doku.php/articles:ooobaseprimer http://nothickmanuals.info/doku.php/articles:ooobaseprimer]
+
 
+
* [http://www.baseusers.com/index.html http://www.baseusers.com/index.html]
+
 
+
== Connecting ==
+
* Base New Driver Tutorial
+
 
+
[http://wiki.services.openoffice.org/wiki/Base_New_Driver_Tutorial http://wiki.services.openoffice.org/wiki/Base_New_Driver_Tutorial]
+
 
+
Initial author: Robert Vojta
+
 
+
This small How-To contains a simple step-by-step introduction on how to put your driver inside the connectivity module. The second part of this document covers differences between a driver in connectivity module and a driver in an UNO package.
+
 
+
* Better Database Drivers
+
 
+
[http://wiki.services.openoffice.org/wiki/BetterDatabaseDrivers http://wiki.services.openoffice.org/wiki/BetterDatabaseDrivers]
+
 
+
Initial author:Eric Bischoff
+
 
+
Some ideas for a better and simpler infrastructure for database drivers
+
 
+
* Connecting to Microsoft Access
+
 
+
[http://wiki.services.openoffice.org/wiki/Connecting_to_Microsoft_Access http://wiki.services.openoffice.org/wiki/Connecting_to_Microsoft_Access]
+
 
+
Initial author: Regina Henschel
+
 
+
These article describes how to connect to a Microsoft Access database file, if you use a MS Windows operating system.
+
 
+
* OpenOffice.org Base - Database Drivers
+
 
+
[http://dba.openoffice.org/drivers/ http://dba.openoffice.org/drivers/]  
+
 
+
* Connecting with MySQL
+
 
+
[http://wiki.services.openoffice.org/wiki/Connect_MySQLandBase http://wiki.services.openoffice.org/wiki/Connect_MySQLandBase]
+
 
+
An overview page
+
 
+
* Native PostgreSQL Driver
+
 
+
[http://dba.openoffice.org/drivers/postgresql/index.html http://dba.openoffice.org/drivers/postgresql/index.html]
+
 
+
* SQL-lite Driver
+
 
+
http://dba.openoffice.org/drivers/sqlite/index.html
+
 
+
* mdb-sdbc-driver-0.1.0
+
 
+
[http://dba.openoffice.org/drivers/mdb/index.html http://dba.openoffice.org/drivers/mdb/index.html]
+
 
+
Initial author: Wind Li (yl146652 [at] openoffice [dot] org)
+
 
+
It is a try to connect a Linux system to MS Access. There is no further development.
+
 
+
* A working page
+
 
+
[http://wiki.services.openoffice.org/wiki/MDB_Driver_Integration http://wiki.services.openoffice.org/wiki/MDB_Driver_Integration]
+
 
+
* MSA-Base Faq
+
 
+
[http://wiki.services.openoffice.org/wiki/MSA-Base_Faq http://wiki.services.openoffice.org/wiki/MSA-Base_Faq]
+
 
+
* Firebird driver update for OO.org
+
[http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:oobase Jaybird OpenOffice.org Base support]
+
 
+
== Examples ==
+
=== General ===
+
* Base Example (Overview)
+
 
+
[http://wiki.services.openoffice.org/wiki/Category:Base_Example http://wiki.services.openoffice.org/wiki/Category:Base_Example]
+
 
+
Initial author: Frank Schönheit
+
 
+
* Standard Distributed Schema
+
 
+
[http://wiki.services.openoffice.org/wiki/Standard_Distributed_Schema http://wiki.services.openoffice.org/wiki/Standard_Distributed_Schema]
+
 
+
=== Concrete Examples ===
+
* A club membership database
+
 
+
[http://wiki.services.openoffice.org/wiki/A_club_membership_database http://wiki.services.openoffice.org/wiki/A_club_membership_database]
+
 
+
Initial author: Andrew 'Drew' Jensen
+
 
+
Description of creating an example database
+
 
+
* OpenOffice.org API - Code snippets: [http://codesnippets.services.openoffice.org/Database/index.xml http://codesnippets.services.openoffice.org/Database/index.xml] <br/> Useful code snippets solving frequently asked questions.
+
 
+
* Base Example
+
 
+
http://wiki.services.openoffice.org/wiki/Help_Files
+
 
+
http://wiki.services.openoffice.org/wiki/Standard_Distributed_Schema
+
 
+
== Misc ==
+
== Testing ==
+
* [http://wiki.services.openoffice.org/wiki/Database_Automatic_Testing http://wiki.services.openoffice.org/wiki/Database_Automatic_Testing]
+
* [http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Base_Guide/Planning http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Base_Guide/Planning]
+
* [http://wiki.services.openoffice.org/wiki/FAQ_%28Base%29 http://wiki.services.openoffice.org/wiki/FAQ_%28Base%29]
+
 
+
 
+
* [http://wiki.services.openoffice.org/wiki/OOoHelpOutline#Base_and_Database http://wiki.services.openoffice.org/wiki/OOoHelpOutline#Base_and_Database]
+
 
+
*
+
* [http://ericzander.com/Publications/OO_MySQL_Tutorial/index.htm http://ericzander.com/Publications/OO_MySQL_Tutorial/index.htm]
+
Connecting OpenOffice.org To A Remote MySQL Database] (event. 1.x)
+
 
+
= French =
+
= German =
+
http://wiki.services.openoffice.org/wiki/DE:Beispielsdatenbank_mit_Base
+
 
+
http://dannenhoefer.de/faqstarbasic/Datenbanken.html
+
 
+
http://de.openoffice.org/doc/howto_2_0/index.html#datenquellen_2_0
+
 
+
http://wiki.services.openoffice.org/wiki/DE:FAQ/Base
+
 
+
End user documentation
+
* http://www.ooowiki.de/KategorieBase
+
 
+
 
+
= Portugese =
+
 
+
http://broffice.org/files/Introdu%C3%A7%C3%A3o_ao%20BrOffice.org_Base_2.0.x.odt
+
 
+
=Copyright=
+
 
+
[http://dba.openoffice.org/ OOo Database Development]<br>
+
[http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html OOo Database QA]<br>
+
[http://wiki.services.openoffice.org/wiki/Category:Database OOo General Database Info]<br>
+
<br>
+
<br>
+
''Initial author : [mailto:mechtilde@mechtilde@openoffice.org?subject:OOoWiki Mechtilde Stehmann]  24 September 2007''<br>
+
''Please do not change the logical content of this site without acknowledge of the author or the [http://wiki.services.openoffice.org/wiki/Project_Lead OOo QA Project Lead/Co-Leads].''
+
  
 +
[[Category:Database]]
 +
[[Category:Base Documentation]]
 
[[Category:Quality Assurance]]
 
[[Category:Quality Assurance]]
[[Category:Database]]
 

Revision as of 15:38, 17 January 2013

There are documents also in DE - FR - ES -PT

OpenOffice.org Base is the database application of OpenOffice.org, similar to Microsoft Access. Base allows the creation and manipulation of databases and the building of forms and reports to provide easy access to data for end-users. As with Access, Base is able to work as a front-end to a variety of database systems, including Access databases (JET), ODBC data sources, MySQL, and PostgreSQL.

Base was not available in the 1.x versions of OpenOffice.org, becoming part of the suite starting with version 2.0. Base enables you to manipulate database data seamlessly within OpenOffice.org. Create and modify tables, forms, queries, and reports, either using your own database or Base’s own built-in HSQLDB database engine. Base offers a choice of using Wizards, Design Views, or SQL Views for beginners, intermediate, and advanced users.

Features

With Base, you can:

  • Create new tables for your data - and also change them as your needs change
  • Maintain indexes on the tables to make data access faster
  • View a table in an editing grid and add, change, and delete records
  • Use the Report Wizard to produce impressive reports from your data
  • Use the Form Wizard to create 'instant' database applications

Using Base, you can not only browse your data, but also:

  • Perform simple (single column) or complex (multi-column) sorts
  • View subsets of your data with simple (one-click) or complex (logical query) filters
  • Create powerful queries to show your data in new ways, including summaries and multi-table views
  • Produce reports
    • The Base module includes the Report Wizard for creating quick tabular reprts
    • With Version 2.3 the SUN Report Builder is available as an extension for more complex reporting needs
  • Base allows you to extend it's functionality via built in scripting capabilities

BASE includes a full version of the HSQL database engine. It can also access dBASE files natively for simple database work, but it cannot open MS-Access files natively.

For more advanced requirements, Base supports many popular databases database natively (Adabas D, ADO, Microsoft Access, MySQL), or any database through industry-standard ODBC and JDBC drivers. It also supports any LDAP compliant address book, as well as common formats such as Microsoft Outlook, Microsoft Windows, and Mozilla.

Resources

User Documentation

http://documentation.openoffice.org/manuals/oooauthors2/0110GS-GettingStartedWithBase.pdf (link 404s) Getting started with Base as single PDF file.
OOo2 User Guide as single PDF file.

Wiki Articles and more

Technical Documentation

Official sites

  • the mailto and owner would need to be changed appropriately
Maintainer: Base page Drew 21:01, 11 September 2007 (CEST)
This page is under CC by-sa since 2009-02-02
Please do not change the logical content of this site without acknowledge of the author or the OOo QA Project Lead/Co-Leads.
Content on this page is licensed under the Creative Common Attribution 3.0 license (CC BY-SA).
Personal tools