You can use the New Insert Service wizard to create a distributed
insert service.
An insert service copies data from a source file into specified
destination tables. An insert service request specifies a source file
containing the data you want to insert or update and the parameters
needed to run the process.
An insert service requires an Optim™ logical data model to provide
a map to the source data.
To create an insert service:
- From the Data Project Explorer, right-click the Services folder,
and click . The New Insert Service wizard opens.
- Complete the steps of the wizard.
You must
enter a name for the service and select the Optim data source, logical data model, and
data access plan used to create the source file.
You must also
provide names for the source and control files, and specify options
for the insert process.