You can use the New Service wizard to create a copy service.
A source and target Optim™ logical
data model are required.
The source model must include a data
access plan. You can use the New Service wizard to define a plan for
the model.
To create a copy service:
- From the Data Project Explorer, right-click the Services folder
and click . The New Service
wizard opens.
- Complete the steps of the wizard.
You must
select a source Optim logical
data model and a data access plan in the model.
Use the Target
Model Options page to determine how to select a target data model
for the service as well as the type of operation to perform on the
target data model.
The following target model selection options
are available:
- Select a target model and perform auto map
- Use this option to select a target Optim logical
data model and allow Optim Designer
to automap the source and target model. The automap function maps
entities and attributes in the source model to matching entities and
attributes in the target model. For the automap function to work,
the source and target models should have similar schemas.
- Open the service plan editor and manually complete the target
model selection and map the source to the target
- Use this option to open the service plan editor, in which you
will select a target model and map the source model to the target
model. To select a target model from the service plan editor, click Add
Target Model.
The following target operations are available:
- Insert
- Inserts new rows into the destination entities. If the primary
key of a row in the source data does not match the primary key of
a row in the destination entity, the row is inserted. If the primary
key of a row in the source data matches the primary key of a row in
the destination entity, the operation fails.
- Update
- Updates existing rows in the destination entities. If the primary
key of a row in the source data matches the primary key of a row in
the destination entity, the row is updated. If the primary key of
a row in the source data does not match the primary key of a row in
the destination entity, the operation fails.