Organization

Describes the basic architecture of the DataServer for Oracle and presents guidelines for using the DataServer.

Discusses the differences between Oracle and OpenEdge and how the DataServer resolves them.

Defines relational database management system (RDBMS) stored procedures and describes how to create and implement them in an OpenEdge environment. It discusses various techniques to execute RDBMS stored procedures and Send SQL statements on the MS SQL server and load results sets directly into temp-tables. ProDataSet functionality, available through the use of temp-tables, is also briefly discussed.

Additional Features to Enhance DataServer Performance

Presents various DataServer performance enhancement techniques you can use, including connection pooling.

Configuringthe DataServer

Presents instructions for configuring the DataServer and creating a schema holder.

Connectingthe DataServer

Presents instructions for connecting the DataServer and a schema holder.

The DataServerTutorial

Provides the opportunity to work with the DataServer utilities for Oracle that you use to maintain the schema holder. In addition, it describes the OpenEdge DB-to-Oracle migration utility.

UpgradingDataServer Applications

Describes the steps required to upgrade from earlier versions of the DataServer to OpenEdge Release 10.

EnvironmentVariables

Describes the environment variables that affect building and running the DataServer.

Sample Queries

Contains examples of queries and the SQL statements that the DataServer generates for the Oracle DBMS.

BuildingDataServer Executables

Provides instructions for building DataServer executables using OEBuild-based scripts.

DataServer Command Line Utilities and Startup Parameters

Describes the utilities you use to configure, manage, start, and stop the DataServer host and client.