Collect: The Fetch Process

Collect is the main tool within the DSP that extracts, or moves, data from one source of data to another. The basic process is as follows:

1. A user specifies a target that will receive the data.
2. A corresponding source is chosen as the origin of the data.
3. Within the source, a user adds a table name with which to make the data extraction.
4. A data package is built and data is uploaded into the new table in the target. This is then repeated for each table required in the target.

This process may be sufficient for a handful of tables, but what if there were hundreds of tables? Fortunately, there is a way to not only capture all tables from within a source, but also to customize the selection of which tables should actually be extracted. This process is called the 'fetch' process.

Once a source is established for a target in Collect, a user can fetch all or a specified group of tables.

1. Access the vertical view of the Source.
2. Select the Action tab.
3. Click Fetch Tables. At this point a new group is created in the system types. It is assumed that a System Type is already set up for use in the source. Close the vertical view once finished.
4. Navigate to Common > System Types.
5. Find the System Type used in the source from Collect. Click Groups.
6. While viewing Groups, the dependency pane shows all possible tables within that source database. Clicking the 'Active' checkbox for a table name will select only those tables relevant for extraction in the group.
7. Navigate back to Collect and select the appropriate Target.
8. At the Source level, click Import Group Tables. This will place all the tables selected in step 6 in the list of tables in the Source.
9. Click Build and Refresh on the Source toolbar. This will build all packages and refresh all tables that were imported from the group.

BackOffice Associates offers professional, instructor-led training in an interactive hands-on style. To view the latest schedule of classes currently offered, visit http://www.boaweb.com/company/product-training/