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:
- 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.
- Right-click the schema, and click Transform
to Optim Logical Data Model. The Transform
to Optim Logical Data Model
wizard opens.
- 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.
- 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.
- On the Enter Model Name and Project Folder page, type OPTIMUSER in Name.
Click Next.
- 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.
