Mainframe to Mainframe Communication via the Student Aid

  • Slides: 14
Download presentation
Mainframe to Mainframe Communication via the Student Aid Internet Gateway 2003 NASU Conference Tom

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 •

Overview • System Diagram • Security • TDClient Software • CSU Process Overview • TDClient Manager

SAIG System Diagram SEND/ RECEIVE PC Destination - EDconnect Title IV Appsys SEND/ RECEIVE

SAIG System Diagram SEND/ RECEIVE PC Destination - EDconnect Title IV Appsys SEND/ RECEIVE Encryption SEND/ RECEIVE Internet (SSL 3. 0) SEND/ RECEIVE MF Destination Point Using Easy. Access/TDClient TDN/ @ VDC Authentication Manage/ Report Remote Administration TDManager @ VDC

SAIG Security • TDClient v 2. 2. x (formerly Easy. Access) is the •

SAIG Security • TDClient v 2. 2. x (formerly Easy. Access) 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

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

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 TDClient – 1 st job in nightly

CSU Process Overview • Receiving Message Classes TDClient – 1 st 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 CASX 50 – XML documents are parsed and datasets created v ORSPx, DRSPx, PNOTEx, etc.

CSU Process Overview • Sending Message Classes TDClient – Production job runs generating an

CSU Process Overview • Sending Message Classes TDClient – Production job runs generating an outbound message class – Establish secure connection to SAIG – Message class is compressed – Message class is sent

Sample Receive JCL //PSAM 30 A JOB (, BN 35), // CLASS=K, // MSGCLASS=J,

Sample Receive JCL //PSAM 30 A JOB (, BN 35), // CLASS=K, // MSGCLASS=J, // MSGLEVEL=(1, 1), // USER=UISP 1 A //**---------------------------------* //EA 2 KMVSC EXEC PGM=EA 2 KMVSC, // COND=(0, NE), // PARM='CMDFILE=DD: CMDRECV', // REGION=4 M //STEPLIBDD DSN=PSAI. EACCESS. PRD. EALOAD, // DISP=(SHR, KEEP) //EASYACC DD DSN=PSAI. EACCESS. PRD. EASYACC. INI, // DISP=(SHR, KEEP) //EXFER DD DSN=PSAI. EACCESS. PRD. EASYACC. EXFER. INI, // DISP=(SHR, KEEP) //CMDRECV DD DSN=DAID. USER. DATALIB(CMDPASS), // DISP=(SHR, KEEP)

Sample Receive JCL (cont. ) //CMDRECV // // DD // //COMRECOP // //COREEVEN //

Sample Receive JCL (cont. ) //CMDRECV // // DD // //COMRECOP // //COREEVEN // //COREODD // //CORREVEN // //CORRODD // //DECF 03 OP // //DLFF 03 OP // //DSDFEVEN // DD DSN=DAID. USER. DATALIB(CMDPASS), DISP=(SHR, KEEP) DSN=PSAM. CONTROL. DATALIB(CMDRECV), DISP=(SHR, KEEP) DD DSN=PSAM. SAIG. COMRECOP, DISP=(MOD, KEEP) DD DSN=PSAM. SAIG. COREEVEN, DISP=(MOD, KEEP) DD DSN=PSAM. SAIG. COREODD, DISP=(MOD, KEEP) DD DSN=PSAM. SAIG. CORREVEN, DISP=(MOD, KEEP) DD DSN=PSAM. SAIG. CORRODD, DISP=(MOD, KEEP) DD DSN=PSAM. SAIG. DECF 03 OP, DISP=(MOD, KEEP) DD DSN=PSAM. SAIG. DLFF 03 OP, DISP=(MOD, KEEP) DD DSN=PSAM. SAIG. DSDFEVEN, DISP=(MOD, KEEP)

TDClient. Manager • Manage message classes in your SAIG mailbox – Check status –

TDClient. Manager • 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

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

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/dictw 001$. startup

Questions Tom Biedscheid Student Financial Services Colorado State University 970. 491. 5605 Tom. Biedscheid@colostate.

Questions Tom Biedscheid Student Financial Services Colorado State University 970. 491. 5605 Tom. Biedscheid@colostate. edu