Design-time Tools: EBI Studio

How You Use EBI Studio

EBI Studio is a set of utilities for IT professionals to easily create, test, and deploy an integration project from beginning to end.

Building and maintaining integration applications using EBI Studio is simpler, easier, and faster than conventional business application development, for three reasons:

  1. Planning integration projects is simpler, because you define your requirements using a small number of high-level integration object types.
  2. Building and maintaining integration applications is easier, because you build integration applications by combining configured integration objects, without programming.
  3. Delivering integration results is faster by accelerating many low-level, time-consuming manual specification tasks.

Building and maintaining integration applications revolves around a small set of design-time activities, as depicted in the life cycle diagram on this page. The sequence in which these activities can occur is flexible, not fixed.

image descriptionBusiness Integration Lifecycle

  1. Project Management: Creating a new project is as simple as adding a new folder to your workspace.
  2. Define Document Schemas: Projects that contain data transformations require document definitions ("schemas") for each transformation source and target. EBI Studio provides metadata importers that generate EDI, XML, and database schemas from imported document metadata, and metadata generators that produce flat file and spreadsheet schemas from data samples. You can also create and edit document schemas manually, using the Schema Editor.
  3. Create Transformation Maps: EBI Studio provides a flexible and efficient way to create maps. You create maps using drag-and-drop gestures, which generate text-based rules for readability.
  4. Configure Routes and Adapters: Route configuration encompasses communication and routing functions. To define communications with data sources and targets, EBI Studio supplies Adapter dialogs for both internal (applications, databases, files, services) and external (customers, suppliers, SaaS applications, industry hubs, etc.) resources. And for cases that require data-driven routing (e.g., matching EDI messages to message- or partner-specific processes), EBI Studio supplies editors that associate data envelope signatures with corresponding Business Processes.
  5. Model Business Processes: In the EXTOL Business Integrator object model, business processes are the primary components of integration applications. They aggregate and conditionally sequence the execution of Adapter, Transformation, and other runtime tasks. EBI Studio provides graphical tools for modeling business processes and configuring Events, Schedules, and other process activation objects. You can create simple business processes in seconds, and build larger, more powerful ones by composing or chaining smaller processes.
  6. Configure Mediations: Mediations are collections of built-in services for activating business processes and isolating them from environment dependencies. In addition to scheduling and event management, EBI includes mediation services for inbound and outbound EDI, web service consumer and provider integrations, event-driven change data capture for files and databases, message- and application-driven integrations, and custom combinations of the above.
  7. Test: EBI Studio includes a local runtime environment to support rapid iterative testing. You can test any business process by launching it manually, invoking it from another process or transformation, or by triggering a configured activation method (Schedule, Event, web service Consumer, File System Monitor, external Program). The EBI Studio Process Monitor and Auditor tools provide tracing and diagnosis support during the testing phase.
    To minimize changes when moving tested applications to production, you can set Global Variables to substitute local adapters, file paths, and other environment-specific application characteristics, at multiple points in your integration applications. And because EBI applications are portable, you can deploy your tested applications to staging or production systems on your choice of supported platforms.
  8. Deploy: EBI Studio contains an admin console providing you with the necessary tools to selectively deploy projects to Test and Production servers.

Monitoring your integration application

Once deployed, you can monitor and manage your integration applications using the included Auditor. The Auditor provides detailed analysis and drill-down inspection of process and task execution results, including data transformations.

Maintaining your integration application

The steps involved in maintaining your integration applications depend on the scope of changes or new requirements to which you must respond. Most maintenance cases involve isolated changes to document versions, data transformation rules, adapter configurations, and business processes. To implement those changes, you use the same highly automated tools that are available for building new integration applications. Additional tools support controlled application of changes to multiple objects at once.

Learn More

What EBI Studio Includes

EBI Studio includes graphical tools for the complete integration life cycle, from project provisioning through testing and deployment.

Using the EBI Studio tools, you can build and maintain objects that comprise your integration applications, including: image descriptionEBI Object Overview

  • Mediation objects that route, activate, and interact with business processes. Using EBI Studio, you can create meditations for inbound and outbound EDI, web services, change data capture, and other cases. Mediation objects include monitor objects for file system content, web service requests, and schedules, plus routing objects such as Inbound/Outbound EDI and Application Routes.
  • Process Automation objects that define and control business process execution. In addition to business processes, these include adapters, data transformations, document schemas, web service invocations, sub-process invocations, and email notifications.

As you build and maintain integration objects, EBI Studio retains your configurations in your workspace or SVN repository, where they can be maintained and reused. By substituting different adapter objects, you can build cloud, B2B, A2A, and data integration applications, using the same object model and EBI Studio tools.

EBI Studio includes a project explorer for your Workspace allowing for browsing, selecting, and editing integration objects. Each object type is associated with the configuration tool(s) needed to maintain it, so EBI Studio selects the right tool in each case, automatically.


Project Provisioning

EBI Studio includes tools for creating, generating, and maintaining Projects, plus tool launchers, navigators, and browsers for accessing and managing Projects and the objects they contain.

  • Project Explorer - A folder-oriented interface for organizing and sharing collections of integration objects by project, partner, interface, or other user-defined organizational scheme. image descriptionEBI Studio: Project Generator
  • Project Generator - Projects consist of inbound and outbound mediations that connect built-in services for routing, functional acknowledgment generation, and other functions. The Project Generator produces process frameworks that incorporate connections with these services, including process templates, document schemas, adapters, and other project deliverables. Learn More
  • Web Service Consumer and Provider Wizards - Web service providers are mediations that connect web service requests with EBI business processes that can access or update data, invoke applications or other web services, and transform request and / or response data. Web service consumers are generated processes that can be called from EBI business processes or transformations, to integrate web services for validation, method invocation, data publication or retrieval, and other purposes.
    Web service support is integral to EXTOL Business Integrator. The Web Service wizards generate Consumer and Provider processes for both SOAP and REST, WSDLs for web service provider publication, plus business processes and task objects for connecting web services, EBI business processes, and data transformations.
  • File Monitors - File Monitors are server objects that automate change data capture processing for file system content. File Monitors identify directories to monitor, polling frequency, file name signature filters, and file renaming, archiving, and collision actions. It optionally generates an Event object for activation of a corresponding business process.


Document Definition

To support the transformation of XML, EDI, database, flat file, and spreadsheet data, EBI Studio provides tools and Design-time accelerators for creating and maintaining document definitions ("schemas") that are used for mapping source data to target data.

  • Schema Editor - Creates, customizes, and maintains structure, attributes, and typing for documents and document elements used in transformation mapping. image descriptionSchema Wizard
  • Metadata-driven schema generation - EBI Studio includes a complete set of metadata accelerators that generate error-free document schemas in a fraction of the time needed to define them manually.
    • Database metadata importer: Generates document schemas from imported database catalog metadata, including multi-table views, without DBA involvement.
    • EDI metadata importer: Generates EDI document schemas from EDI standards metadata.
    • Flat file schema wizard: Generates document schemas from flat file sample data, including fixed format, delimited, and complex, multi-format files.
    • Spreadsheet schema wizard: Generates document schemas from spreadsheet sample data, including complex, multi-section worksheets and multi-worksheet workbooks.
    • XML metadata importers: Generate document schemas from standard XML DTDs, XSDs (XML schema), and WSDLs (for web service Consumers).
    • IDoc metadata importer: Generates flat file document schemas from SAP IDoc parser file metadata. Available with the adapter for SAP option.
    • Oracle EC Gateway metadata importer: Generates document schemas from Oracle EC Gateway metadata. (Note: Oracle XML Gateway metadata is supported by the XML schema importer, above). Available with the adapter for Oracle E-Business Suite option.


Data Transformation Mapping

EBI Studio includes industry-leading tools for data transformation mapping and maintenance, including the ability to update a database based on source or user-defined constant data.

  • Transformation Ruleset Editor - A graphical mapping utility that generates mapping rules from drag-and-drop actions, for transforming, validating, enriching, routing, caching, and aggregating data. image descriptionRuleset Editor
    • The Transformation Ruleset Editor also allows you to copy rules between rulesets while maintaining the rule structure/linking if the source and target nodes are compatible.
    • Open any external object to update from directly within the editor. Designed to save time when modifications to schemas or formulas, for example, are needed.
    • Access all of the details of the ruleset and rules in one convenient tab-based pane.
    • Quickly identify compatible data types with the color/shape identifiers used in the source, target and update schemas.
  • Schema Replacement - When changes occur to source or target data descriptions, called schemas, in place replacement functionality allows you to replace the old schema with the new one and automatically re-establishes the mapping rules based on the schema element names. When same syntax changes occur, mapping maintenance times can be drastically reduced.
  • Mapping Actions - Access to over 100 pre-defined mapping actions providing capabilities to perform calculations, manipulate string data, apply logical operations and more. Actions defined in your workspace, such as business process scripts, code tables and java programs can be easily accessed from within the mapping actions pane. Included is the ability to create an action from within the ruleset editor.
  • Ruleset Data Object - A mapping object that allows you to create variables and constants once to share among all maps. You can also create multiple Ruleset Data Objects specific to a data type or transformation flow.


Adapter and Routing Configuration

EBI Studio includes a variety of editors for creating adapters, monitors, and routing objects that connect integration processes and tasks with internal endpoints (files, databases, applications, services) and external endpoints (customers, suppliers, cloud applications, industry hubs, etc.).

  • Adapters - Template-driven dialogs that generate configured adapter objects for the following resource types:
    • Database - Configure Select, Insert, Update, and Delete adapters for DBMSs with JDBC 2.1 or newer driver, including Microsoft SQL Server, IBM DB2, Oracle Database, and MySQL.
    • File System - Configure Read, Write, Copy and Move adapters for file systems on all platforms supported by EXTOL Business Integrator.
    • File Monitor - Configure monitors to "listen" for files in a specified directory for a user-specified amount of time based on file name.
    • Secure FTP - Configure GET/MGET, PUT/MPUT, plus tunneled file system commands for standard FTP file transfer, with support for SSL and SSH.
    • AS2 (requires optional EXTOL Secure Exchange) - Configure adapters and processes that connect with external partners using the standard secure AS2 protocol.
    • EXTOL VAN (requires EXTOL Secure Exchange and EXTOL VAN options) - Configure adapters that connect with external partners using the EXTOL VAN. image descriptionWeb Services
    • Web Services - Generate standard SOAP and REST web service Providers and Consumers, for integration with internal applications, SaaS applications, and external partners.
  • Route Editor - A template-driven dialog for creating and maintaining document routing information. Routes are used at run-time for automated routing of inbound and outbound EDI transaction data and non-EDI application data. They also externalize route-to-business process associations in order to support many-to-many routing. Routes can be organized in hierarchies - for example, partners under document types, or document types under partners - you can automate processing at any of the levels.
  • Project Generator - Generates partner routes and associated objects, such as transformation maps and envelopers from sample partner interchange data. The Project Generator saves both time and potential errors by automating configuration that can be painstaking and tedious when performed manually. Learn More
  • EXTOL Application Integrators (Optional) - These optional packages include metadata-driven document schema generators for application-side document types, plus customizable integration applications for Order-to-Cash, Load Tender-to-Delivery, and other common transaction cycles.


Business Process Diagram image descriptionBusiness Process Modeler

  • Business Process Diagram - A graphical, drag-and-drop modeler for creating and maintaining business process specifications. Creates and extends process models by dragging task objects (transformations, adapters, notifications, etc.) onto a diagram canvas, and specifying runtime sequencing and communications using process and data flow connectors.

    The process modeler maintains separate connector types for task success path, task failure path, and data path. The display for each connector type can be toggled independently, to allow for isolated specification analysis.

    Adapter and Transformation editors and Modeler sessions for sub-processes can be opened directly from the context of the Process Modeler. These in-context updates are reflected in the containing Process Model when task object updates are saved.
  • Business Process Editor - A tabular editor for business processes, for users who prefer tabular specification to diagram-based specification.
  • Event Manager - A template-driven dialog for creating and maintaining Event objects that route event notifications (from adapters, processes, and external programs) to corresponding business processes.
  • Schedule Manager - A calendar-driven configurator for specifying automated date/time, elapsed, and recurring process activations.



  • Process Monitor - An interactive viewer for monitoring the execution of business processes.
  • Auditor - An interactive log data viewer for filtered tracking and inspection of business process execution results, including:
    • Process- and task-level stoplighting for rapid identification of failures and warnings
    • Identification of runtime errors and error states, including inspection of transformation input and output data
    • Configurable log filtering for selection of processes that meet specified criteria



  • Deploy/Un-Deploy Utilities - Sends, validates, and deploys integration projects to server nodes. The deployment process automatically analyzes dependencies (internal and external) to your project and includes all dependent projects.
  • EXTOL Server Utilities - A set of tools for pausing, resuming, and starting EXTOL Business Integrator runtime services.


Learn More

What You Need to Run It

EBI Studio is available on multiple platforms with identical functionality - giving you freedom of platform choice and insurance against future platform changes. Regardless of the platform you choose, you can deploy the integration applications you build to any platform supported by EXTOL Business Integrator.

The table below shows the system requirements for EBI Studio.

EBI Studio (Design-time) System Requirements:

Operating Systems Windows, Mac

(See EXTOL Policy on Operating System Support for Java-Based Products for more details.)

Memory 4 GB or greater

Disk space Minimum 2 GB plus storage

Display 1280 x 1024 resolution

NOTE: The specifics of your Implementation may require more resources than outlined here. Consult EXTOL Technical Support for more information.

Learn More