Creating an extract service

In this exercise, you will create an extract service based on the data specified in an access definition. Use an extract service to copy a set of related rows from one or more tables and save the rows to an extract file.

To create an extract service:

  1. Expand the Tutorial folder in the Directory Explorer, right-click Extract Services, and click New Service. The New Service wizard opens.
  2. On the Enter a Service Name and Select a Service Type page, do the following steps:
    1. In the Name field, enter SAMPLE.EXTRACT.
    2. In the list of service types, select Extract.
    3. Click Next.
  3. On the Select an Access Definition page, click Select an access definition. The page displays a list of access definitions.
  4. From the list, select SAMPLE.AD. Click Next.
  5. On the Enter a Target File Name page, enter SAMPLE_EXT in the Extract file name field.
  6. Click Finish.

The new extract service displayed in the Extract Service Editor. You can use this service to create an extract file for a convert, insert, or load service. You can also use the file to create a column map or table map.



Feedback