Skip to Content

Reference guide for Jitterbit App Builder

App Builder features

  • App Builder Lite Integration™: Easily leverage data from different sources without requiring ETL

  • Auditing: Configurable auditing available to track application changes

  • Data Import/Export: Supports the ability to import and export data from external sources

  • Batch Processes & Scheduling: Automate scheduled processes

  • Integration: Supports integration with any API or data source

  • Extensibility: Extend App Builder by connecting third party systems, leveraging plug-ins, or code if needed

  • Universal Development Language: Use our patented mvSQL to build logic and views of data

  • Low-Code IDE for App Development: No code required yet supports code if needed

  • Customizable App Theming: Full control over application look and feel

  • Responsive Design: Applications automatically respond to multiple devices

  • Workflow Automation: Implement and automate workflow business processes

  • Automatic Notifications: Configure workflow-triggered notifications

  • File Management: Upload, download, store, and display files

  • Multilingual Translation Engine: Translation service utility built into the framework

  • Integrated Debugging Engine: Developer access to log files and error messaging

  • Release Management: Integrated utility to package, deploy and install app across the lifecycle

  • Security: Built-in features to manage and maintain security

  • Full Access Control and Permission Management: Developer manages through the framework

  • Accessibility Support: WCAG 2.0 support, keyboard hotkeys allow navigation

  • Release Authentication: Supports industry-standard methods for recognizing and verifying users

Recently released features (2018 – 2023)

  • Table Wizard: Enhanced automation with workflows to build out tables in the Data Layer

  • Page Wizard: Streamlines and automates the process of adding pages to an app

  • Panel Wizard: Simplifies the process of adding a panel to a page

  • Control Wizard: Simplifies the process of adding a control to a page

  • Column Templates: App Builder learns the names, data types, and control settings as you build apps and reuses those setting

  • Live Designer: Brand new much-requested Live Designer feature

  • Design Center: Shortcut landing page for developers to rapidly build out and maintain apps

  • Styles: CSS stylizing of elements is elevated to the UI layer for simplified control over the look and feel

  • Enhanced Security Logs: Visibility into User password change and reset events

  • Security Provider Configuration: Now supports exporting, importing, and validation

  • App Builder Startup: Handles configuration on startup for License, Admin password and policy, Security Providers, and Sites

  • OpenID Connect (OIDC): Allow App Builder app users to log in using the OpenID Connect protocol

  • Group Control: New container provided for controls belonging in a logical grouping

  • Stacked Area Chart: An extension of a basic Area chart

  • Button Controls: Enhanced and simplified button options

  • Wizard Pages: Enhanced to include a progress bar, improved look and feel

  • Bitwise Operators: App Builder adds support for bitmask/flags and bitwise operators

  • Integrated Help: Quick access to Jitterbit Documentation, Release Notes, Community Forum

  • Temporary Tables: Supports in-memory storage of perishable fields

  • Enhanced Password Policy Options: Additional options available to strengthen security

  • App Diagrams: Network graph provides visualizations and insight about apps

  • Real-Time Language Translation Service: Translations service now runs in real-time

  • Updated Chart Library: Highcharts reporting engine upgraded to the current release

  • System Menu Toolbar: Provides quick navigation shortcuts to Users

  • Create New Application: Simplified workflow to build a new app from one screen

  • Auto-build Accelerators: Data Layer shortcuts to help automate app development

  • Expiring API Keys: Supports enhanced security with integrated APIs

  • Managed Tables: New table type to track data on User, Window or Session

  • Widget Inline Editing: App Builder now supports the ability to edit Widget files within native App Builder

  • Native Mobile Controls: New Controls support more granular handling over mobile display

  • App Builder Mobile App: Download and install the App Builder Mobile App, connect to existing App Builder apps

  • Mobile Push Notifications: Support for sending iOS and Android push notifications

  • Data Source Connection Wizard: New workflow to step through connecting a data source

  • Site Menu: Redesigned to provide an improved and customizable landing page

  • Visual Rule Builder: New logic editor featuring drag and drop and real-time results

  • Table Designer: Improved designer for creating and maintaining tables

  • Application Workbench: Centralized location provided for improved development experience

  • Page Wizard: New wizard process available to step through creating a page

  • Auto Build: New feature to rapidly build out baseline pages

  • Create Application Wizard: New wizard process to step through creating an application

  • Enhanced Menus: Menus can be driven by data objects, support icons, badges, and buttons

  • Network Graph Chart: New chart illustrates relationships between objects

  • Tabs and Accordion Options: New UI options to display/hide information within regions

  • ACE Editor: Robust and intelligent editing available for working with data objects

  • Customizable Help Text: Tooltips available for customization throughout the framework

  • Cross Data Source Table Inheritance: Inherit and extend data from distinct data sources

  • User Time Zone and Language Support: Automatically detect and persist user data

  • Bubble Charts: Chart used to represent three dimensions of data

  • JSON Integration with Charts: Customize defined aspects of chart appearance

  • Customizable Error Messages: Substitute error messaging for end users

  • Full Audit: Configurable audit to track application changes

  • Gantt Charts: Chart type used to plan and schedule projects

  • Secure Developer Silo: Partition off areas of framework for users

  • REST API Support: Integrate and extend an app with REST API (SNAPI)

  • iframe Embed Support: Display App Builder through an iframe

  • Password Expiration: Configure passwords to expire for users

  • Custom Login Screen: Override the default application login screen

  • Application Row-Level Security: Configure security access within an application

  • User-Defined Logical Data Types: Create custom Logical Data Types

  • Smart Validations and Auto-Fill: Enable validations and auto-fill for Logical Data Types

  • Reporting: Application reporting provides insights and auditing

  • Data Source Connection Support: Each release adds support for additional data sources

Systems

Native RDBMS

  • Azure SQL

  • DB2

  • DB2i

  • DB2z

  • Denodo

  • Microsoft SQL Server

  • Microsoft SQL Server PDW

  • MySQL

  • Netezza

  • Oracle

  • PostgreSQL

  • Redshift

  • SQLite

  • Teradata

CData ADO.NET

  • Active Directory

  • Airtable

  • Apache Hive

  • CosmosDB

  • DynamoDB

  • Dynamics

  • IMAP/Pop3

  • Facebook

  • Gmail

  • Google Analytics

  • Google BigQuery

  • Google Calendar

  • Google Contacts

  • Google Drive

  • Google Sheets

  • HubSpot

  • JIRA

  • Magento

  • Microsoft Access

  • Microsoft Exchange

  • Microsoft Office 365

  • Microsoft SharePoint

  • MongoDB

  • NetSuite

  • Office365

  • PayPal

  • QuickBase

  • QuickBooks

  • SAGE Intacct

  • Salesforce

  • SAP Concur

  • SAP ABAP

  • SAP ABAP over RFC

  • ServiceNow

  • Snowflake

  • Sybase

  • Twilio

  • Twitter

  • VeevaVault

  • ZohoCRM

REST & OData

  • Infor M3

  • Site configured REST

  • SuccessFactors

  • OData

  • See API repository: Some REST data sources App Builder has connected to for others

Other

  • File System

  • S3

  • SFTP

  • Azure Blob Storage

  • SharePoint as File System

  • Schema Browser

Security providers

  • JWT SSO

  • API Key

  • HTTP Basic Authentication

  • Integrated Windows Authentication

  • Web Access Management

  • HTTP

  • OData

  • RDBMS

  • SAP OData Services

  • SuccessFactors OData

  • Application Authentication

  • OAuth

  • Salesforce

  • SAML

  • WS-Federation

  • Active Directory

  • Local User

  • SuccessFactors Password

  • SAML Identity Provider

  • User Provisioning

  • Rewrite URL

  • OpenID Connect (OIDC)