Release 10.1A: OpenEdge Data Management:
DataServer for ODBC

> ## Creating a schema holder

> A schema holder contains a schema image of the ODBC data source that your DataServer application accesses. The schema image contains the schema for your data source—that is, its data definitions—in an OpenEdge format. Although applications can access a data source directly by sending SQL statements through the DataServer, they cannot directly access its data definitions and must use the schema image information instead.

> When you decide where to build your schema holder, consider your business needs and deployment strategy. The schema holder can reside on the client machine or on any host in an enterprise configuration. Client schema holders improve performance for some applications. Host schema holders give you the flexibility of having them run as Windows services. Additionally, host schema holders might be easier to maintain. In a WebSpeed configuration, placing the schema holder on the Transaction Server machine optimizes performance.

> | To create a schema holder:

> 1. Establish the appropriate permissions for pulling the schema image into the schema holder.

> 2. Perform some preparatory steps.

> 3. Create and then connect an empty OpenEdge database. This database becomes your schema holder and contains your schema image.

> 4. Create the schema holder, which involves specifying connection parameters and pulling the schema from the data source.

> The following sections describe these steps in detail.

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