In this exercise, you will create an Optim™ interoperability service that includes
an extract request. The service allows you to execute an Optim request from the Optim Manager environment.
To create an Optim interoperability
service:
- In the Data Project Explorer view, right-click the Services folder
and click . The New Extract Service wizard opens.
- On the Enter Extract Service Properties page, type CustomersExtract in Extract
service name. Click Next.
- On the Select an Optim Data
Source page, select the data source that contains your Optim sample data. Click Next.
- On the Select a Logical Data Model page, select OPTIMUSER.ldm.
Click Next.
- On the Select a Data Access Plan page, select Source
Plan. Click Next.
- On the Enter Extract Request Properties page, do the following:
- In Identifier, type OPTDEMO.
- In Name, type CustomersExt.
- In Server, use (Local).
- In Description, type Extract
customer data.
- Click Next.
- On the Enter Access Definition Properties page, type the
name of the DB alias for your data source in DB Alias,
and enter the ID for the data source in Creator ID.
Click Next.
- On the Enter Extract Process Properties and Options page,
type CustomersExtract.xf in Extract
file name and accept the default options. Click Next.
- On the Select Objects to Extract page, accept the defaults.
Click Next.
- On the Enter Group Selection Options page, accept the defaults.
Click Finish.
The new Optim interoperability
service, CustomersExtract, will appear under the Services folder.
The service will extract data defined in the source OPTIMUSER logical
data model and store it in the CustomersExtract.xf extract file. The
service will use the Source Plan data access plan to determine which
data to select from the OPTIMUSER logical data model.
