90 likes | 237 Views
TwinEngines NG Automation Suite. Data Flow. SIDPERS (Data Load). FTP Site. SIDPERS. Awards, Hsdasf Hsdosf, Hsdspff Lsdb, hsdsplf. UPS Extracts. TwinEngines Applications. CMS. Loader. All applications use the organizational data loaded through this interface for security purposes.
E N D
TwinEngines NG Automation Suite Data Flow
SIDPERS (Data Load) FTPSite SIDPERS Awards, Hsdasf Hsdosf, Hsdspff Lsdb, hsdsplf UPS Extracts TwinEngines Applications CMS Loader All applications use the organizational data loaded through this interface for security purposes. Discharges, OER, and NCOER use the personnel data loaded from this interface. In Fall 2006, personnel data will be loaded directly from SIDPERS and the CMS database will no longer be used.
SIDPERS (Linked Servers) SIDPERS SQL Server TwinEngines Applications • TwinEngines Applications log into SQL Server as cmsuser • SQL Server maps cmsuser account to a valid SIDPERS Oracle Account (see SQL Enterprise Manager->Security->Linked Servers->SIDPERS->Properties->Security) • SQL Server logs into SIDPERS and executes distributed queries • Results returned to TwinEngines Applications • In Fall 2006, all applications will be converted to use this method.
AITS SIDPERS SQL Server TwinEngines Applications • TwinEngines Applications log into SQL Server as cmsuser • SQL Server maps cmsuser account to a valid AITS Oracle Account (see SQL Enterprise Manager->Security->Linked Servers->AITS>Properties->Security) • SQL Server logs into AITS and executes distributed queries • Results returned to TwinEngines Applications
E-Trans Manager State PERMS Enlistment Data Streams Enlistment Data Streams NGB ARISS Enlistment Data Streams Document Images Document Images E-TransMgr Export Transactions E-TransMgr Work In Progress E-TransMgr Import Tx SIDPERS FTP Upsimport.sh SIDPERS
PERMS NGB PERMS State SQL Server T&S Tracking PERMS Doc_data View list of MOS and security related documents in PERMS Discharges Find latest DD-4 date for use on Form 4836
PERMS Integrator TIFF Image Index Data PERMS Integrator MILPO Orders AITS PERMSXML Batch Import Directory PERMS Batch Import Process PERMS
PERMS Integrator Orders (.prt) PERMS Integrator AFCOS AFCOS PERMSXML Batch Import Directory TIFF Image Index Data PERMS Batch Import Process PERMS
PERMS Integrator NGB-23 (.rtf) PERMS Integrator RPAM RPAM PERMSXML Batch Import Directory TIFF Image Index Data PERMS Batch Import Process PERMS