The Groups Tab provides the ability to view, edit and manage groups. Groups provides the ability to combine related tables and transformations into a single unit called a 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. The description of these icons will have a hyperlink to the Glossary of Icons which contains a picture of the icon and an explanation of its purpose.
Groups
List
The groups list displays information about all the groups available.
Below is a description of each column in the table:
More|Less Chevron
If more information is present for a row than can be displayed,
clicking the more chevron
will expand the row. Clicking the less
chevron will collapse the information. Below is an
example of a row that contains an error message. The more chevron has been clicked
to display 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 group
has never been synchronized, the column will be blank. If
the status shows an error, clicking on the more
chevron will expand the row and display the error text.
Group
Name
This is the name of the group that was specified when the group
was created.
Sync
Type
Displays the type (Automatic, Full, Incremental or Incremental
Only) of synchronization from the last time this table was synchronized.
Start
Timestamp displaying the starting date and time from the most recent
synchronization.
Duration
The duration in hours, minutes and seconds (hh:mm:ss) from the
most recent synchronization
Rows
Number of rows affected by the operation
Inserted
Number of rows inserted by the operation
Updated
Number of rows updated by the operation
Deleted
Number of rows deleted by the operation
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.
Search
Filter
Pressing 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 cause only those groups that have the
word EMPLOYEES in the Group Name
to be displayed.
Sync
button
To perform an on demand sync,
select a table or tables by clicking the selection checkbox next to
the table or tables you want to sync. Once your selection has
been made, press the Sync button. This will start the synchronization
process on the selected tables. The view will switch to the
Overview
Summary Page 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 Schedule
tab to establish the timing of the synchronization. See To
schedule a synchronization task for more information.
For more information about On Demand Synchronization, see Synchronizing
Groups to Target Destination.
Refresh
button
The refresh button refreshes the list of groups.
Add
Group button
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.