< Previous | Next >

Transforming a schema in a physical data model to an Optim logical data model

In this exercise, you will create an Optim™ logical data model from a schema in a physical data model. Logical data models are not specific to a database and describe the data used with Optim data management services. An Optim logical data model is a logical data model that includes a data access plan, which contains policies that determine the data to copy or transform from a source logical data model used in an Optim data management service.

To transform a schema in a physical data model to an Optim logical data model:

  1. In the Data Project Explorer, expand the Data Models folder, and expand the Optim Sample physical data model to display the schema for the Optim sample database.
  2. Right-click the schema, and click Transform to Optim Logical Data Model. The Transform to Optim Logical Data Model wizard opens.
  3. On the Select Transformation Options page, select Create new model and use the default value for the Optim data source name, Optim Sample Database. Click Next.
    Transform to Logical Data Model wizard
  4. On the Native Data Source Access page, clear the Use native data source connection as the default for services check box. A native data source connection is not required for this tutorial. Click Next.
  5. On the Enter Model Name and Project Folder page, type OPTIMUSER in Name. Click Next.
  6. On the Transformation Results page, review the results of the transformation, and click Finish. The new logical data model, OPTIMUSER.ldm, will appear under the Data Models folder.

You have created a new Optim logical data model, OPTIMUSER.

OPTIMUSER logical data model

< Previous | Next >