1 / 30

Business Enabling Mission-Critical Data

Business Enabling Mission-Critical Data. Paul O’Hagan Senior Solution Architect September 2006. Travels. Tampa FL Orlando FL Pittsburgh PA Philadelphia PA Louisville KY Atlanta GA Boston MA New York NY Cincinnati OH Cleveland OH. Industries. Telecommunications Manufacturing

felice
Download Presentation

Business Enabling Mission-Critical Data

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. Business Enabling Mission-Critical Data Paul O’Hagan Senior Solution Architect September 2006

  2. Travels • Tampa FL • Orlando FL • Pittsburgh PA • Philadelphia PA • Louisville KY • Atlanta GA • Boston MA • New York NY • Cincinnati OH • Cleveland OH

  3. Industries • Telecommunications • Manufacturing • Education • Government & NGO’s • Technology • Financial Services • Healthcare • Insurance • Retail • Services

  4. Real-Time Data Integration Business Value Event Detection Application Integration E-Business BI Audit HA Environmental Complexity

  5. Market Drivers

  6. Integration Needs • Business intelligence • Real-time, BAM, KPI • Optimizing current investment (i.e. batch pressure) • Information Integrity • Data integrity • Guaranteed delivery • Disaster protection • Event-driven integration • SOA integration • Competitive web advantage • Web services interaction • Master Data Management • Customer Data Integration • Product Information Management Leverage Existing Investments

  7. Your Challenges • Data volumes high – and increasing • Systems strained • Pressure to streamline operations • Heterogeneous environment • Uptime requirements • Risk management Usable, Manageable, Scalable

  8. Requirements • Increased business agility • Analyze changes as they occur • Monitor and respond to events as they happen • Transform the data to the form it’s needed • Lower operational costs • No impact on performance of operational systems/protection of impact on source systems • Low bandwidth requirements • No changes required to operational system architecture • No need for downtime or batch windows • Scalable • Latency does not increase with the size of the database • Can scale to synchronize large numbers of data stores

  9. Your Options • Change or upgrade applications and/or hardware • What’s the “cost?” • Change the database schema • Add triggers or columns • Do you “own” the schema? • More frequent batch operations • What’s the “cost?” • Log-based change data capture

  10. Architecture Java-based GUI Unified Admin Point With Monitoring Subscriber Publisher Database Operational Data Store TCP/IP Message Queue Web Services Journal Log Redo/Archive Logs Publisher Engine And Metadata Subscriber Engine And Metadata Business Process

  11. Information Awareness • Visibility into individual transactions Real-Time Operational Conversions Insert Insert Update Insert Delete Insert

  12. Filtering ROW SELECT REP_NO = 25 • Row filtering allows you to select rows • Column filtering allows you to select columns

  13. Transformations Transform Fields Derived Fields Concatenation Century Dates Increase Field Size

  14. XML Mapping <CustomerOrder> <Customer> <CustomerName>ABCDelivery</CustomerName> <CustomerCode>CUS112</CustomerCode> <CustomerAddress1>1234 Avenue Street</CustomerAddress1> <CustomerAddress2>Waterloo</CustomerAddress2> </Customer> <Order> <OrderNumber>S906</OrderNumber> <OrderDate>02/14/05</OrderDate> <ProductCode>X5PR</ProductCoder> <CustomerCode>CUS112</CustomerCode> </ Order> </CustomerOrder> CUSTOMER ORDER TABLE CUSTOMER TABLE

  15. SOA Integration • Combines content associated with the event from other systems • Routes the data to different message queues based on content of a message Content based routing Purchase Order Message Queue Event Server ERP Message Queue Message Queue CRM Customer Information

  16. Business Problems Integration of Production Data for e-Business Applications • Up to date information flowing to and from web applications Real-time Integration for Business Intelligence and Reporting • Yesterday’s data inadequate for inventory and purchasing decisions Real-time Event Detection • Pro-actively monitor and respond to business changes Data Protection for High Availability and Disaster Recovery • Mitigate risk and offload production systems ……DataMirror has the right tools today…

  17. Thank You Paul O’Hagan Senior Solutions Architect 905-415-0310 x305 pohagan@datamirror.com

  18. Customer Examples • Loading an ODS • Real Time BI • Application Integration • Batch Window Elimination • eBusiness Enablement

  19. Sun Solaris ORACLE Apps 11i Point of Sale System Redo Log ODS Sun Solaris ORACLE 9iR2 Enterprise Data Warehouse

  20. Results: • Near Real-time integration into ODS • Minimize impact on source system and network infrastructure • No need for triggers • Leverage existing Ab Initio investments • Lower TCO solution • Transformation capabilities • Ease of use

  21. Business Solutions – Secure Public Web Access to court information – Workload balancing by offloading reporting to Oracle Web Access iSeries

  22. Results: • Allows officials across the state to securely track offenders at any point—from arrest to disposition. • Provide secure access to various groups of end-users • Allows the general public to research court cases without impacting the Branch’s iSeries production server, protecting the security and integrity of the production data.

  23. OS/390 Flow of information from OS/390 (host) to stage to data centres Flow of information from individual data centres to OS/390 (host) Stage AS/400 Data Centres Business & Technology Driver: Real-Time Supply Chain Visibility, On-line Gift Registry synchronized in real-time

  24. Results: • Real-time data access provides continuous visibility into supply chain, ensuring products are available and delivered in a timely manner and reducing stock-outs • Improves productivity and profitability • Improves customer service and satisfaction • Supports move from mainframe environment to a more flexible, decentralized computing environment

  25. Results: • Both systems are in synch ensuring consistency and accuracy of data • Consistent information is available to sales force improving sales revenue and customer service • Supports move from mainframe environment to a more flexible, decentralized computing environment

  26. Results: • Able to complete integration process and move the necessary data into their data warehouse • Better Customer Service • Better understanding of customer • More efficient reporting by customer reps and sales managers • Able to comply with UCCNet requirements, mandated by their largest customer, Walmart

  27. Business Solutions – Online Gift Registry synchronized bi-directionally in real-time with production data, Real-time Business Intelligence for better decision making

  28. Results: • Real-time access to all corporate data supports critical management decision making on pricing, merchandising and inventory management • Provides more accurate product and purchasing information for employees and customers alike, even during busiest seasons (e.g., Christmas) (real-time bi-directional synchronization) • Leverages legacy technology investments by requiring no changes to current production systems • Low risk and impact on the production system because of DataMirror log-scraping Change Data Capture technology • Saves time and resources traditionally spent writing independent instructions to move, replenish, and maintain data

More Related