< Previous | Next >

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

In this exercise, you will create logical data models from schemas in a physical data model. Logical data models are not specific to a database and describe the data used with Optim™ data management services and processes. 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 or process.

To transform schemas 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 to display the OPTIMUSER and OPTIMUSER2 schemas.
  2. Right-click the OPTIMUSER 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, Optim Sample Database. Click Next.
    Transform to Logical Data Model wizard
  4. On the Enter Model Name and Project Folder page, type OPTIMUSER in Name. Click Next.
  5. 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.
  6. From the Optim Sample physical data model, right-click the OPTIMUSER2 schema, and click Transform to Optim Logical Data Model. The Transform to Optim Logical Data Model wizard opens.
  7. On the Select Transformation Options page, select Create new model. Click Next.
  8. On the Enter Model Name and Project Folder page, type OPTIMUSER2 in Name. Click Next.
  9. On the Transformation Results page, review the results of the transformation, and click Finish.
    logical data models
    The new logical data model, OPTIMUSER2.ldm, will appear under the Data Models folder.
You have created two new Optim logical data models, OPTIMUSER and OPTIMUSER2.
< Previous | Next >