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.
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 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.
Group Name - This is the name group.
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.
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
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.
Sync button
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.
Refresh button
The refresh button refreshes the list of transforms.
Add a 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.