Information Systems:Iptor Integrator

Overview

Iptor Integrator is software known as middleware, or "ESB". It is used for creating integrations in Java to ASW/DC1. Integrator was acquired in October 2019 for the DC1 project.

Administration

Integrator is installed on the xtgui.unipharm.local virtual server. There are two components, the service component that runs the tasks and an IDE called Design Studio for creating Integrator programs.

License

Integrator is licensed by network adapter (MAC address). uniPHARM's license entitles us to one production server instance and one development workstation - essentially two licenses. The licenses are as follows:

UniPharm server:
Serial Key:         2019-1101-2021-0131
MAC Address:  00-50-56-92-5e-c5 (virtual NIC on xtgui.unipharm.local)
Expiry Date:      January 31, 2021
---------------------------------------------------------
UniPharm Workstation:
Serial Key:         2019-1101-2021-0131
MAC Address:  00-ff-dd-3e-fc-f9 (Norwin's USB ethernet adapter)
Expiry Date:      January 31, 2021

Potential migrations

The following extensions/integrations (currently in legacy RPG/CL) may be moved to Integrator.

• System checks / process monitors: Email alerts for periodic checks on system function and business continuity.
• Carrier integration: send shipping manifest to carriers, receive acknowledgements/shipping updates/invoice files from carriers.
• EDI: Build EDI/csv documents from purchase order data; receive EDI/csv documents from EDI provider and update ERP.
• Bank EDI: generate EFT payment file from statement information, process inbound credit card transaction summary files and post to A/R, process inbound cheque-clearing file.
• Periodically-generated reports: Gilead daily transactions report, Health Canada MAR, lost sales.
• SQL data-warehousing, including offload/ETL into open-source database.
• Update lost sales codes.
• Update P/O delivery ETA, send emails.
• File rebuilds: consolidated item master, web orders item master, stats file i.e. run SQL in Java, write to Db2 on i.
• Inbound order processing: receive EDI/txt files from pharmacies (either polled via FTP, polled via email inbox, or by watching folders for new files). Send electronic invoices via FTP.
• ECU: generate catalog for customer/pharmacy POS systems (e.g. Kroll, WinRx etc.)
• Generate remittance advices, distribute via email or write back to OUTQ for Catapult/TLAshford processing.
• System cleanup functions in the overnight schedule and in purge jobs: clear outqueues, prune tables.