Groups Tab

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.

 

GroupsPage.bmp

  • 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.
      Expanded_error.bmp

    • 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.