Difference between revisions of "Information Systems:Iptor Integrator"
| Line 41: | Line 41: | ||
Note: The license utility has a bug. It lists the wrong MAC addressses for the network card in the dropdown. So I licensed the wrong NIC on my machine initially. I've also switched machines multiple times now and don't really feel like requesting a new license each time, especially since I don't actually run Integrator on my machine (see Usage section). So I have a workaround, which involves overriding the MAC address on a virtual NIC. Wink wink, lol. -[[User:Norwinu|norwizzle]] ([[User talk:Norwinu|talk]]) |
Note: The license utility has a bug. It lists the wrong MAC addressses for the network card in the dropdown. So I licensed the wrong NIC on my machine initially. I've also switched machines multiple times now and don't really feel like requesting a new license each time, especially since I don't actually run Integrator on my machine (see Usage section). So I have a workaround, which involves overriding the MAC address on a virtual NIC. Wink wink, lol. -[[User:Norwinu|norwizzle]] ([[User talk:Norwinu|talk]]) |
||
| ⚫ | |||
| − | ==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. |
||
| − | |||
| − | |||
| ⚫ | |||
Revision as of 17:49, 18 March 2021
Overview
Iptor Integrator is software known as middleware, which is a suite of tools that faciliate building integrations - or programs that bridge different sytems. An integration might be a program that takes in a CSV file and writes it into a database. Middleware software usually contains various adapters to talk to different kinds of databases and information systems, as well as to communicate via different protocols (EDI, TCP/IP, ESB).
Integrator is Java-based, meaning that the programs you make with it are in Java, and the server software itself runs on the Java platform (e.g. Tomcat, class runner etc.).
History
Integrator was acquired in October 2019 for the DC1 project. However, it is system-agnostic and would provide good value used with other back-end business system or ERP. It most definitely can be used without ASW/DC1, and is actually more of a generic software than the brand (Iptor) would indicate.
Usage and Administration
Integrator Server
Integrator server runs on xtgui.unipharm.local, so both the server programs and developed code reside there. The web control panel is used for administration of Integrator jobs and functions.
Integrator Server Web Admin
Integrator comes with an admin control panel to control the jobs and to configure settings:
https://xtgui.unipharm.local:16999/admin/servlet/admin.AdminStart User: admin Password: visionit Note: A similar-looking web portal runs on this site on port 17999. This is the web admin control panel for the XT server (DC1 front-end). They are unrelated.
Important files and folders
- Source code - C:\Integrator\bin\classes
- Input/output files - C:\Integrator_Data\in and C:\Integrator_Data\out. Some of the sub-folders are watch folders.
Integrator Studio IDE
The IDE is used to make programs. Installing Integrator installs both the server software and the IDE.
License Information
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
Note: The license utility has a bug. It lists the wrong MAC addressses for the network card in the dropdown. So I licensed the wrong NIC on my machine initially. I've also switched machines multiple times now and don't really feel like requesting a new license each time, especially since I don't actually run Integrator on my machine (see Usage section). So I have a workaround, which involves overriding the MAC address on a virtual NIC. Wink wink, lol. -norwizzle (talk)