Progress
DataServer
for ORACLE Guide


Guidelines for Using the DataServer

Progress supports many capabilities not found in other database management systems, such as backward scrolling and the ability to find the previous or last record in a table. The DataServer supports these and other programming and database features to ensure that your applications work with both Progress and ORACLE databases.

The DataServer allows you to use Progress features as extensions to ORACLE. Some of the Progress programming and database design techniques that you can implement on your ORACLE database using the DataServer are:

For access to some of these features, you might have to make minor modifications to your ORACLE tables. For a discussion of these issues and instructions for modifying ORACLE tables, see Programming Considerations."

When you create an ORACLE database from an existing Progress database with the Progress-to-ORACLE migration utility if you select the Create Extended 4GL Objects option, you can use the FIND PREV/LAST statements, arrays, and case-insensitive indexes with the resulting ORACLE database, in addition to taking advantage of Progress-like cursor behavior.

How you use the DataServer depends on whether you plan to access information in an ORACLE database through a Progress or WebSpeed application, or whether you plan to migrate a Progress database to ORACLE. The following sections outline these possibilities and point you to the information you need in this manual.

NOTE: If you are developing a WebSpeed application, all the programming information in this guide applies to your SpeedScript code. For information on connecting WebSpeed Agents, see your WebSpeed Installation and Configuration Guide.

Using the DataServer for ORACLE for the First Time

These are the preparations you have to make before using the DataServer.

  1. Install the DataServer modules on the machines your configuration requires.
  2. Create a local schema holder on the client machine.

"Configuring the DataServer," provides information about where to install DataServer modules and creating a schema holder.

Using the DataServer to Migrate a Database from Progress to ORACLE

These are the steps you follow when setting up and using the DataServer:

  1. Install the DataServer modules on the machines your configuration requires.
  2. Run the Progress-to-ORACLE migration utility.

The "The Progress-to-ORACLE Utility" section in "The DataServer Tutorial," provides specific instructions.

Upgrading to the Progress Version 9 DataServer for ORACLE

These are the preparations you have to make before using the DataServer if you want to take advantage of Progress Version 9 features:

  1. Install the Version 9 DataServer modules on the machines your configuration requires.
  2. Create a schema holder.
  3. Upgrade Version 7 or 8 schema holders to Version 9 by dumping data definitions and loading them into the new schema holder.

See "Configuring the DataServer,"for information about where to install DataServer modules and creating a schema holder. See "Upgrading DataServer Applications," for more information on upgrading your DataServer.

Table 1–2 suggests paths through this manual that accommodate different approaches to using the DataServer for ORACLE.

Table 1–2: How to Use This Manual 
If You Are . . .
Read This . . .
New to the DataServer for ORACLE
Migrating a Progress database to ORACLE
Upgrading to the DataServer to Progress Version 9
Upgrading from ORACLE7 to ORACLE8


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095