Groups Tab

The Groups Tab provides the ability to view, edit, and manage groups. You can combine related tables and transformations into a single unit called "group". When a group is synchronized, all the tables and transformations within it will be synchronized as part of the same job.

Some functions on this screen use icons. See the Icon Glossary for more information.

The groups list displays information about all the groups available. Below is a description of each column in the table:

More|Less Chevron - If a row has more information than the available display space, you can use the "more" and "less" chevron to expand/collapse the additional information.

Status - The status column will contain either a green success icon or a red error icon depending on whether the last time the transform was run was successful or resulted in an error. If the status shows an error, clicking on the "more" chevron will expand the row and display the error text.

Sync Type - Displays the type of synchronization that was performed the last time the group was ran. Possible types are Automatic, Full, Incremental, Incremental Only, Baseline, or Savepoint.

Start - Timestamp displaying the starting date and time of the most recent synchronization.

Duration - The duration in hours, minutes, and seconds (hh:mm:ss) of the most recent synchronization.

Edit - Clicking this button will take you to the Group Properties dialog where tables and transformations can be added to or removed from an existing group. See Adding and Editing Groups for more information.

Delete - Clicking the Delete button will remove the group from the list of available groups to sync. It will not delete the tables or transformations that are in the group. If the group is part of a schedule, the schedule must be deleted before the group can be deleted.

This button activates search fields for the Status and Group Name fields. To filter the results in the list of groups, enter a value in one or more of these search fields.

For example, entering the word EMPLOYEES in the Group Name search box will display only the tasks that have the word EMPLOYEES in Group Name.

To perform an on demand sync, select a table/s by clicking the selection checkbox next to the table/s you want to sync and press the Sync button. This starts the synchronization process on the selected tables. The view will switch to the Overview Summary Tab where you will be able to monitor the progress.

To perform this synchronization on a regular basis, you can create a schedule. To create a schedule, go to the Schedules tab. See Designing a Schedule for more information.

For more information about On Demand Synchronization, see Synchronizing Tables to Target Destination.

The refresh button refreshes the list of transforms.

Adding a Group will add a new group to the list of existing groups that can be synchronized. This button will take you to the Group Properties dialog where you will be able to specify which tables and/or transformations to add to the group. See Adding and Editing Groups for more information.