Skip to Content

Design Studio basics


The Jitterbit Design Studio is entirely wizard-driven, taking you step by step through the creation of data mappings, connectivity and transformations. The Studio features automatic data mapping and enterprise connectors to make connectivity as easy as possible. Complex data models are supported including and dynamic schemas, as well as connecting to SOAP API, REST API and Cloud-based APIs such as the Salesforce Bulk API.

The user friendly graphical interface provides multiple tools for easy definition of complex business processes including predefined Formula Builder functions, enhanced scripting and validation tools, chained operations to be sequentially triggered by events in a prior operation, user defined local variables that run only in real-time operation of a specific process and pre-defined global variables that are defined throughout the entire project.

In the Design phase, you can test a query or other operation to make sure all components are valid. Or you can actually run the operation, which displays an operations monitor at the bottom of your screen to report start/end times and progress, number of records processed, and success or failure.

Every element you create in Studio is defined in a project. The project is deployed to an Environment to be stored, and is then managed by the Management Console.

You can navigate the Design Studio User Interface by using the following components:

  1. Design Studio interface: Learn about Design Studio's graphical interface.
  2. Main menu: Access most of the functionality provided by the system.
  3. Main toolbar: Fast access to commonly used functionality.
  4. Project tree: Organize and manipulate integration components.
  5. Transformation toolbar: Special functions used when creating transformations.