> > > EBI / Clarify

Clarify / EBI Skill Set

Background of EXTOL Business Integrator:

In April of 2016 Cleo Communications purchased EXTOL International. At the time the flagship Any-to-Any translator was named EXTOL Business Integrator. Cleo re-branded the product to Cleo Clarify.
All the functionally that users are accustomed to was preserved and will be enhanced over time under the Cleo product line.

Cleo Clarify (EBI):

Versions: 2.2, 2.2.1, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 4.1, 4.3, 4.4, 4.6
Platforms: Windows, iSeries, Linux (Red Hat and Ubuntu)
Cloud Support: Amazon Web Services
Skill Set:Rulesets, business processes, schemas(X12 EDI, database, XML, flat files, iDoc), collaborations, end points, dashboard, system monitoring, webservices - SOAP/REST, diagnosing issues.

Cleo Clarify Examples:

Conversion Manager: Convert small projects (4 trading partners) to large projects (180 trading partners)
Project Generator: Build EDI, Flat-File, XML, Spreadsheet Eclipse Projects to be used as templates for Clarify Project Generator.
Version 1 and 2: Document and display differences between Version 2 objects (Cleo Clarify 4.6+). Objects such as Ruleset, Business Process, SQL Actions, Applications Interfaces,

Real Life EBI Examples:

EDI Grouping: Applied to identify groups like data to create outbound EDI 810/856 transactions. To implement an outbound EDI 810 we grouped header, notes and detail records together in a ruleset. Note: routing is done in a schema or in a ruleset.
Project Builder: Used feature to visually display business process. Great for a starting a project that includes inbound/outbound adapters, a transformation process, schemas, and ruleset.
Spreadsheet Wizard: As orders are received a spreadsheet was emailed to the respective CSR. The spreadsheet assisted the CSR in creating the orders and needed edits. Ie. pallet counts.
Schema Migration: Migrate different schemas with varying differences. This came in handy when we needed to use the same database schema (source schema) for varying flatfile schemas (target schema). By using the Schema Migration Tool, we reduced the development time.
Database triggers: Trigger applied to iSeries DB2 files, with JAVA shell program, to have EBI business process script executed. The API call, to EBI, is based upon certain criteria.
Web Services: Create REST HTTPs Providers/Consumers to interact with State Bank, NJ. Set-up unique parameters and headers to route payload to the correct business process script.
Web Services: Create multiple EXTOL Business Process Scripts to receive SOAP request (Provider). Once request was received, webservice BPS (Consumer) was called to retrieve requested data from SAP (Provider) SOAP Webservice.
Email notifications I: Email rules were applied in the ruleset and/or business process to notify end users that specific company data was received.
Email notifications II: Email rules were applied in the ruleset and business process to notify end users that trading partner store number was not available at the time of EDI generation.
SQL business process tasks: Used SQL tasks in business process to update global status table to indicate status of specific document.
SQL select: SQL select action was applied in ruleset to retrieve internal company ship-to number for inbound 850 (purchase order)
SQL select: SQL select action was applied in ruleset to retrieve internal company ship-to number for inbound 850 (purchase order)
SQL insert: As errors are encountered in ruleset, create customized error messages to be populated in error table. This table can be monitored by IT/CSRs.
Record updating: When processing outbound JD Edwards documents, certain field(s) need to be updated to reflect the record has been processed. Using the middle tree of the ruleset we are able to update the record of the respective outbound transaction.
SQL procedure: SQL procedure was created in iSeries DB2 file: QSYS2/SYSROUTINE. EBI SQL action is called from ruleset to trigger iSeries CL.
Ruleset: Created countless rulesets to interface with XML docs, database tables, flatfiles, and EDI data.
Schemas: Imported/created many schemas to interface with application data. Some schemas were unique to handle special circumstances.
SAP interface I: Imported/created SAP iDoc schemas. In addition to interface with application data. Some schemas were unique to handle special circumstances.
SAP interface II: Created inbound/outbound 850s, inbound/outbound 810s/880s, inbound 820, inbound/outbound 856 iDoc rulesets and application analysis rulesets.
EBI Archiving/Backup: Setup online and offline backups to allow for periodic archiving/purging.
Brand new installs: Numerous brand new installs for new EBI customers.
Upgrade: Assist in upgrading to EBI from versions 2.1, 2.4, 2.5, 2.6, 3, 4.4, 4.6
Set-up of batch maintenance jobs: Use EBI's job scheduler to run weekly purges and weekly back-ups.
Dashboard 2.1:Install, set-up, maintain Dashboard 2.1 on Windows and Linux OS.
Job Scheduling:Set-up, maintain job scheduler entries in EBI.
Cleo Log Warehouse (CLW):Set-up, configure, debug log warehouse.


By: on
EXTOL Business Partner Logo

More information about us!

Part of the learning process of EXTOL is learning about qualified experts in the industry. Check out our job history, newsletter, and resume.

Please feel free to contact us for a a free consultation.