How to configure Database Manager to run Waypoint™

In order to run Waypoint™, you have to configure the database for Microsoft Access or Oracle. This page will explain briefly how to configure those settings with using Database Manager of Waypoint™. For more detailed information, refer to the Waypoint User's Guide and Administrator's Guide.

1. Creating a Configuration File

To create a new configuration or database file, you must first open the Database Manager application, using the following steps(Refer to Fig. 1.1):

1) Run Database Manager.
2) Select New Configuration
3) Save the configuration

Figure 1.1: Waypoint™'s Database Manager

2. Creating a Database File

Run Database Management and select New Database. The Create New Database window will appear. Select the type of database you want to create: Access™ or Oracle™. Depending on the type of database selected the steps involved in creating a new database varies slightly.

2.1 Creating an Access Database

To create a new Access™ database file simply click the Browse button, to the right of the New Database field. A Windows™ Save As dialogue will appear prompting you to enter a name for the database file and select a directory in which to save it

Name the database file and save it in the default Waypoint\Database directory, or another directory of your choice.

The validation and correction process will then run automatically since all database files created through Database Manager are validated and corrected at time of creation. When the validation and correction process completes the validation report will appear. Click Close to close this window, and complete the database creation process.

1) Open Database Manager
2) Select Database Manager->New Database Manager

2.2 Creating an Oracle™ Database

To create a new Oracle™ database file, click the Browse button to the right of the New Database field .The Oracle Server Login dialogue will appear.

Figure 2.1: Oracle Server Login Dialog Window

In the Oracle Server Login window, choose a Data Source from the drop-down list. Enter the WaypointAdmin login ID, with the password waypoint. Click OK.

Figure 2.2: Choose Schema Dialog Window

The Create Schema dialogue will appear . Enter the name and password of the new database (schema) you would like to create. Click OK.

Figure 2.3: Create Schema Dialog Window

The validation and correction process will then run automatically since all database files created through Database Manager are validated and corrected at time of creation. However, prior to running this process, a Waypoint™ message will appear asking if you would like to deploy the Audit Trail mechanism.

An information dialogue will appear to confirm that your database (schema) was created successfully. Click OK to close this window.

Go to Previous Page