Menu
Menu
Technical summary, benefits, deliverables.
EnableTRANS is Enablecore’s Application Automation Framework for ETL (Extract, Transform, Load) and Workflow Execution and is the underlying engine for all automated processing within our solutions and development projects
Each EnableTRANS Workflow Package can have any number of ‘Instances’ allowing for runs with unique parameters, endpoints, templates, schedules, providing for ultimate flexibility in building execution paths.
EnableTRANS provides installable of Windows Service declaration files that allow clients to define the Service Name, Job and fluent schedule. Each Job represents the selection an Instances Options collection. The EnableTRANS
Supervisor can watch the status of Service Jobs and restart a given service if it becomes unresponsive.
An EnableTRANS Decorator is a framework script that acts as a transformation and validation step, acting on Arguments and Options and generating defined log messages. Highly expressive Decorators extensible to add or delete records based on expressions, as well as job control, such as skipping the execution of a job and/or ending a batch.
EnableTRANS has an extensive logging framework allowing for both Global or Package-level log settings and for workflows triggered manually or by a service. Logs also report on generic system and service execution as well as self-logging the logging subsystem. EnableCARE clients can elect to have Enablecore monitor emailed logs to provide for high operational uptimes.
Existing clients typically employ EnableTRANS for the following workflows:
Many clients employ 3rd-party mobile DSD or Field Order solutions and are required to regularly supply master data such as; Customer, Ship To, Category, Item and Qty data. EnableTRANS can run batch workflows to supply all the required lookup databases in a single execution, delivered in any file format to FTP, FTP/S and SFTP end-points with support for public / private key authentication.
EnableTRANS provides for full logging of these Master Data extractions and delivery and would email a log for any errors.
Organizations typically have several major silos of data, such as ERP, CRM, MES, QA, Catalog systems, etc. While a number of applications may have native integration to the host ERP, many other supporting solutions may not, or, lack the required robustness. EnableTRANS can provide for the required inter-app integration via customized workflows run as scheduled Windows Services.
Scheduled service can run on Workdays only, between certain hours, or on an explicit scheduled day(s) and times.
Most Webcarts and Marketplaces will provide for the delivery of Orders, Invoices, Credits, etc., in either Flat or Hierarchical files in various formats, typically CSV and/or XML. EnableTRANS can reach out to FTP/FTPS/SFTP endpoints to download these payloads and on-board to either a network folder or Enablecore’s Nexus transaction queue (QBrowser). The EnableTRANS On-Boarding workflow will typically be engaged to validate and decorate the transactional data. Any identified error can be placed inline to the transaction, and/or communicated via email.
On-boarded payload files may carry more than 1 transaction document as well as sometimes different transaction types. EnableTRANS can isolate different transaction types within the payload and split the raw payload into its constituent number of embedded transaction documents.
While EnableTRANS is not a traditional EDI translator reading and writing ANSI X12 EDI files, it is regularly used to exchange files between clients and their managed EDI service provider, and/or exchange transactions to partners who have their own portal. These exchanges encompass upload/download, translation, validation and template steps. Exchanged transactions are typically in hierarchical CSV or XML files.
EnableTRANS will typically be a more cost effective framework to achieve these workflows and deliver a more integrated solution end-to-end.
Within Enablecore’s ‘Nexus’ solution, EnableTRANS is used to merge many Physical Inventory Counts into a single count per Location and do a pre-validation before attempting to import into the Sage 300 worksheet. This procedure will split out counted data to Valid and Invalid files, allowing the valid files to be imported and highlight the invalid data within a spreadsheet to be resolved.
This process both streamlines and speeds the reconciliation, while completing the complex isolation of errors.
EnableTRANS is used by clients to execute persistent Windows Services that extract from data sources, typically MS SQL, and then filter, template, send and log emails. Sage 300 users can select settings within the Nexus Host Interfaces for Sage 300 OE to create unique instances for different email workflows. Prebuilt EnableTRANS Email packages are for order-related events such as Confirmation, Shipment and Invoice, but also includes an Order Action to Spreadsheet export to be emailed to Salesreps and/or client. Email workflows contain a Test/Production mode flag, execution guards to protect against errant sends, logging to protect against duplicate, and email address validation.
Most clients who have implemented one of the base order-related Email workflows, have extended its use to encompass other data triggered emails.
EnableTRANS is a .NET C# script framework using highly declarative assets to achieve workflow automations. EnableTRANS caches dynamically compiled ‘workflow packages’ providing the speed of compiled programs and the declarative flexibility of scripts.
EnableTRANS core functionality includes:
We invite you to contact us today to discuss how Enablecore can ‘enable’ your organization’s operational processes.
Leading and provisioning strategic IT projects for inventory-based enterprises.
800-15355 24 Ave, Suite 227, Surrey, BC, V4A 5A4
1-604-270-1020
info@enablecore.com