Business Enabling Mission-Critical Data

Paul O’HaganSenior 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

HA A

udit B

I

E-B

usin

ess

App

licat

ion

Inte

grat

ion

Eve

nt D

etec

tion

BusinessValue

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

Journal LogRedo/Archive Logs

Publisher EngineAnd Metadata

Subscriber EngineAnd Metadata

TCP/IP

Java-based GUIUnified Admin Point

With Monitoring

Database

Operational Data Store

Message Queue

Web Services

Business Process

Publisher Subscriber

Architecture

11

Information Awareness

Insert

Update

Delete

InsertInsert

InsertInsert

InsertInsert

Real-Time Operational Conversions

Visibility into individual transactions

12

Filtering

Row filtering allows you to select rows

Column filtering allows you to select columns

ROW SELECT

REP_NO = 25

CUST_NO L_NAME F_NAME PHONE REP_NO

58699 Smith John 404-555-3874 45

37283 Duggan Ira 613-555-8367 25

89863 Quinn Fran 905-555-1296 11

89732 Muntz Muntz 704-555-2738 25

CUST_NO L_NAME F_NAME REP_NO

37283 Duggan Ira 25

89732 Muntz Josie 25

13

Transformations

EMP LAST FIRST HIRE_DATE STAT SALARY MAX

1234 Moreiro Nicole 01/05/97 A $55,000 $60,000

2345 Ellison Val 04/12/97 I $40,000 $50,000

EMP_ID FULL_NAME HIRE_DATE STATUS %SALARYMAX

001234 Nicole Moreiro 01/05/1997 Active 92%

002345 Val Ellison 04/12/1997 Inactive 80%

Increase Field Size

Concatenation Century Dates

Transform Fields

Derived Fields

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>

Order Number Order Date Product Code Customer Code

S906 02/14/05 X5PR CUS112

Customer Code

Customer Name

Customer Address 1

Customer Address 2

CUS112 ABC Delivery1234 Avenue

StWaterloo

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

ERPEvent Server

CRM

Content based routing

Purchase Order

Customer Information

Message Queue

Message Queue

Message Queue

16

Business Problems

……DataMirror has the right tools today…

Data Protection for

High Availability and

Disaster Recovery

Mitigate risk and offload production systems

Real-time Integration

for Business Intelligence

and Reporting

Yesterday’s data inadequate for inventory and purchasing decisions

Integration of Production

Data for e-Business

Applications

Up to date information flowing to and from web applications

Real-time Event

Detection

Pro-actively monitor and respond to business changes

17

Thank You

Paul O’HaganSenior Solutions Architect

905-415-0310 x305pohagan@datamirror.com

18

Customer Examples

Loading an ODS Real Time BI Application Integration Batch Window Elimination eBusiness Enablement

19

Redo Log

Sun Solaris ORACLE Apps 11i

Point of Sale System

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

21iSeriesWeb

Access

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

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

Business & Technology Driver:Real-Time Supply Chain Visibility, On-line Gift Registry synchronized in real-time

OS/390

Stage AS/400

Data Centres

Flow of information fromOS/390 (host) to stage to data centres

Flow of informationfrom individual data centres to OS/390 (host)

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

26

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

27

28

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

29

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

30

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