Open Office How To

From Ingres Community Wiki

Contents 1 Using OpenOffice and Ingres 2006 Release 2 2 Introduction 3 What is needed 3.1 Sources 4 Configuration Steps 4.1 Select the JVM to use 4.2 Add the JDBC driver 4.3 Register the database 4.4 Ingres JDBC URL Connection Information 4.4.1 Test the JDBC driver class 4.5 Specify user authentication 5 See Also

Using OpenOffice and Ingres 2006 Release 2

Introduction

This topic explains how to configure OpenOffice, the open source multi-platform office productivity suite, for use with Ingres 2006, the open source multi-platform DBMS.

It is quite possible that earlier versions of Ingres (and the Ingres JDBC driver) will work to some extent with Open Office. These instructions have been tried with Ingres 2006 release 2 GA and Ingres 2006 release 3 (Beta).

What is needed

Ingres 2006 and OpenOffice. The Ingres JDBC driver is included with the Ingres distribution.

Sources

Where to find what you need:

• Ingres
  • Ingres 2006 can be downloaded from http://www.ingres.com/ and the community edition can be found at http://community.ingres.com/

• Ingres documentation is available online at http://docs.ingres.com/ and this includes the Ingres Connectivity Guide which contains detailed information about the Ingres JDBC driver.

• OpenOffice
  • OpenOffice is available at: http://openoffice.org/

Configuration Steps

Ensure that both Ingres and OpenOffice are installed on your computer. Make a note of the Ingres system directory (the directory where Ingres was installed.) If you do not know where Ingres was installed you can examine the value of the operating system environment variable: II_SYSTEM.

To connect OpenOffice to your Ingres installation you select the JRE you wish to use and ensure that the Ingres JDBC driver is available on your Class Path. The JDBC driver is found in the Ingres system directory. Follow the sub-directory structure: ingres->lib. You then configure OpenOffice to connect to your Ingres database. The following steps show you how to do this:

Select the JVM to use

Open the Options (Tools -> Option...) dialog in Open Office, choose the Java options and click the [ Class Path ] button to activate the Class Path dialog:

Add the JDBC driver

Add the Ingres JDBC driver to your Class Path:

NB: If you have multiple Ingres instances you must make sure that the latest JDBC driver is at the top of the list in this dialog.

Register the database

Start the OpenOffice database utility. In the first step enable the radio button 'Create a new database'. You will see the view shown below:

Enter the JDBC URL to connect to your database and the Ingres JDBC driver class.

The Ingres JDBC driver class is com.ingres.jdbc.IngresDriver. The JDBC URL depends on your database name. The screen capture below shows the driver class information entered:

Ingres JDBC URL Connection Information

Add the Ingres JDBC URL Connection Information:

The screen above is shown with placeholders as follows

host	Name or IP address of the server
port	Ingres JDBC listen port
database_name	Name of your database
options	Other Ingres JDBC options (e.g., user credentials)

The placeholders are:

• host - the name of the host on which Ingres is running (the Ingres iigcd process, the Data Access Server (DAS) specifically, this is often the same host as that for the DBMS
• port - this is the port on which Ingres listens for JDBC connections. This may be a mnemonic (like 'II7') or an actual numeric port. By default, the mnemonic listen port for JDBC is the instance ID of Ingres (default II) followed by a '7' (seven)
• database_name - Ingres database name. If the Ingres DAS and DBMS are installed together the name of the database alone is required. You may also use an Ingres vnode (virtual node) definition.
• options - e.g., User ID and password. These values are not required if connecting to Ingres on the same machine; otherwise, user and password are required and are validated against the operating system on the remote machine. You can either specify these values on the JDBC URL or in the following dialog. For other security options, see the Ingres documentation.

The screen below shows the page with a sample Database URL included

Test the JDBC driver class

You can test the JDBC driver class by clicking the 'Test Class' button in this dialog.

Specify user authentication

You specify the user authentication details in the next screen. You do not have to specify a username and password if you are accessing Ingres locally and your current user name has Ingres access rights. In general though, you must specify a valid user for the DBMS.

This example shows the DBMS user 'ingres' specified

You can click the 'Test Connection' push button to verify that Ingres is running and the configuration information is correct.

Once you have completed entering the information for this page, click [ Finish ].

You can now use this database connection in OpenOffice applications, see Open Office Ingres Data How To

See Also

Open Office Ingres Data How To