Information Systems:Gilead Sales Report - Old

From uniWIKI
Revision as of 11:29, 16 May 2017 by Norwinu (talk | contribs) (Created page with "=Overview= Gilead requires daily sales and inventory reporting from uniPHARM, so a solution needed to be developed to generate and transmit such reports according to their spe...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Overview

Gilead requires daily sales and inventory reporting from uniPHARM, so a solution needed to be developed to generate and transmit such reports according to their specifications. This endeavor was a greenfield project of sorts, in that it was developed from scratch and comprised new techniques, all of which will be discussed here. This article represents the documentation for this solution.

Components of the solution

The components are as follows:

  • NC_GILREP.PGM: A non-CGI WebSmart-generated RPG program.
  • GILSUMFTP: A CL program that calls all the other programs.
  • GILEADREP: Job scheduler entry that calls GILSUMFTP.
  • sFTP utility in PASE on IBM i.
  • IFS on the IBM i to store report files for transmission and archiving.

NC_GILREP

In its essence, WebSmart is an RPG translator of sorts, so it is possible to create powerful RPG batch programs in WebSmart i.e. using WebSmart's PML (language) and IDE (graphical editor). In WebSmart, creating such a batch program is done by compiling the program as non-CGI (hence the prefix in NC_GILREP). When compiled as a non-CGI, the program is no different than any other RPG batch program - there is no interface (web or green screen); it simply gets called and does its input/output over files and streams.


sFTP Transmission

Gilead is using the data/analytics provider ValueCentric to receive its info from us.

Key pair

Report Files

Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Gilead_Sales_Report_-_Old&oldid=8115"