MARS Technology: MARS Technology Management Administrative Reporting System “Under the Hood” MARS


Slide2: What is MARS? Architecture Technologies MARS Components Features Technology Requirements Resources Questions MARS Technically Speaking


Slide3: Client Server Central Server Processing Distributed Processing Client Workstations Thin Client Infrastructure Emerging Technologies MARS ARCHITECTURE MARS


MARS Technical Architecture: MARS Technical Architecture Mainframe Systems Relational Databases Web Servers Enterprise Servers Graphical User Interface Remote Offices


Slide5: STARS Way Record Orientation Sequential File Storage Terminal access Central processing Limited Data Access Knew by few MARS ARCHITECTURE MARS Way Document Orientation RDBMS GUI Client Hybrid Processing Flexible Data Access Maintained through vendor partnership MARS


Slide6: TECHNOLOGIES MARS


MARS COMPONENTS: Advantage 2000 ADV Procurement Desktop PD Budget Reporting and Analysis Support System BRASS Management Reporting Database MRD Travel Management System TMS MARS COMPONENTS MARS


Slide8: Advantage 2000 Financial and Materials Management PD Automated Procurement TMS Forms Based Travel Management Reporting Database BRASS Budget Management MARS Component Model MARS


Slide9: • Budgeting and Appropriation Control • General Ledger • Revenue Accounting/Accounts Receivable • Encumbrance/Expenditure Accounting • Accounts Payable/Cash Disbursements • Cash Management • Cost Accounting • Grant/Federal Aid Management • Project Accounting and Budgeting • Inquiry and Reporting Fixed Assets MARS FEATURES


History of ADVANTAGE 2000: History of ADVANTAGE 2000 Current version is ADVANTAGE Release 2.0 Custom Administrative Systems for Governments IMS DB/DC Government Financial System GFS Release 1.0 Government Financial System GFS Release 8.0 1976-1983 1983-1986 1986-1993 ADVANTAGE 2000 Series Release 2.0 Financial, HR, Revenue 1994-1998 Functionality Custom Revenue Systems for Government New York City Washington DC State of Ohio Technology Rewrite Foundation Software CICS/VSAM/COBOL ADVANTAGE Technology Client/Server Relational DBMS Technology Technology


State GovernmentADVANTAGE Clients: State Government ADVANTAGE Clients Alabama Colorado Delaware Illinois Iowa Kentucky Louisiana Maine Massachusetts Minnesota Mississippi Missouri Nevada New Hampshire New Jersey New Mexico Ohio Utah Wisconsin Wyoming Statewide State Agency Alabama Natural Resources Alabama Revenue Arizona Economic Security Arizona Transportation Illinois Corrections Illinois Human Services Illinois Public Aid Indiana Human Services Indiana Transportation Mississippi Human Services New Mexico Transportation Ontario Natural Resources Utah Transportation Washington Transportation 20 Statewide Systems


Advantage Architecture: Advantage Architecture MARS


Slide13: Database Server IBM Mainframe Operating System MVS or OS/390 Advantage Software (COBOL) Database IBM DB2 TCP/IP Connectivity TP Monitor CICS Key Technologies


Slide14: File Server Windows NT Server File, print, and authentication Advantage Software Run from client or server TCP/IP Connectivity Key Technologies


Slide15: PC Client Windows NT 4.0 or 95 Advantage Desktop (C, C++) Neuron Data Elements TCP/IP Connectivity Key Technologies


Procurement Desktop: Procurement Desktop


Procurement Desktop Features: Procurement Desktop Features


History of Procurement Desktop: History of Procurement Desktop 1992 Initial release U.S. Patent and Trademark Office -- first client Integrated with AMS Federal Financial System 1993-1996 Three-tiered architecture added Additional sites, including the Canadian Public Works and Government Services -- 1,500 buyers using system Current version is Procurement Desktop Release 4.4


History of Procurement Desktop: 1997 Web features added Los Alamos National Laboratory -- 5,000+ users U.S. Department of Defense -- 10,000 users History of Procurement Desktop


PD Architecture: PD Architecture MARS


Slide21: Database Server IBM RISC 6000 SP2 Node IBM AIX 4.3 Operating System Oracle 8 Database Net 8 database communications TCP/IP Connectivity Key Technologies


Slide22: File Server Windows NT Server File, print, and authentication PD Software Routing, Approvals, Integration Policies and Procedures TCP/IP Connectivity Key Technologies


Slide23: PC Client Windows NT 4.0 or 95 PD Application - Powerbuilder 6 Oracle 8 Database license Net 8 database communications TCP/IP Connectivity Java web browser - PD Web Key Technologies


BRASSBudgeting Technology, Inc.: BRASS Budgeting Technology, Inc.


BRASS Features: System Used at Each Phase of the Budget Process Formulation Review Publishing Monitoring Maintains Comprehensive Audit Trails Provides “What-if” Analysis Operational and Capital Budgeting BRASS Features


BRASS Features: Flexible Budget Views Consolidation Customer Determined Budget Entry Forms Salary and Benefit Forecasting Performance Based Budgeting Links to PC Tools Reporting Modeling Security BRASS Features


History of BTI: Founded in 1985 Started Software development in 1989 1989 Wang and PC Budgeting System 1990 Unix 1995 Client Server Exclusively committed to Budgeting Leader in the field History of BTI


BRASS Architecture: BRASS Architecture MARS


Slide29: Database Server IBM RISC 6000 SP2 Node IBM AIX 4.3 Operating System Oracle 8 Database Net 8 database communications TCP/IP Connectivity Key Technologies


Slide30: File Server Windows NT Server File, print, and authentication BRASS Software Run from client or server TCP/IP Connectivity Key Technologies


Slide31: PC Client Windows NT 4.0 or 95 BRASS Software Powerbuilder 6.0 Oracle 8 database license Net 8 data communications Microsoft Office 97 Suite TCP/IP Connectivity Key Technologies


Management Reporting: Is a Concept -- Not a product Flexible Data Access Approach OLAP - Online Analytical Processing Ad-Hoc Reporting Data Pipelining Report Distribution Key Technologies Management Reporting


Management Reporting: Key Technologies Management Reporting


Management Reporting: Seagate Crystal Info Distributed Business Intelligence View, schedule and manipulate shared reports Create Ad-hoc queries and reports Client, Web browser, email access Security Key Technologies Management Reporting


Management Reporting: Seagate Crystal Info Print reports with graphs to HTML Mail Merge and form printing Export reports and queries to: Word Excel Outlook HTML CSV ODBC and other formats. Key Technologies Management Reporting


Management Reporting: Key Technologies Management Reporting


Management Reporting: Database Server IBM RISC 6000 SP2 Node IBM AIX 4.3 Operating System Oracle 8 Database Net 8 database communications TCP/IP Connectivity Key Technologies Management Reporting


Management Reporting: APS / Crystal Info Servers Dual Intel Pentium II 300MHz 256 MB RAM Windows NT Server Crystal Info Server Software TCP/IP Connectivity Key Technologies Management Reporting


Management Reporting: File Server Windows NT Server File, print, and authentication Crystal Info Software Run from client or server TCP/IP Connectivity Key Technologies Management Reporting


Management Reporting: PC Client Windows NT 4.0 or 95 Seagate Crystal Info Client Net 8 database communications Microsoft Office 97 Suite Java Capable Web Browser TCP/IP Connectivity Key Technologies Management Reporting


Travel Management System: New Product Partnership: CKY and AMS Plan, Budget, Submit and Approve Travel Requests Service Provider Linkage Online Itinerary Business Rules Travel Management System


Travel Management System: Technologies Outlook Forms Outlook client Web client Workflow and routing Key Technologies Travel Management System


TMS Architecture: TMS Architecture MARS


Travel Management System: Application Server Windows NT Server TMS Software J++ Microsoft JAVA Virtual Machine Microsoft Transaction Server TCP/IP Connectivity Key Technologies Travel Management System


Travel Management System: Exchange Server Windows NT Server TMS Exchange Folders Microsoft Exchange Server TCP/IP Connectivity Key Technologies Travel Management System


Travel Management System: File Server Windows NT Server File, print, and authentication TMS Software - Forms Plus Run from client or server TCP/IP Connectivity Key Technologies Travel Management System


Travel Management System: PC Client Windows NT 4.0 or 95 TMS Software - Forms Outlook 98 Exchange Client Java Capable Web Browser TCP/IP Connectivity Key Technologies Travel Management System


REQUIREMENTS: File and Print Servers Intel Pentium Pro Dual Processor 200MHz 128 MB RAM 8.0 GB Available disk space Windows NT 4.0 TCP/IP REQUIREMENTS MARS


REQUIREMENTS: Windows 95 Workstations 166 MHz Intel Pentium Processor 32 MB RAM VGA - SVGA Recommended 150 - 250 MB available disk space TCP/IP Follow Commonwealth Approved Standards & Products list REQUIREMENTS MARS


REQUIREMENTS: Windows NT Workstations 200 MHz Intel Pentium Processor 64 MB RAM VGA - SVGA Recommended 150 - 250 MB available disk space TCP/IP Follow Commonwealth Approved Standards & Products list REQUIREMENTS MARS


REQUIREMENTS: Infrastructure Under Analysis Current Indications KIH Implementation REQUIREMENTS MARS


RESOURCES: Planning Commonwealth Approved Standards & Products list Kentucky Information Highway Agency Implementation Assistance Notebook Team Resources RESOURCES MARS


RESOURCES: Post Implementation Support AMS - Long Term Partnership MARS Customer Resource Center Functional Assistance MARS Help Desk Technical Assistance RESOURCES MARS


RESOURCES: Research American Management Systems www.amsinc.com Seagate - Crystal Info www.seagate.com OLAP Council www.olapcouncil.org/research/whtpaply.htm RESOURCES MARS


QUESTIONS: QUESTIONS MARS