Difference between revisions of "Openoffice.org with SQL Databases"

From GRASS-Wiki
Jump to: navigation, search
(Using Openoffice.org with SQL Databases)
 
m
Line 11: Line 11:
 
# download postgresql-sdbc-X.Y.Z.zip driver
 
# download postgresql-sdbc-X.Y.Z.zip driver
 
# Start OpenOffice, choose 'Tools/Package Manager'. Click on the add button and select the downladed file (DO NOT EXTRACT IT !) in the upcoming File dialog. The driver gets installed now, afterwards, the file is listed in the dialog with state enabled. In case you have installed an older version of the driver, remove it now. Close the dialog and restart openoffice (even the quickstarter on windows must be shut down !!!). Done.
 
# Start OpenOffice, choose 'Tools/Package Manager'. Click on the add button and select the downladed file (DO NOT EXTRACT IT !) in the upcoming File dialog. The driver gets installed now, afterwards, the file is listed in the dialog with state enabled. In case you have installed an older version of the driver, remove it now. Close the dialog and restart openoffice (even the quickstarter on windows must be shut down !!!). Done.
 
  
 
==== Usage of PostgreSQL driver ====
 
==== Usage of PostgreSQL driver ====
Line 23: Line 22:
 
* Then click on 'Tables' in the next screen to see the existing PG tables in the database. Usually the 'public' scheme contains the user tables.
 
* Then click on 'Tables' in the next screen to see the existing PG tables in the database. Usually the 'public' scheme contains the user tables.
 
* The 'Queries' button takes you to the query mode, it contains a graphical query designer.
 
* The 'Queries' button takes you to the query mode, it contains a graphical query designer.
 +
  
 
=== MySQL (OpenOffice.org 2.x) ===
 
=== MySQL (OpenOffice.org 2.x) ===
  
 
* Connection via JODBC driver: http://kienlein.com/pages/mysql-jdbc-howto-en.html
 
* Connection via JODBC driver: http://kienlein.com/pages/mysql-jdbc-howto-en.html
 +
  
 
=== DBF files (OpenOffice.org 2.x) ===
 
=== DBF files (OpenOffice.org 2.x) ===
  
 
No installation needed, the driver is included in the standard version of OpenOffice.org.
 
No installation needed, the driver is included in the standard version of OpenOffice.org.
 +
  
 
=== MS-Access mdb files (OpenOffice.org 2.x) ===
 
=== MS-Access mdb files (OpenOffice.org 2.x) ===
Line 39: Line 41:
  
 
* See also ODBC based connection: http://www.openoffice.org/FAQs/ms-access/ms-access.html
 
* See also ODBC based connection: http://www.openoffice.org/FAQs/ms-access/ms-access.html
 +
  
 
=== SQLite files (OpenOffice.org 2.x) ===
 
=== SQLite files (OpenOffice.org 2.x) ===
  
 
* http://dba.openoffice.org/drivers/sqlite/index.html
 
* http://dba.openoffice.org/drivers/sqlite/index.html

Revision as of 11:41, 13 August 2006

Installation of additional drivers

  • See Database drivers page for overview. There are drivers for PostgreSQL, SQLite and MS-Access mdb files.

PostgreSQL (OpenOffice.org 2.x)

Installation of PostgreSQL driver

  1. download postgresql-sdbc-X.Y.Z.zip driver
  2. Start OpenOffice, choose 'Tools/Package Manager'. Click on the add button and select the downladed file (DO NOT EXTRACT IT !) in the upcoming File dialog. The driver gets installed now, afterwards, the file is listed in the dialog with state enabled. In case you have installed an older version of the driver, remove it now. Close the dialog and restart openoffice (even the quickstarter on windows must be shut down !!!). Done.

Usage of PostgreSQL driver

After starting OpenOffice.org, use: File -> New -> Database to enter the DB dialog.

  • Connect to existing database (select driver): postgresql
  • Connection settings (example, find out with psql -l): dbname=pqtest host=mydatabaseserver
  • User name: yourname
  • Finish brings you to a 'Save as' dialog for the connection, saves these settings as file
  • Then click on 'Tables' in the next screen to see the existing PG tables in the database. Usually the 'public' scheme contains the user tables.
  • The 'Queries' button takes you to the query mode, it contains a graphical query designer.


MySQL (OpenOffice.org 2.x)


DBF files (OpenOffice.org 2.x)

No installation needed, the driver is included in the standard version of OpenOffice.org.


MS-Access mdb files (OpenOffice.org 2.x)

Note that the driver is somewhat behind the mdbtools.sf.net development.


SQLite files (OpenOffice.org 2.x)