Skip to end of metadata
Go to start of metadata

Introduction

On transformation screens, Jitterbit Harmony Design Studio provides two transformation toolbars, one in the transformation titlebar and another at the bottom of the transformation screen. The tools and their respective functions are described in the tables below.

Titlebar Toolbar

Button

Name

Description

Status

Displays the status of the transformation.

Additional commandsDisplays a menu of commands to Save, Close Page, Close Other Pages, Locate in Tree, Additional Details, View XML, View Input JTR, and View Output JTR.

Dependent objectsLists the dependent objects in the transformation.

Save active pageSaves the active page of the transformation.

DeployDeploys the project to Jitterbit Harmony.

MigrateMigrates the transformation to a new enviroment. 

Load Sample Source Data

Loads sample source data into the transformation.

Test the Transformation

Tests and validates the transformation currently open.

Test Operation

Tests an operation that uses the transformation.

Automap

Jitterbit tries to automatically map source data nodes to target data nodes.

RefreshRefreshes the transformation source and target structures.

Transformation ToolkitDisplays a menu of additional transformation commands., described below.

Find and ReplaceFinds nodes in the Source Tress and the Target Tree, and replaces mappings in scripts. 

HelpDisplays Success Central, the online documentationsite. 

CloseCloses the transformation screen.

Transformation Toolkit menus

Command

Description

Load Source DataLoad sample source data into the transformation.
Test TransformationTest the transformation with the source data.
Test OperationTest the operation using the transformation.
Show Only DataTest an operation using the current transformation.
View Source DataView the file loaded into the source tree.
View Target FileView the file loaded into the target tree.
Remove Test DataRemove test data from the mapping tree.
EditDisplay these commands:
  • Edit Source Structure: Edit the source structure used in the transformation.
  • Edit Target Structure: Edit the target structure used in the transformation.
  • Edit WHERE Clause: Edit the WHERE clause used in retrieving the source data from the dataset.
  • Edit Update Keys: Edit the update keys used in the database target..
MigrateMigrate the active transformation to another transformation.
ImportImport Mappings or Import Renamed Mappings.
ExportDisplay the Export Mappings or Export Renamed Mappings.
Hide Unmapped NodesHide unmapped nodes in the source tree or the target tree. 
Simple Node DisplayToggle display of nodes in the source tree or target tree without the type (String, Identifier, etc.).
Simple XML Element DisplayToggle display of nodes in the source tree or target tree crated from xml data.
Map Area SettingsToggle display of attributes, generators, and errors in the mappings, and hide or show all of these.
Create OperationCreate a new operation based on the current transformation.
Convert to Text DocumentConvert the source or target structures to a text document.
XML Node Expansion Mode(available on if source or target data is XML)Determine how the mapping structures for XML sources or targets are loaded into the trees. Because XML structures can be highly complex, loading a complete structure into the mapping tree can slow performance. When you choose Minimal, the default setting, the tree is created one level at a time when you expand a folder node for the first time, which results in better performance. If you choose Normal, all tree levels are created when you expand a folder node.
Display Mode

Select preferred display mode: Multi-Tabs, Tabs, Single Card, or Floating.

Bottom Toolbar

Button

Name

Description

Expand-Collapse

The expand and collapse buttons expand or collapse the trees to aid in finding data elements quickly. The icon on the left end of the transformation toolbar controls the source pane, and the control on the right end controls the target pane.

Options for Hiding Nodes

Options for hiding nodes appears on the left (source) and right (target) trees.

Options include:

  •   Hide Unmapped Nodes
  •   Show Data Nodes Only
  •   Simple Node Display
    • Simple XML Element Display


Load Sample Source Data

Load sample source data into the transformation.

Test the Transformation

Test and validate the transformation currently open.

Test Operation

Test an operation that uses the transformation current;y open.

Zoom In

Increase the size of the text displayed in the trees.

Zoom Out

Decrease the size of the text displayed in the trees.

Map Elements

Map a source data element to a target data element. When both are selected, this icon activates and will perform the mapping when clicked. This icon becomes enabled if both a source and a target data element have been selected. Clicking it saves the mapped relationship associated with the selected elements, and adds this relationship to the frame beneath the Transformation toolbar.

Create Formula

This button is enabled if a mapped relationship has been selected. Clicking it launches the Formula Builder and loads the value of the source data element.

Automap

Jitterbit tries to automatically map source data nodes to target data nodes.

Context Menus

In addition to the icons on the Transformation screen, some items in the transformation have context menus displayed when you right-click on the item. Right-click on an item to see the context menu or action.

Item

Context Menu or Action

Top-Level Source Folder

Displays Copy node name to clipboard or Edit Source Structure so you can edit the source structure used in this transformation.

Source Sub-folder (other than root)

Displays Copy node name to clipboard or define batch transformation commands. A batch transformation reads entire source into memory and performs the transformation in memory.

Top-Level Target Folder

Displays Copy node name to clipboard, Edit Target Structure, Add script, and Clear the mappings under this folder commands.

Target Sub-folder

Displays Copy node name to clipboard, Add condition, Create extra folder for mappings, and Clear the mappings under this folder commands.

Target Node

Displays the Copy field name and Delete mapping of this node commands.

On This Page

Last updated:  Aug 26, 2019