140 likes | 156 Views
Mainframe to Mainframe Communication via the Student Aid Internet Gateway. 2003 NASU Conference Tom Biedscheid – Colorado State University. Overview. System Diagram Security TDClient Software CSU Process Overview TDClient Manager. SAIG System Diagram. SEND/ RECEIVE.
E N D
Mainframe to MainframeCommunicationvia theStudent Aid Internet Gateway 2003 NASU Conference Tom Biedscheid – Colorado State University
Overview • System Diagram • Security • TDClient Software • CSU Process Overview • TDClient Manager
SAIG System Diagram SEND/ RECEIVE PC Destination - EDconnect Title IV Appsys SEND/ RECEIVE Encryption Internet (SSL 3.0) SEND/ RECEIVE SEND/ RECEIVE MF Destination Point Using EasyAccess/TDClient TDN/ @ VDC Authentication Manage/ Report TDManager @ VDC Manage/ Report Remote Administration
SAIG Security • TDClient v2.2.x (formerly EasyAccess) is the client software used to send and receive FTP data transmissions securely over the Internet using SSL 3.0 and the Diffie-Hellman Dynamic Key Exchange algorithm. • Since TDClient is built into current versions of EDConnect, the level of security is identical between EDConnect and TDClient running on a mainframe. • Password: Same as that used and set in EDConnect for SAIG access
TDClient: Systems Supported • OS/390 MVS/ESA 2.6+ (with LE/370 1.9) • AS/400 4.2+ (Compiler Level 3.7) • AIX 4.2+ • Digital Unix 4.0 (DEC UNIX) • DEC Open VMS 7.1 • HPUX 10.01+ • Sun Solaris 2.6+ (SPARC chip only, Intel chip not supported)
TDClient Software & Documentation • Software • TDClient is available only upon request by contacting CPS/WAN Technical Support at 800-330-5947 or via email at cpswan@ncs.com. • Documentation • Host Communication Guide is available for download from the FSA Download website, http://FSAdownload.ed.gov
CSU Process Overview • Receiving Message Classes • 1st job in nightly production schedule • Establish secure connection to SAIG • Download available message classes • Only those we have identified • Decompress • Backup message classes • Move message classes to appropriate datasets • Available for subsequent jobs during the same nightly run • If a downloaded message class is a COMRECOP: • The same “receive” JCL initiates CASX50 • XML documents are parsed and datasets created • ORSPx, DRSPx, PNOTEx, etc. TDClient
CSU Process Overview • Sending Message Classes • Production job runs generating an outbound message class • Establish secure connection to SAIG • Message class is compressed • Message class is sent TDClient
Sample Receive JCL //PSAM30A JOB (,BN35), // CLASS=K, // MSGCLASS=J, // MSGLEVEL=(1,1), // USER=UISP1A //**------------------------------------------------------------------* //EA2KMVSC EXEC PGM=EA2KMVSC, // COND=(0,NE), // PARM='CMDFILE=DD:CMDRECV', // REGION=4M //STEPLIB DD DSN=PSAI.EACCESS.PRD.EALOAD, // DISP=(SHR,KEEP,KEEP) //EASYACC DD DSN=PSAI.EACCESS.PRD.EASYACC.INI, // DISP=(SHR,KEEP,KEEP) //EXFER DD DSN=PSAI.EACCESS.PRD.EASYACC.EXFER.INI, // DISP=(SHR,KEEP,KEEP) //CMDRECV DD DSN=DAID.USER.DATALIB(CMDPASS), // DISP=(SHR,KEEP,KEEP)
Sample Receive JCL (cont.) //CMDRECV DD DSN=DAID.USER.DATALIB(CMDPASS), // DISP=(SHR,KEEP,KEEP) // DD DSN=PSAM.CONTROL.DATALIB(CMDRECV), // DISP=(SHR,KEEP,KEEP) //COMRECOP DD DSN=PSAM.SAIG.COMRECOP, // DISP=(MOD,KEEP,KEEP) //COREEVEN DD DSN=PSAM.SAIG.COREEVEN, // DISP=(MOD,KEEP,KEEP) //COREODD DD DSN=PSAM.SAIG.COREODD, // DISP=(MOD,KEEP,KEEP) //CORREVEN DD DSN=PSAM.SAIG.CORREVEN, // DISP=(MOD,KEEP,KEEP) //CORRODD DD DSN=PSAM.SAIG.CORRODD, // DISP=(MOD,KEEP,KEEP) //DECF03OP DD DSN=PSAM.SAIG.DECF03OP, // DISP=(MOD,KEEP,KEEP) //DLFF03OP DD DSN=PSAM.SAIG.DLFF03OP, // DISP=(MOD,KEEP,KEEP) //DSDFEVEN DD DSN=PSAM.SAIG.DSDFEVEN, // DISP=(MOD,KEEP,KEEP)
TDClientManager • Manage message classes in your SAIG mailbox • Check status • Change password • Repost message classes • Access to message class archive • http://www.saigportal.sfa.ed.gov/
Data Warehousing @ CSU • Purpose • Make financial aid data available to other departments on campus • Office of Budgets and Institutional Analysis • Research • Other departments and colleges • Aid in awarding scholarships
Data Warehousing @ CSU • Process • Job runs nightly extracting data from SAM • Dataset is FTPd to an Oracle database running on an AIX box • SAM warehouse tables updated • SAM fields warehoused • http://delphi.is.colostate.edu/dictweb/dictw001$.startup
Tom Biedscheid Student Financial Services Colorado State University 970.491.5605 Tom.Biedscheid@colostate.edu Questions