Enterprise Data Integration Overview For US Air Force Personnel Operations Agency (AFPOA) November 18 th , 2011

1. Enterprise Data Integration • Overview For • US Air Force Personnel Operations Agency (AFPOA) • November 18th, 2011

2. Agenda • Introduction to Information Builders • Federal Government Experience • USAF Air Mobility Command • USTRANSCOM TRAC2ES • Introduction to Our Integration Solutions • Complex Data Federation Example –Veterans Affairs • Key Takeaways and Next Steps • Q & A, Contact Information 2

3. Information Builders Inc. • Private Independent Software Vendor • Lines of Business: • Enterprise Integration • Business Intelligence • Established in 1975 • 1,400 customer focused employees • 12,000+ customer sites worldwide • Significant partnerships • Recognized market leader Global Headquarters Two Penn Plaza New York, NY 3

4. Information BuildersCore BI + Extended BI + Real-time Integration / Quality Front office Extended BI Mobile Applications Visualization & Mapping App/Dev, Portals & Mash-ups Enterprise Search Predictive Analytics Core BI Performance Management MS Office & e-Publishing Query & Analysis Dashboards Data Federation Data Migration Real-time & Batch Business to Business Information Delivery Reporting Business Activity Monitoring Data Quality Master Data Management Back office 4

5. Federal Government Experience Civil Depts HHS, Agriculture, Commerce, Education, Energy, Homeland Security, HUD, Interior, Justice, Labor, State, Transportation, Treasury, VA DOD DISA, DIA, AF, Army, Navy, DFAS, NRO, NSA, USTRANSCOM Independent Agencies USPS, NASA, SSA, FDIC, EPA, GAO 5

6. Information Builders’ WebFOCUS and iWay Delivers Real-Time Information Users Can Use • US Air Force • Air Mobility Command • 1,500 Aircraft • 72 Mobility home and transient stations, and HQ • 50,000 worldwide personnel • 400 - 500 daily missions • 3 support personnel 6

7. Information Builders’ WebFOCUS and iWay Delivers Real-Time Information Users Can Use • USTRANSCOM TRAC2ES • Enables Command & Control of global patient movement in peacetime, contingencies and war • Provides 100% ITV • 2 support personnel 7

8. iWay EIM Approach In effect, this is a turn-around from traditional approaches. Other vendors in this space primarily started as batch vendors and now offer real-time or near-real-time extensions but they are still basically batch products. iWay, on the other hand, has designed its EIM to target real-time requirements and, yes, it can do batch too. Companies whose primary requirements are for real-time processing could do worse than to take a good look at iWay EIM. Philip Howard – Bloor Research 8

9. Suppliers, Partners, Customers, Exchanges Enterprise Search Workflow, Portals Real-Time Dashboard DataWarehouse, Data Mart. ODS Enterprise Information Management Suite (BAM, CEP, DQ, MDM) iWay Software’s Integration Server (Data Federation, Virtual Access, Real-time, Batch) iWay Software’s Pre-packaged Native Connectivity Components (Patented Development Process) ProcessesTransactionsDocuments ERP, CRM, HR, SCM, SFA, SaaS, Help Desk Mainframe and Legacy Data, Applications and Transactions Operational Database, Data Warehouse, Data Marts Messages, Transactions, Java, .NET, CORBA EDI Formats, Protocols, HL7, SWIFT, FIX, ACORD Documents, Files, E-Mails, Content Management iWay Software - Integrates the Extended Enterprise 9

10. iWay - Pre-packaged Integration Components This is a partial list of the native data, application, and technology components provided by iWay Software. • ERP/Financials • Ariba • I2 • JD Edwards • Lawson • Manugistics • Microsoft • Oracle • SAP • Legacy Systems • CICS • IMS • VSAM • .NET • Java • TUXEDO • etc • Industry • ACORD • CIDX • HL7 • RNIF • SWIFT • 1Sync • Data Warehouse • DB2 • ETL • Oracle/Essbase • MS SSAS/OLAP • Netezza • SAP BW • Teradata • SFA/CRM • Amdocs/Clarify • BMC/Remedy • MSDynamics • Oracle/Siebel • Salesforce.com • SAP • B2B • Internet EDI • Legacy EDI • MFT • Online B2B • XML 10

11. iWay Software - Integrates the Extended Enterprise 11

12. Federation Example – Veterans Affairs Repositories Data ServicesIntegrated Tools: Automated Deployment and Ease of Use 12

13. Data Quality – Management Cycle Business User Business User IT Professional IT Professional 13

14. iWay Data Federation Solution – Integrating Data Quality Example Scenario • Query • Real-time Information • Federated View iWay Data Federation Data Quality Center Service Manager - Process Orchestration - Prebuilt Integration Components Oracle SAP Remedy Cloud Services (AWS, SFDC,…) Other Sources Legacy Databases Messages EDI Formats Transactions 14

15. Integrating Data Quality - Issue Management 15

16. Issue Management - Data Quality Portal • A web portal/dashboard interface that provides a single, easy-to-access location for all activities related to the monitoring, auditing, management, and resolution of data quality issues • Flexible issue handling including • Automatic routing • System proposed correction • Manual correction and override • Manual merge of duplicate records • Customizable workflow 16

17. iWay Data Federation Solution - Master Data Management Example Scenario • Query • Real-time Information • Federated View iWay Data Federation Corp Data Warehouse Real-time synchronization Master Data Center / Data Quality Center Service Manager MDC Events Prebuilt Integration Components Cloud Services (AWS, SFDC,…) Oracle SAP Remedy Messages EDI Formats Transactions Other Sources Legacy Databases Data Quality Issue Management 17

18. Master Data Management - Architectures Master is Single Version of Truth Data Quality at Master Updates occur at Sources Updates propagated to Master Coexistence Consolidated • Master is Single Version of Truth • Data Quality is Ongoing • Updates occur at Sources or Master • Updates propagated to other Sources Source Source Source Source Source Source Source Source Master Master Master Master Registry Centralized • Multiple Versions of Truth • Data Quality is Ongoing • Updates occur at Sources • Keys and Metadata in Registry • Updates propagated to other Sources (Optional) Source Source • Master is Single Version of Truth • Data Quality at Master • Updates occur at Master • Updates propagated to Sources Source Source Source Source Source Source 18

19. iWay Advantages - Key Takeaways • Native Connectivity to Virtually Any Source • Over 350 Pre-built integration components, • Optimized for performance, minimal network impact • Real-time Federation and Aggregation of Heterogeneous Data Sources • Parallel and distributed processing – highly scalable • Support for Traditional Batch Processing • Integrated ETL engine • Interoperable • iWay “layers into” your current environment and leverages existing investments • A Company Willing to go the Extra Mile for Customers • Thru our Patented Universal Adapter Framework we can quickly enhance our adapters to meet specific customer requirements • Next Steps • How we can help you? • Suggest discovery meeting to better understand your requirements 19

20. iWay Advantages - Key Take-aways At iWay Software, we are as open and flexible as our software, and our customers are our greatest asset. For every new product and feature, there's a customer who drove it. For every customer there's an answer. 20

21. Questions ? And Thank You!! Contact Information: Doug Hurt iWay Software Federal Sales iWay Software, a Division of Information Builders, Inc. 2300 Clarendon Blvd, Suite 1200 | Arlington, VA 22201 Office: 703.247.5597 | Mobile: 240.447.3454 doug_hurt@ibi.com www.iwaysoftware.com | www.informationbuilders.com 21