Using the EBI Studio tools, you can build and maintain objects that comprise your integration applications, including:
EBI 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.
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.
EBI 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.
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.
- 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.
- 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.
- 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 - 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.