< Previous

Defining an executor service to copy and transform data

In this exercise, you will define an executor service to copy and transform data defined in a source Optim™ logical data model.

To define an executor service to copy and transform data:

  1. In the Data Source Explorer view, right-click the Services folder and click New > Executor Service. The New Service wizard opens.
  2. On the Enter a Service Name and Select a Service Type page, do the following:
    1. In Service name, type CustomersMask.
    2. In the Service Types area, select Copy service.
    3. Click Next.
    New Service wizard
  3. On the Select a Source Optim Data Source page, select Optim Sample Database. Click Next.
  4. On the Select a Source Logical Data Model page, select OPTIMUSER.ldm. Click Next.
  5. On the Select a Data Access Plan page, select Source Plan. Click Next.
  6. On the Target Model Options page, select Select a target model and use an auto mapping of entities. Click Next.
  7. On the Select a Target Optim Data Source page, select Optim Sample Database. Click Next.
  8. On the Select a Target Optim Logical Data Model and Operation page, do the following
    1. From the Target Operation Type area, select Insert.
    2. Select the OPTIMUSER2.ldm Optim logical data model.
    3. Click Next.
  9. On the Match Schema page, accept the default mapping. Click Next..
  10. On the Auto Map Results page, review the results of the auto mapping. Click Finish.

The new data management service, CustomersMask, will appear under the Services folder. The service will copy data defined in the source OPTIMUSER Optim logical data model and insert it into the target defined in the OPTIMUSER2 Optim logical data model. The service will use the Source Plan data access plan to determine which data to select and transform from the OPTIMUSER Optim logical data model. The service definition automatically created a mapping between entities in the source Optim logical data model and the target Optim logical data model.

CustomersMask service

< Previous