1 / 9

TwinEngines NG Automation Suite

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.

luther
Download Presentation

TwinEngines NG Automation Suite

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. TwinEngines NG Automation Suite Data Flow

  2. 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.

  3. 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.

  4. 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

  5. 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

  6. 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

  7. PERMS Integrator TIFF Image Index Data PERMS Integrator MILPO Orders AITS PERMSXML Batch Import Directory PERMS Batch Import Process PERMS

  8. PERMS Integrator Orders (.prt) PERMS Integrator AFCOS AFCOS PERMSXML Batch Import Directory TIFF Image Index Data PERMS Batch Import Process PERMS

  9. PERMS Integrator NGB-23 (.rtf) PERMS Integrator RPAM RPAM PERMSXML Batch Import Directory TIFF Image Index Data PERMS Batch Import Process PERMS

More Related