The Transformations Tab provides the ability to view, edit and manage transformations.
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.
Transformations
List
The transformations list displays summary information about all defined
transformations. 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.
Selection
Checkbox
Click the checkbox next to each row you wish to do an operation
against. The row selection checkbox applies to the Duplicate,
Import, Export and Sync functions
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 transform
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.
Transformation
Name
This is the name of the transformation that was specified when
the transformation was created.
Target
Table
Displays the three part name consisting of:
Database
Owner
Table name
Sync
Type
Displays the type (Automatic, Full, Incremental, Incremental Only,
Baseline or Savepoint) of synchronization
from the last time this transformation was run.
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 stepper used when creating a transformation.
When editing a transformation, all fields will be filled
in with current values. Unlike the creation process where
each step must be completed in order, when editing it is possible
to jump to the specific step you wish to edit. To jump to
a step, click on the step number that is displayed at the top
of the stepper. Depending on which fields are edited, you
may be required to complete all subsequent steps before saving
changes. For example, if the source table is changed it
will be necessary complete all subsequent steps. In this
case, the stepper will not allow you to jump forward once this
change as been made. Instead, you will need to use the Next
button as you would when creating a new transformation.
Delete
Clicking the Delete button will remove
the transformation from the list of available transformations
to sync. It will not delete the Destination Target Table (if it
exists). If the transformation is part of a schedule, the schedule
must be deleted before the transformation can be deleted.
Duplicate
To create a duplicate of a transformation, click the selection
checkbox for the transformations to be duplicated and then click the
duplicate button. This
feature is useful in circumstances where you have a transformation
with complex SQL as the source and you want to create a second transformation
that does the same thing but writes the data to a different database.
For each transformation selected, a copy will be created with
_Copy_x appended to the name where x represents a unique number for
the copy. For example, if the transform TestTransform1
is duplicated, the new transform name will be TestTransform1_Copy_1.
The duplicate transform will be created with a target table
that has _Copy_x appended to the name. You may need to edit
the new transform and adjust the target table name to the suit your
needs.
Import
and Export
Transformations can be moved from one environment (i.e. development),
to another environment (i.e. production) with Export and Import. One
or multiple transformations can be exported/imported to/from a single
file. In the first environment, check the desired transformations
to move and press Export, then specify a file name and that file will
be downloaded to the machine logged into the DataSync Administrator.
Then a connection can be made to the second environment, when
Import is pressed, specify the file that was downloaded and those
transformations will be put into DataSync.
Search
Filter
Pressing this button activates search fields for the Status, Transformation
Name and Target Table fields. To filter the results in the list
of transformations, enter a value in one or more of these search fields.
For example, entering the word EMPLOYEES in the Transformation
Name search box will cause only those transformations that
have the word EMPLOYEES in the Transformation
Name to be displayed.
Sync
button
To perform an on demand sync,
select the transformation(s) by clicking the selection checkbox next
to the transformation(s) you want to sync. Once your selection
has been made, press the Sync button. This will start the synchronization
process on the selected transforms. 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
Transformations to Target Destination.
Refresh
button
The refresh button refreshes the list of transforms.
Add
Transformation button
Adding a Transform will add a new Transform to the list of existing
Transforms that can be synchronized. This button will take you
to the Transformation Creating Stepper where you will be guided through
each step of creating a transform. The steps are:
Select a Transform Name
Choose a Transform Source
Choose a Destination Target
Choose a Sync Type
Set Column Mapping
Check Indexes
For more information on creating transformations, see Creating
a Transformation in the "Designing a Transformation".
section