Creating a distributed insert service

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