Creating a distributed extract service

You can use the New Extract Service wizard to create a distributed extract service.

An extract service copies a set of related rows from one or more tables and stores this data in an extract file. The extract service always includes the definitions for tables and columns. You can also choose to extract object definitions, including primary keys, relationships, and indexes. An extract service request specifies an access definition to define the data to extract and the parameters needed to run the extract process.

A extract service requires an Optim™ logical data model to provide the source data.

To create an extract service:
  1. From the Data Project Explorer, right-click the Services folder and click New > Distributed Service > Distributed Extract. The New Extract Service wizard opens.
  2. Complete the steps of the wizard.

    You must enter a name for the service and select an Optim data source, Optim logical data model, and data access plan.

    You must also provide a name for the extract file, specify options for the extract process, and select objects to extract.