Information Systems:Gilead Sales Report

The Gilead Sales Report is a daily CSV (actually pipe-delimited) report that is generated every morning and transmitted to ValueCentric (data provider). This program is written in Java and run as an Integrator timer job.

sFTP

ValueCentric only accepts connections from whitelisted IPs. I believe our Telus WAN subnet has been whitelisted, or at the very least, both the WAN IPs of bart and superman, so the regular programs can run (it used to run on Bart). This is just something to keep in mind in case you try to either upload the file manually from home (won't work even through VPN) or run the program.

The sFTP connection also requires public key authentication (no password authentication). This private-public key pair was generated by us and the public key was provided to ValueCentric. The name of the key is isvcacct.key, found in the SSH keys folder in superserver\tech\common

Manually running the report

A workflow for this that can be executed by a non-developer is still being worked on. This is because the Class Runner feature in Integrator, which is how you would normally run a one-off job, doesn't accept parameters, of which the report date (the date you want to run the report for) is the first one e.g. args[1]. Note that this is not args[0], or the zeroth argument.