Data Integration Strategy Air Force Personnel Operations Agency – Human Resources

1. Data Integration Strategy Air Force Personnel Operations Agency – Human Resources December 2, 2011

2. Agenda - TOC • Who is SAS? • Where is SAS in the Air Force • Essential Business Process Agility • Data Integration and Information Management • Data Quality: Cleansing and Enrichment • Data Integration/Management Benefits • Why SAS for AFPOA • Resources and Further Contact Information

3. SAS – Leader in Applied Analytics • Largest privately held software company in the world • 2010 Revenue: $2.43 Billion – 35 Years of consecutive growth • 24% reinvestment in R&D for 2010 • 50,000 deployments worldwide • 12,000 employees • 90 of the top 100 of Fortune Global 500 • All 15 U.S. Departments and 90% of U.S. Federal Agencies • All 50 U.S. State Governments • Government agencies in 80 countries • Outstanding Technical Support Services Life Sciences: 6% Manufacturing: 5.5% Retail: 4.5% Communications: 7% Education: 3% Services: 11% Energy & Utilities: 3% Other: 1% Government: 15% Financial Services: 42%

4. Where SAS is in the U.S. Air Force In a new framework for AF Human Resources, these SAS installations could be streamlined if needed or leveraged. Malmstrom AFB Hanscom AFB Offutt AFB Wright-Patterson AFB Hill AFB Langley AFB Chantillly, VA & Washington, D.C. Scott AFB Peterson AFB Nellis AFB Edwards AFB Tinker AFB Kirtland AFB Huntsville LA AFB Robins AFB Maxwell AFB-Gunter Barksdale AFB Eglin AFB Hurlburt Field Brooks, Randolph Lackland AFBs Patrick AFB

5. Essential for Business Process Agility Data Integration defined in terms of Information Data Access/Integration/Quality Data Governance for Airman Personnel PII Master Data Best Record Airman Personnel Decision Management Support Performance and Cost Analytical Model Management and Governance Recalibrate or New

6. Data Integration and Information ManagementThe Opportunity Data Diversity: Big Data Use Case Diversity Unified Data Management Role Diversity: IT/Business Acceleration Information Management is required to meet the current demands in the Business and Technical landscape Deployment Diversity: Cloud Consumption Diversity: Mobility • Managing information for Air Force personnel who are the most valuable asset includes the ability to value information appropriately Architecture Diversity: Enterprise Architecture Application Diversity: Operational Analytics Temporal Diversity: Right-Time

7. Data Management and IntegrationCapability View Agile And Responsive To Changing Requirements Linking IT Strategy to Business Strategy DATA SERVICES DATA & ANALYTIC SERVICES DATA GOVERNANCE ANALYTICS GOVERNANCE Analytics Management MODEL MANAGEMENT & MONITORING MODEL DEPLOYMENT & INTEGRATION DATA INTEGRATION DECISION MANAGEMENT DATA QUALITY Data Management MDM Infrastructure Support INFRASTRUCTURE SUPPORT: Text & Unstructured Data Support, Events, Security, Meta-data & Lineage, Monitoring & Deployment ENTERPRISE DATA ACCESS

8. Data Management Data Management Data Management • UNIFIED PLATFORM INFORMATION MANAGEMENT Data Integration Data Quality Master Data Management Enterprise Data Access and Federation Resolves Architecture is rigid; not flexible to changes in business needs Managing end-to-end processes is challenging

9. Why SAS/DataFlux for Data Management • SAS the Original Data Warehouse Pioneer • 35 years Data Management Experience • Thousands of Data Management Customers worldwide • End-to-end Solution Available • Gartner Leader for DQ • Gartner Leader for DI • Gartner DI Leader Best-in-Class Data Access Technology • Shortest Time to delivery for MDM • Scalable Grid Enabled Platform • Only Data Management vendor with integrated analytic scoring • World Class Partner Network • Thousands of consultants worldwide • Growth through consistent R&D • UNIFIED PLATFORM INFORMATION MANAGEMENT

10. SAS’ Data Management Portfolio • SAS Data Integration Server • SAS Data Integration Server • SAS Enterprise Integration Server • SAS Data Quality Solution (Server minus DI Studio) • DataFlux Data Management Platform • Data Management Studio • Data Management Server • Data Federation Server • qMDM – Master Data Management • DataFlux Solution Accelerators • DataFlux Event Stream Processor • Supporting SAS Technologies • SAS / Access • Interface to <insert favorite RDBMS > / Interface to PC Files • SAS Integration Technologies • Message Queuing APIs, Web Services, Publishing Framework • UNIFIED PLATFORM INFORMATION MANAGEMENT

11. SAS Data Management Advantage – Access?Any Data, Anywhere, Anytime: Best-in-Class Data Access Technology • SAS/Access What is it? • SAS/ACCESS Interfaces are out-of-the-box solutions that provide enterprise data access and integration between SAS and third-party databases. • SAS/ACCESS interfaces are highly optimized to enable your SAS® solutions to read, write and update data regardless of its native database or platform. • Because the data appears native to SAS, there is no need to learn Structured Query Language (SQL) or any other database-specific query languages. • All data is presented unified to users, complex activities like bulk loading are simplified, cross source integration is seamless. • SAS leverages the underlying RDBMS for you transparently • For example, a single option is used to invoke bulk loaders • DATA MyORA.ORACLE_TABLE(BULK_LOAD=YES) • DATA ACCESS

12. SAS Data Management AdvantageAny Data, Anywhere, Anytime: Best-in-Class Data Access Technology • RDBMS • SAS/ACCESS Interface to DB2 • SAS/ACCESS Interface to Informix • SAS/ACCESS Interface to Microsoft SQL • SAS/ACCESS Interface to MySQL • SAS/ACCESS Interface to ODBC • SAS/ACCESS Interface to OLE DB • SAS/ACCESS Interface to Oracle • SAS/ACCESS Interface to Sybase • SAS/ACCESS Interface to Sybase IQ • SAS/ACCESS Interface to Teradata • MPP Database Appliances • SAS/ACCESS Interface to Aster Data nCluster • SAS/ACCESS Interface to Greenplum • SAS/ACCESS Interface to Netezza • SAS/ACCESS Interface to Exadata • SAS/ACCESS Interface to ODBC (ParAccel, Vertica, Microsoft PDW) • Non-Relational • SAS/ACCESS Interface to ADABAS • SAS/ACCESS Interface to DATACOM/DB • SAS/ACCESS Interface to IDMS/R • SAS/ACCESS Interface to IMS-DL/I • SAS/ACCESS Interface to PC Files • SAS/ACCESS Interface to SYSTEM 2000 • EnterpriseApplications • SAS Data Surveyor for SalesForce.com • SAS Data Surveyor for Oracle Applications • SAS Data Surveyor for SAP • SAS Data Surveyor for Siebel • OLAP • Message Queues • XML • Web Services • Unstructured, Semi-Structured And more… • DATA ACCESS Enterprise-wide, net-centric to meet the operational needs of the AF

13. SAS Data Integration and Management Benefits and Features • DATA INTEGRATION

14. SAS Data Management Workbench Data Integration via a Flexible and Powerful Interface • Execute Data Quality Workflows • Metadata Driven Environment • Deploy governance within the IT infrastructure • Determine integration method • Real-time • Batch • Virtual • Reuse and redeploy the same set of business rules across applications • Review execution results • Exceptions • Debugging • Tuning • Optimization • DM System Reporting • DATA INTEGRATION

15. SAS Data Management AdvantageScalable : In-Database EL-T • Visual Indicators show you where processing takes place. • Push-down is a simple option set on the SQL transform. • Users can control where processing takes place, two clicks enable users to “move first then process” via bulk loader. • DATA INTEGRATION

16. SAS Data Management AdvantageAnalytic Integration : Integrated Scoring • Integration of Predictive analytics from SAS’ Enterprise Miner into Data Management tasks, takes just two clicks. • Shared Metadata provides the lineage of model dependencies and where models are consumed • With Scoring Accelerator Scoring Functions can be Pushed “In-Database” and called via SQL Function calls from DI Studio • DATA INTEGRATION

17. Metadata Management • DATA INTEGRATION • Sophisticated metadata mapping technologies accelerates development • Impact Analysis/Data Lineage to see process and data relationships • Multi-user Collaboration with DEV/TEST/PROD promotion management • Powerful metadata reporting including runtime and performance analysis • User Interface Roles and Security

18. SAS Data Management AdvantageBest in Class: DataFlux Data Quality • DATA QUALITY • Embedded into batch, near-time and real-time processes. • Rules callable through message queues, Web services and custom exits. • Data cleansing provided in native languages with localizations. • Metadata built and shared across the entire SAS Platform. • Generate and append postal addresses, geo-coding, demographic data or facts from other sources of information. • Profile operational data and monitor ongoing data activities.

19. Data Cleansing and Enrichment • Data quality, including integrated profiling, exploration, business rules creation, entity resolution and monitoring. • Process orchestration layers for jobs, SAS code and SQL. • Data quality is embedded into batch, near-time and real-time processes. • Out-of-the-box standardization rules; or you can create customized, reusable data quality business rules. • Data quality rules are callable through message queues, Web services and custom exits. • Data enrichment and augmentation. • Real-time transaction cleansing using standard business rules. • Data quality monitoring lets you continuously examine data in real time and over time to discover when quality falls below acceptable limits. Alerts are issued when corrective action is needed. • DATA QUALITY

20. Business Rules to Track Data Events • DATA QUALITY Events from business rules are SOA enabled

21. Monitor Data Quality • Monitor on the Web; Multiple repositories • Workflow capabilities DataFlux Data Management Web Studio • Monitor History Graph Filter: Triggered rules: Repository: • Apply Clear • Open Table Total count: 24 • DATA QUALITY General * Date: • This week Rule: Task: Source: Description: Importance : • Summary • Trigger Values • Rule Code • Status Trigger Percentage Trigger History (Percentage of Rows Processed) Monitor Statistics Run Status Term Date Table

22. Cust. Id First Name Middle Last Name DOB SSN Address 30391-244 William James Sosulski 04/12/39 563-49-1234 123 Oak St., Eves, IL 30319 Cust. Id First Name Middle Last Name DOB SSN Address 30391244 William J. Sosulski 4-12-39 563491234 123 Oak St., Eves, IL Cust. Id First Name Middle Last Name DOB SSN Address 14239 Bubba J. April 12 BubbaJ@bubbagroup.com Cust. Id First Name Middle Last Name DOB SSN Address 3721B Willaim James Corp. April 12 56349123 3224 Pkwy G, Los Osos Cust. Id First Name Middle Last Name DOB SSN Address 30391-244 William James Sosulski 04/12/1939 563-49-1234 123 Oak St., Eves, IL 30319 Entity Resolution for Data ServicesKnowing your Airman Legacy CRM Online • MASTER DATA ERP Data Warehouse 1001 30391-244 30391244 14239 3721B 30391-244 William James Sosulski 04/12/1939 563491234 123 Oak Street Eves CA 91403 22

23. SAS Data Management BenefitsControl & Lower TCO • DATA INTEGRATION • Integrated DQ Functions • Specialized DQ Interfaces • SOA Enabled • Lineage Reporting from Source to Report • Over 300 Functions 70 built-in Transformations • Analytic Integration & Scoring • Scalable Partition-Based Parallelism • Record Setting File I/O • Best-in-Class Data Access Technology /w/ Widest Array of Data Sources and Targets • Version Control

24. Why SAS for AFPOA? Flexibility Agile and responsive to meet the needs of the Air Force’s most important asset: Air Force Personnel Why it Matters Feature Seamless integration with AFPOA enterprise architecture and workflow Data quality rules automatically exposed as RESTful and SOAP Web Services All tools are built on a 4th Generation SAS Programming Language and C++ Enables AFPOA to more easily adapt SAS/DataFlux data management capabilities to changing mission needs Unified runtime across computing environments Enables AFPOA to attain cloud computing environments

25. SAS Can Be Your Trusted Partner #1 World Leader in Business Analytics 50,000+ Customers 12,000 Employees Worldwide PERFORMANCE Relentless Innovation Voted #1 Place to Work in U.S. Trusted Partner to Governments and Leading Business Organizations CULTURE 50,000 SAS Sites in 127 Countries 93 of the Top 100 Companies in 2011 Fortune Global 500 35 Years Leading Analytics Solutions EXPERIENCE SAS Advanced Analytics Lab Provides Business Leadership Domain Expertise in Key Industries Culture of Innovation: 24% R&D Reinvestment THOUGHT LEADER

26. Resources Here are the URLs and titles of downloadable materials we refer you to for more information: • SAS Data Management - http://www.sas.com/software/data-management/ From this webpage, you can access downloadable materials and drill down deeper into • Data Integration • Data Quality • Enterprise Data Access • Master Data Management • Here are two additional white papers you might find helpful which were provided to Bloor. • “Data Quality Remediation” (DataFlux) • “DataFlux Data Management Methodology: A Do-It-Yourself Guide for High-Value Data Across the Enterprise” (DataFlux)

27. SAS® Data Integration Thank you! If you are interested in hearing more about SAS and how we address Information and Data Integration Management, please contact: Gail Bamford Industry Marketing Manager for Defense & Intelligence Gail.Bamford@sas.com 571-227-7000 x51715