Creating a copy service

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:

  1. From the Data Project Explorer, right-click the Services folder and click New > Executor Service. The New Service wizard opens.
  2. 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.