Difference between revisions of "Documentation/Database"

From Apache OpenOffice Wiki
Jump to: navigation, search
Line 1: Line 1:
 +
On this side you find links to documents of Base ordered by languages and topics. This side may be helpful for authors and translators.
 +
 +
This page can only be a "Work in Progress". Please complete it with documents you are missing in this list.
 +
 +
Resources related to OpenOffice.org Base:
 +
 +
= English =
 +
== Manuals ==
 +
* Base [http://wiki.services.openoffice.org/wiki/Base http://wiki.services.openoffice.org/wiki/Base]
 +
 +
Description of Base (short overview)
 +
 +
* OpenOffice.org User Guides (Getting started with Base
 +
 +
[http://documentation.openoffice.org/manuals/oooauthors2/0110GS-GettingStartedWithBase.pdf http://documentation.openoffice.org/manuals/oooauthors2/0110GS-GettingStartedWithBase.pdf]
 +
 +
* Working basis to make the user guide better
 +
 +
[http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Getting_Started/Getting_Started_with_Base http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Getting_Started/Getting_Started_with_Base]
 +
 +
* Sun Report Builder
 +
 +
[http://wiki.services.openoffice.org/wiki/SUN_Report_Builder http://wiki.services.openoffice.org/wiki/SUN_Report_Builder]
 +
 +
* Sun Report Builder (Reference)
 +
 +
[http://wiki.pentaho.org/display/Reporting/Pentaho+Reporting+Latest http://wiki.pentaho.org/display/Reporting/Pentaho+Reporting+Latest]
 +
 +
* Common tasks
 +
 +
[http://wiki.services.openoffice.org/wiki/Common_tasks http://wiki.services.openoffice.org/wiki/Common_tasks]
 +
 +
Initial author: Andrew 'Drew' Jensen
 +
 +
Many good questions, no answers.
 +
 +
* Beginners - Example Database - Base Tutorial
 +
 +
[http://www.oooforum.org/forum/viewtopic.phtml?t=25060 http://www.oooforum.org/forum/viewtopic.phtml?t=25060]
 +
 +
Initial author: Andrew 'Drew' Jensen
 +
 +
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.
 +
 +
== 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/]
 +
 +
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@openoffice.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]
 +
 +
== 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.
 +
 +
== 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://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://dba.openoffice.org/ OOo Database Development]<br>
 
[http://dba.openoffice.org/ OOo Database Development]<br>
 
[http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html OOo Database QA]<br>
 
[http://qa.openoffice.org/ooQAReloaded/DatabaseTeamsite/ooQA-TeamDatabase.html OOo Database QA]<br>

Revision as of 15:57, 24 September 2007

On this side you find links to documents of Base ordered by languages and topics. This side may be helpful for authors and translators.

This page can only be a "Work in Progress". Please complete it with documents you are missing in this list.

Resources related to OpenOffice.org Base:

English

Manuals

Description of Base (short overview)

  • OpenOffice.org User Guides (Getting started with Base

http://documentation.openoffice.org/manuals/oooauthors2/0110GS-GettingStartedWithBase.pdf

  • Working basis to make the user guide better

http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Getting_Started/Getting_Started_with_Base

  • Sun Report Builder

http://wiki.services.openoffice.org/wiki/SUN_Report_Builder

  • Sun Report Builder (Reference)

http://wiki.pentaho.org/display/Reporting/Pentaho+Reporting+Latest

  • Common tasks

http://wiki.services.openoffice.org/wiki/Common_tasks

Initial author: Andrew 'Drew' Jensen

Many good questions, no answers.

  • Beginners - Example Database - Base Tutorial

http://www.oooforum.org/forum/viewtopic.phtml?t=25060

Initial author: Andrew 'Drew' Jensen

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.

Connecting

  • 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

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

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/

An overview page

  • Native PostgreSQL Driver

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

Initial author: Wind Li (yl146652@openoffice.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

  • MSA-Base Faq

http://wiki.services.openoffice.org/wiki/MSA-Base_Faq

Examples

General

  • Base Example (Overview)

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

Concrete Examples

  • 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

Misc

Testing


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



OOo Database Development
OOo Database QA
OOo General Database Info


Autor: Christoph Lukasiak (Clu) 4 September 2007
Please do not change the logical content of this site without acknowledge of the author or the OOo QA Project Lead/Co-Leads.

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/Database&oldid=47807"
Personal tools