Database Setup Wizard

OpenOffice.org 2.0 Base

Document - ID	Specification Owner	Last Change	Status
SPEC.DBA.DBWIZ	Frank Schönheit	2005-06-02	Final
Conforms to	
Applies to	OpenOffice.org Base
Task ID(s)	i20213, i42477
Category	Feature

Abstract

The new database application needs an easy to use entry point to create a new database file. These database files serve as an interface between the user and the actual data source. They contain all meta information about the database. The wizard will be started by the menu sequence “File/New”. By means of this file the database can be opened similarly to an office document.

i-Team Members (The specification owner is part of the i-Team)

	Name	E-mail Address
User Experience	Christian Jansen (CJ)	cj@openoffice.org
Development	Frank Schönheit	fs@openoffice.org
Quality Assurance	Marc Neumann (MSC)	msc@openoffice.org
Documentation	Uwe Fischer (UFI)	ufi@openoffice.org

Approved for Implementation

	Approved by	Date
User Experience	Christian Jansen	6/4/04
Development	Berend Cornelius	6/4/04
Quality Assurance	Marc Neumann	6/4/04
Documentation	Uwe Fischer	05/05/04
String Review	Paul Compton	16/06/2004
String Review	Elizabeth Matthis	7/28/04

Document Change History

Rev. Level	Change	Initials	Date
1.0	Initial draft	BC	3/23/04
	Issues of FS and CJ worked in	BC	4/23/04
	Inputs of UFI worked in	BC	5/3/04
	Inputs of OJ worked in	BC	5/4/04
	Inputs of CJ worked in	BC	5/5/04
	Issues of CJ worked in	BC	6/1/04
	Issues of MSC worked in	BC	6/3/04
	Workflow of creating new database totally renewed	CJ	30/07/04
	Help texts totally renewed (highlighted in yellow)	CJ	30/06/04
	Feedback from FS worked in	CJ	01/07/04
1.1.0	preserved snapshot of previous version, describing state at OOo 2.0 release took document ownership from Berend Cornelius (BC) added option to open an existing database document from within the wizard	FS	2005-06-02

Contents

1	Motivation	1

2	User Scenarios	1

3	Goals	2

4	Requirements and Dependencies	2

4.1	Requirements	2

4.2	Technical Dependencies	2

5	Competitive Analyses	2

6	Detailed Specification	3

6.1	General Notes to the following chapters.	3

6.2	Introduction Page	3

6.3	Save and Proceed	5

6.4	dBASE Settings	7

6.5	Text database settings	8

6.6	Microsoft Access	9

6.7	LDAP databases	10

6.8	ADABAS D settings	12

6.9	ADO settings	13

6.10	JDBC database	14

6.11	Oracle Database	15

6.12	MySQL database	16

6.13	Connecting to MySQL using ODBC	18

6.14	Connecting to ODBC	20

6.15	Table document data source	21

6.16	User authentication	22

6.17	Final page	23

6.18	Error Conditions	24

7	References	24

Glossary

Term	Description
Microsoft Access project	An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects such as tables and views.
Data Access page	A Web page, published from Access, that has a connection to a database. In a data access page, you can view, add to, edit, and manipulate the data stored in the database. A page can also include data from other sources, such as Excel.
ActiveX Data Objects (ADO)	A windows proprietary data access interface that communicates with OLE DB-compliant data sources to connect to, retrieve, manipulate, and update data.
OLE DB	A windows proprietary component database architecture that provides network and Internet access to many types of data sources, including relational data, mail files, flat files, and spreadsheets
ODBC	“Open Database Connectivity” is a protocol norm with which applications can access database systems. The query language used is Structured Query Language (SQL).
JDBC	Java Database Connectivity, like ODBC, is a protocol for accessing database systems. A difference is the platform - independency of the JDBC driver(s) programmed in the Java programming language as opposed to the platform dependent ODBC drivers
Work folder	The work folder is the initially displayed folder when the user wants to open or save a file.
database file	The file contains the queries, forms, and reports. It is created by the database application.
database	This is the database itself which contains tables and the corresponding data.

Motivation

As the new database application in OpenOffice 2.0 will make use of database files that contains all meta data information of the databases, a mechanism to create such a database file for a data source has to be provided. As an approach to make the handling with databases more transparent future databases are to be handled conforming to documents of the other office applications. This wizard will serve as an entry point to create a new database document. It will be started by the menu sequence “File/New”. This approach is more transparent to the user.

User Scenarios

Any user who has the need to administrate his personal data or enterprise data will make use of this feature. The first thing that is needed is the wish to administrate some personal data by means of a database. This wizard will offer both a database file to an existing existing data source or the creation of a database file to a new database. In both cases the user will go through this wizard.

Goals

The goal is to make it as easy as possible to a novice user to create a database file. The functionality in the dialogs shall be surrounded by help texts that explain the user the need for a database file and the the concept behind this approach. The concept is that by opening the database file the user accesses his database which means that the database behaves similar to a document of the other office applications.

Requirements and Dependencies

Requirements

There are no basic requirements that cannot be met by the current features of the database application. The wizard is more or less a wrapper around existing functionality.

Technical Dependencies

The necessary features that are required by the Database Wizard are already implemented and tested.

Competitive Analyses

In this chapter it is described how Microsoft Access XP guides the user to create a new database.

The starting point to create a new database is via the menu sequence “File”/”New”:

The following options appear on the task pane of the application (see Microsoft Access Screen shot):

Open an existing database. A history of the most recent database ease the choice.

Creation of a new blank database or Microsoft Access project or Data Access page.

Creation of a new database from an existing template. With this option you can create a new database with a predefined structure, by selecting the template via File open dialog.

Creation of a new database from a fix set of templates. These template databases contain tables around a common topic like “Inventory control” or “Contact Management”

Compared to Microsoft Access we have to face one major difference: Open Office serves merely as a front end to several database whereas Microsoft Access has its own defined database engines. As many of our supported databases are not file oriented it does not make sense to create a database from an existing one because the created database would only be another reference to the same data source.

It is not planned to implement another Database Wizard that creates tables around one single topic like in Microsoft Access because we already have a Table Wizard for this purpose.

Microsoft Access Screen shot

Detailed Specification

Basically the creation of a new database file can be divided into four different steps, of which not all are necessarily performed:

Selection of the database type

Setting the main database configurations. These settings are unique for all databases types.

Setting the user authentication if necessary and/or desired

Finalization of the wizard.

General Notes to the following chapters.

Although not correctly shown in the following screen shots of the following pages the “Next” Button and the “Finish” button are disabled when necessary settings have not been made, especially on the pages where the database configurations are set. In this case the roadmap items on the left hand side of the dialog pages (see [SPEC.UI.WIZARDS]) describing the following steps are also disabled.

Introduction Page

The introduction page is the first page of the wizard, which is opened via the menu sequence “File”/”New”/”Database”

On this page (see Illustration 1) the user is introduced to the general purpose of a the database wizard. The rest of the dialog works like the respective dialog page described in [SPEC.DBA.DSPROP].

Illustration 1: Introduction page

Label Right Pane Header	Welcome to the %PRODUCTNAME Database Wizard	Willkommen zum %PRODUCTNAME Datenbank-Assistent.	TRANSLATORS! %PRODUCTNAME is a placeholder, do not translate.
Label Helptext	You can either create a new database or set up a connection to an existing database. In both cases, a file will be created. This file stores information such as connection settings, forms and reports.	Sie können eine neue Datenbank erstellen, oder eine Verbindung zu einer bestehenden Datenbank herstellen. In beiden Fällen wird eine Datenbankdatei erstellt. In dieser Datei werden Verbindungsdaten, Formulare und Berichte gespeichert.	
Label Helptext	What do you want to do?	Wie möchten Sie fortfahren?	
Radio Button	Create a n~ew database	N~eue Datenbank erstellen	
Radio Button	Connect to an e~xisting database	~Verbindung zu einer bestehenden Datenbank herstellen	
Label	Database ~type	Datenbanktyp	
Radio Button	Open an e~xisting database file	Eine ~bestehende Datenbankdatei öffnen	since spec version: 1.1
Button	~Open...	Ö~ffnen...	since spec version: 1.1
Roadmap item	Select database	Datenbank auswählen	

Users can choose between three options, which decide on the subsequent course of the wizard:

Creating a new database

This option is pre-selected, and does not require any further settings except the ones on the last page (see “Save and Proceed“).

Connecting to an existing database

This option creates a database file which does not contain the actual data, but connects to an external database.

The users can select from a alphabetically ordered Database type list., where the default selection for connecting of the database types is “JDBC”. For a complete list of all supported databases see the list in [SPEC.DBA.DSPROP], chapter “Database types of a data source”.

With this option, the “Finish” button is disabled, and the “Next” button enabled, since for most database types additional settings are required.

The following database types do not require additional configuration: Outlook, Evolution, Mozilla. In those cases, clicking the “Next” button will immediately lead to the last page (see “Save and Proceed“). With all other database types and interfaces the user will navigate to a special page of the respective selected database.

Opening an existing database

This option allows the user to open a database file which already exists. The option is modeled after the respective option in the “Presentation Wizard”, which is started when a new presentation document is to be created.

A list box below this option contains all database documents which are currently to be found in the “Recent Documents” list. Double-clicking an entry in this list, or selecting the “Finish” button while an entry in this list is selected, immediately loads the respective document.

Additionally, a button labelled “Open...” is also dependent on this option. When this button is clicked, the usual file dialog opens, allowing the user to select a database document to open. Upon closing the file dialog with OK, the wizard is dismissed, and the selected file is loaded immediately.

As long as this option is selected, the “Next” button of the dialog is disabled. If and only if an entry in the recent documents list is selected, the “Finish” button is enabled.

Save and Proceed

The “Save and proceed" page of the wizard allows users to specify the folder where to save database files and under which name the connection data shall be saved. The connection data file (odb) shall be saved in the same folder like the database storage files. Clicking 'Finish' shall first test if chosen folder already contains same named database files. If so, a warning shall appear telling users that the file already exists. Users can choose between overwriting the existing database, or specifying a new name (default). For this warning OpenOffice.org shall use the standard OpenOffice.org overwrite warning. Choosing 'No' closes the dialog; next the file name shall be highlighted this save one click.

Clicking Finish creates an empty Database file and the connection file it shall be enabled as soon as the folder text box contains content. A standard validation of the content will take place as soon as the “Finish” button is pressed.

This wizard page also provides additional setting for performing next steps.

The option to make the database available for the other OpenOffice.org modules is checked by default and the newly created database shall be opened afterwards. Additionally users shall be ask if the want to continue with creating a new Table. This option shall call the Table Wizard (see [SPEC.DBA.TABLEWIZ]).

Selecting Finish closes the wizard and calls a File Picker for saving the database file. The default name of a newly created database file shall be "New Database 1.odb". The string shall be preselected, so that it is very easy for users to overwrite the filename. In case a file named New Database 1.odb already exists in the folder the number shall rise by the count of 1.

Illustration 2: Save and proceed

Item	English	German	Comments
Right Pane Heading	Decide how to proceed after saving the database	Bitte entscheiden Sie wie Sie fortfahren möchten	
Text	Do you want the wizard to register the database in %PRODUCTNAME?	Soll der Assistent die Datenbank in % PRODUCTNAME anmelden?	
Label Radio	~Yes, register the database for me.	~Ja, die Datenbank soll angemeldet werden.	
Label Radio	N~o, do not register the database.	Nein, die Datenbank soll nicht angemeldet werden.	
Text	After the database file has been saved, what do you want to do?	Wie möchten sie fortfahren, nachdem die Datenbank gespeichert wurde?	
Label Check Box	Open the database for editing.	Die Datenbank zum ~Bearbeiten öffnen.	
Label Check Box	Create ~tables using the table wizard.	Eine ~Tabelle mit Hilfe des Tabellen-Assistenten erstellen.	
Text	Click 'Finish' to save the database.	Klicken Sie auf '~Fertig stellen', um die Datenbank zu speichern.	
Roadmap item	Save and proceed	Fertig stellen und fortfahren	

dBASE Settings

Item	English	German	Comments
Right Pane Heading	Set up a connection to dBASE files	Verbindung zu dBASE-Dateien einrichten	Translators! “dBASE” is a product name and not to be changed or translated.
Text	Select the folder where the dBASE files are stored.	Bitte wählen Sie den Ordner, in dem sich die dBASE- Dateien befinden.	
Label Radio	Path to dBASE files	Pfad zu den dBASE-Dateien	
Button	Browse...	Durchsuchen...	
Roadmap item	Set up dBASE connection	Verbindung zu dBASE-Dateien einrichten	

Text database settings

On the Text database page it is taken account for that most people who want to use text databases will want to use only one file as a database which is therefor the default behavior of the dialog page (Text File Settings Illustration). It is also allowed to use folders as a container for database text files. When a folder is selected the default file extension is “.csv”.

Otherwise the file extension is disabled and set to the extension of the selected file, because it is determined by the extension of the selected file. The container of the settings are combo boxes, that allow to add own separators. The offered separators are the most commonly used ones. They are retrieved from a standard repertoire of strings that is part of the OpenOffice.org Base application. The defaults are the same as specified in the Datasource Property dialog specification [SPEC.DBA.DSPROP] .

The “Next” button remains disabled as long as no existing location as described above is inserted.

Text File Settings Illustration

Item	English	German	Comments
Right Pane Header	Set up a connection to text files	Verbindung zu Text-Dateien einrichten	
Label Helptext	Select the folder where the CSV (Comma Separated Values) text files are stored. %PRODUCTNAME Base will open these files in read-only mode.	Bitte wählen Sie den Ordner, in dem sich die im CSV-Format (Comma Separated Value) gespeicherten Dateien befinden. %PRODUCTNAME Base greift auf die Daten nur lesend zu.	
Label textfield	~Path to text files	Pfad zu den Textdateien	
Button Label	B~rowse...	Durchsuchen...	
Label fixed line	Row format	Zeilenformat	
Label field separator	~Field separator	~Feldtrennzeichen	
Label text separator	Text ~separator	T~exttrennzeichen	
Label decimal separator	~Decimal separator	~Dezimaltrennzeichen	
Label thousands separator	Tho~usands separator	T~ausendertrennzeichen	
Roadmap item	Set up text file connection	Verbindung zu Textdateien einrichten	

Microsoft Access

On the Microsoft Access dialog page no authentication is provided (see Microsoft Settings Illustration). The browse button will raise the file open dialog and insert the Access file to the textbox. The textbox is initially empty.

The “Next” and the Finish button will be enabled as soon as the textbox path contains some content. A standard validation of the path takes place as soon as the Next button is pressed.

Microsoft Settings Illustration

Item	English	German	Comments
Right Pane Header	Set up a connection to a Microsoft Access database	Verbindung zu einer Microsoft Access Datenbank einrichten	
Label Helptext	Please select the Microsoft Access file you want to access.	Bitte wählen Sie die Microsoft Access Datei auf die Sie zugreifen möchten.	
Label Textfield	~Microsoft Access database file	Microsoft Access Datenbankdatei	
Button Label	B~rowse...	~Durchsuchen...	
Roadmap item	Set up Microsoft Access connection	Microsoft Access Verbindung einrichten	

LDAP databases

The settings for an LDAP database require certain knowledge that in most cases only the administrator is able to provide (see Illustration 3). The checkbox “Use secure connection (SSL)” is not selected by default. A hint beside the textbox for the port entry preserves the information about the defaulted port number (389) even when the textbox content is overwritten.

The “Next” button will be enabled as soon as the textboxes for the host server and the port contain values. The entry of the Base DN is optional.

Illustration 3: LDAP settings

Item	English	German	Comments
Right Pane Header	Set up a connection to an LDAP directory	Verbindung zu einem LDAP-Verzeichnis einrichten	
Label Helptext	Please enter the required information to connect to an LDAP directory. Please contact your system administrator if you are unsure about the following settings.	Bitte geben Sie die benötigten Information ein, um eine Verbindung zu einem LDAP-Verzeichnis herzustellen. Fragen Sie Ihren Systemadministrator, wenn Sie sich bei den folgenden Einstellungen unsicher sind.	
Label 'Host server'	Server ~URL	~Rechnername	
Label 'Base DN'	Base ~DN	Basis-~DN	
Label 'Port Number'	~Port number	~Portnummer	
Label 'Default Portnumber'	Default: 389	Standard: 389	
Checkbox label	Use ~secure connection (SSL)	Sichere ~Verbindung verwenden (SSL)	
Roadmap item	Set up LDAP connection	LDAP-Verbindung einrichten	

ADABAS D settings

The settings of an ADABAS D database can be applied via the new database dialog (see [SPEC.DBA.DSPROP]) which returns the url of the new ADBAS D database (see Illustration 4). In this dialog all issues about the creation of a new database or the connection to an existing database is handled appropriately.

Illustration 4: Adabas D settings

Item	English	German	Comments
Right Pane Header	Set up a connection to an Adabas D database	Verbindung zu einer Adabas D Datenbank einrichten	
Label Helptext	Enter the name of the Adabas D database you want to connect to. Click 'Browse...' to select an Adabas D database that is already registered in %PRODUCTNAME.	Bitte geben Sie den Namen der Adabas D Datenbank ein, zu der eine Verbindung erstellt werden soll. Klicken Sie "Durchsuchen..." um eine %PRODUCTNAME bekannte Adabas D Datenbanken auszuwählen.	
Label textbox	Name of the Adabas D database	Name der Adabas D Datenbank	
Roadmap item	Set up Adabas D connection	Adabas D Verbindung einrichten	

ADO settings

The necessary settings for a connection to an ADO database are retrieved from the ADO browse dialog (see Illustration 5). This dialog returns a connection url that is inserted into the textbox. As soon as this textbox contains some content the “Next” button is enabled. The textbox is initially empty. User authentication is handled within the ADO browse dialog (see [SPEC.DBA.ADOBRW]). Although also the testing of the connection is handled within this dialog it is also again provided in this page.

Illustration 5: ADO settings

Item	English	German	Comments
Right Pane Header	Set up a connection to an ADO database	Verbindung zu einer ADO-Datenquelle einrichten	
Label Helptext	Please enter the URL of the ADO data source you want to connect to. Click “More...” to configure provider-specific settings. Please contact your system administrator if you are unsure about the following settings.	Geben Sie bitte den URL ein, um eine Verbindung zu einer ADO-Datenquelle zu erstellen. Klicken Sie "Mehr...", um Hersteller-spezifische Einstellungen vorzunehmen. Fragen Sie Ihren Systemadministrator, wenn Sie sich bei den folgenden Einstellungen unsicher sind.	
Label textfield	Data source ~URL	D~atenquellen-URL	##see Ocke
Button Label	More...	Mehr...	EM->BC: was “Browse”
Roadmap item	Set up ADO connection	ADO-Verbindung einrichten	

JDBC database

To connect to a JDBC database the url and the driver class have to be entered (see Illustration 6).

The Next button is enabled as soon as settings have been applied to the Data source Url and the JDBC driver class.

Illustration 6: JDBC settings

Item	English	German	Comments
Right Pane Header	Set up a connection to a JDBC database	Datenbankverbindung per JDBC einrichten	
	~Test Class...	Klasse testen...	##see Ocke
Label Helptext	Please enter the required information to connect to a JDBC database. Please contact your system administrator if you are unsure about the following settings.	Bitte geben Sie die benötigten Information ein, um per JDBC eine Verbindung zu einer Datenquelle herzustellen. Fragen Sie Ihren Systemadministrator, wenn Sie sich bei den folgenden Einstellungen unsicher sind.	
Label Textfield	Data source ~URL	D~atenquellen-URL	
Label Textfield	JDBC ~driver class	JDBC-~Treiberklasse	
Label button	~Test Connection...	~Verbindungstest...	
Roadmap item	Set up JDBC connection	JDBC-Verbindung einrichten	

Oracle Database

An Oracle database is addressed only via JDBC. Therefor the settings are generally the same as for a JDBC data source (seeIllustration 7). The default setting for the port is 1521 and the driver class's default is “oracle.jdbc.driver.OracleDriver”. The “Test Class” button must be enabled as long as someone cleared the entry and the “Next” button are disabled as long as no entries in all textboxes have been made.

Illustration 7: Oracle Settings

Item	English	German	Comments
Right Pane Header	Set up a connection to an Oracle database	Verbindung zu einer Oracle-Datenbank einrichten	
Label Helptext	Please enter the required information to connect to an Oracle database. Note that a JDBC Driver Class must be installed on your system and registered with %PRODUCTNAME. Please contact your system administrator if you are unsure about the following settings.	Bitte geben Sie die benötigten Information ein, um per JDBC eine Verbindung zu einer Oracle-Datenbank herzustellen. Bitte beachten Sie, dass eine JDBC-Treiberklasse auf ihrem System installiert und %PRODUCTNAME bekannt sein muss. Fragen Sie Ihren Systemadministrator, wenn Sie sich bei den folgenden Einstellungen unsicher sind.	
Label	Name of the ~Oracle database	Name der Oracle Datenbank	
Label	~Server URL	~Rechnername	
Label	~Port number	~Portnummer	
Label'	Default: 1521	Standard: 1521	
Label 'class'	Oracle JDBC ~driver class	Oracle JDBC-~Treiberklasse	Only for Oracle databases
PushButton	~Test Class...	Klasse testen...	
Roadmap item	Set up Oracle database connection	Oracle Datenbankverbindung einrichten	

MySQL database

MySQL settings page Illustration MySQL databases can be addressed both via JDBC or ODBC (see MySQL Settings Illustration). The settings for an ODBC connection or a JDBC connection must be set in another dialog page. If the option to connect via ODBC has been selected the Next button is only enabled when the textbox with the database url contains content.

Item	English	German	Comments
Right Pane Header	Set up a connection to a MySQL database	Verbindung zu einer MySQL Datenbank einrichten	
Label Help text	You can connect to a MySQL database using either ODBC or JDBC. Please contact your system administrator if you are unsure about the following settings.	Bitte wählen Sie, ob die Verbindung auf die MySQL Datenbank per ODBC oder per JDBC hergestellt werden soll. Fragen Sie Ihren Systemadministrator, wenn Sie sich bei den folgenden Einstellungen unsicher sind.	
Label option group header	How do you want to connect to your MySQL database?	Wie möchten Sie sich mit Ihrer Datenbank verbinden?	
1st Radio button	Connect using ODBC (Open Database Connectivity)	Verbindung über ODBC (Open Database Connectivity)	
2nd Radio Button	Connect using JDBC (Java Database Connectivity)	Verbindung über JDBC (Java Database Connectivity)	
Roadmap item	Set up MySQL connection	MySQL Verbindung einrichten	

MySQL Settings Illustration The following screen shot shows the set up of a MySQL JDBC database.
“Next” button remains disabled as long as as the textboxes for the MySQL database and the host name are empty.

Item	English	German	Comments
Right Pane Header	Set up connection to a MySQL database using JDBC	Verbindung zu einer MySQL-Datenbank per JDBC einrichten	
Label Helptext	Please enter the required information to connect to a MySQL database using JDBC. Note that a JDBC driver class must be installed on your system and registered with %PRODUCTNAME. Please contact your system administrator if you are unsure about the following settings.	Bitte geben Sie die benötigten Information ein, um eine Verbindung per JDBC zu einer MySQL-Datenbank herzustellen. Bitte beachten Sie, dass eine JDBC-Treiberklasse auf ihrem System installiert und %PRODUCTNAME bekannt sein muss. Fragen Sie Ihren Systemadministrator, wenn Sie sich bei den folgenden Einstellungen unsicher sind.	
	Name of the database	Name der Datenbank	
Label option group header	MySQL JDBC ~driver class	MySQL JDBC-~Treiberklasse:	
Label	~Server URL	~Server URL	
Label	~Port number	~Portnummer	
Label	Default: 3306	Standard: 3306	

Connecting to MySQL using ODBC

The ODBC database can be selected from the application's respective listbox (ODBC datasource dialog)that offers all registered ODBC data sources of the operating system. It is called on clicking the Browse button. The “Next” button is enabled as soon as content is in the textbox of the database name. Initially it is empty (see ODBC Settings Illustration).

ODBC datasource dialog

ODBC Settings Illustration

Item	English	German	Comments
Right Pane Header	Set up a connection to a MySQL database using ODBC	Verbindung zu einer MySQL-Datenbank per ODBC einrichten	
Label Helptext	Enter the name of the ODBC database you want to connect to. Click “Browse...” to select an ODBC database that is already registered in %PRODUCTNAME. Please contact your system administrator if you are unsure about the following settings.	Bitte geben Sie den Namen der ODBC-Datenquelle ein, um eine Verbindung per ODBC zu einer MySQL-Datenbank herzustellen. Klicken Sie auf "Durchsuchen..." um eine %PRODUCTNAME bekannte ODBC-Datenquelle auszuwählen. Fragen Sie Ihren Systemadministrator, wenn Sie sich bei den folgenden Einstellungen unsicher sind.	
Label Textfield	Name of the ODBC database	Name der ODBC-Datenquelle	
Roadmap item	Set up JDBC connection	JDBC-Verbindung einrichten	
Roadmap item	Set up ODBC connection	ODBC-Verbindung einrichten	

Connecting to ODBC

The ODBC database can be selected from the application's respective listbox (ODBC datasource dialog)that offers all registered ODBC data sources of the operating system. It is called on clicking the Browse button. The “Next” button is enabled as soon as content is in the textbox of the database name. Initially it is empty (see ODBC Settings Illustration).

ODBC datasource dialog

Item	English	German	Comments
Right Pane Header	Set up a connection to an ODBC database	Verbindung zu einer ODBC-Datenquelle einrichten	
Label Helptext	Enter the name of the ODBC database you want to connect to. Click “Browse...” to select an ODBC database that is already registered in %PRODUCTNAME. Please contact your system administrator if you are unsure about the following settings.	Bitte geben Sie den Namen der ODBC-Datenquelle ein, um eine Verbindung herzustellen. Klicken Sie auf "Durchsuchen..." um eine %PRODUCTNAME bekannte ODBC-Datenquelle auszuwählen. Fragen Sie Ihren Systemadministrator, wenn Sie sich bei den folgenden Einstellungen unsicher sind.	
Label Textfield	Name of the ODBC database	Name der ODBC-Datenquelle	
Roadmap item	Set up ODBC connection	ODBC-Verbindung einrichten	

Table document data source

In this case no username is passed with the authentication. Default setting: Textbox is empty. Browse button raises file picker with a filter for Calc & EXCEL documents being initialized (see Table Document Settings Illustration).

Table Document Settings Illustration

Item	English	German	Comments
Right Pane Header	Set up a connection to spreadsheets	Verbindung zu Tabellendokumenten einrichten	
Label Helptext	Click “Browse...” to select a %PRODUCTNAME spreadsheet or Microsoft Excel workbook. %PRODUCTNAME will open this file in read-only mode.	Klicken Sie auf "Durchsuchen..." um auf Daten aus %PRODUCTNAME Tabellen-Dokumente oder Microsoft Excel Arbeitsmappen zu zugreifen. %Productname greift auf die Daten der Tabellendokumente nur lesend zu.	
Label Textfield	Location and file name	Speicherort und Dateiname	
Button Label	B~rowse...	Durchsuchen...	
Check Box Label	~Password required	Kennwort erforderlich	
Roadmap item	Set up Spreadsheet connection	Verbindung zu Tabellendokumenten einrichten	

User authentication

As to be seen in the previous screenshots this page is called from the following database types: LDAP, ODBC, JDBC, Oracle, MySQL and ADABAS D.

Next button is basically enabled. If the checkbox “Password is required” is checked it remains disabled as long as the textbox for the user name is empty (see Authentification Settings Illustration). In this way the user can also leave the page when no authentication is desired or required.

Authentification Settings Illustration

Item	English	German	Comments
Right Pane Header	Set up the user authentication	Benutzer-Authentifizierung eingeben	
Label Helptext	Some databases require you to enter a user name.	Geben Sie bitte jetzt einen Benutzernamen ein, falls die Datenbank zur Verbindungsherstellung einen bestimmten Benutzer erwartet.	
Textfield label	~User name	~Benutzername	
Checkbox label	Password re~quired	Kennwort erforderlich	
Roadmap	Set up user authentication	Benutzer-Authentifizierung einrichten	

Final page

Selecting Next > moves on to the second page of the wizard (figure 2). On this page users can specify how to move on after the database file has been saved.

Selecting Finish closes the wizard and calls a File Picker for saving the database file. The default name of a newly created database file shall be "New Database 1.sxb". The string shall be preselected, so that it is very easy for users to overwrite the filename. In case a file named New Database 1.sxb already exists in the folder the number shall rise by the count of 1.

The following wizard navigation buttons shall be active:

< Back,

Finish, (shall be the default)

Cancel, and

Help

The option to make the database available for the other OpenOffice.org modules is checked by default and the newly created database shall be opened afterwards. Additionally users shall be ask if the want to continue with creating a new Table. This option shall call the Table Wizard.

Error Conditions

The handling of Errors is described in the specification [SPEC.DBA.DSPROP].

References

[SPEC.DBA.ADOBRW] ADO Browse Dialog, Yong Wind Li, December 2003; http://dba.openoffice.org/specifications/ADO_Browse_Dialog.sxw

[SPEC.DBA.DSPROP] Data Source Property dialog, Ocke Jansen, February 2005; http://dba.openoffice.org/specifications/Data_Source_Property_Dialog.sxw

[SPEC.DBA.TABLEWIZ] Table Wizard, Berend Cornelius, December 2003; http://dba.openoffice.org/specifications/Wizard_Table.sxw

[SPEC.UI.WIZARDS] Concept for Wizards, Berend Cornelius, Matthias Müller-Prove et al., 2004; http://specs.openoffice.org/installation/wizards/Wizards_NewConcept.sxw

Database Setup Wizard

Page 25

http://dba.openoffice.org/specifications/Wizard_Database.sxw

Frank Schönheit

2004-03-17T18:11:10