Transcript Corporate Presentation

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
2
Industries










Telecommunications
Manufacturing
Education
Government & NGO’s
Technology
Financial Services
Healthcare
Insurance
Retail
Services
3
Real-Time Data Integration
Event Detection
Application Integration
E-Business
BI
Audit
HA
Business
Value
Environmental Complexity
4
Market Drivers
5
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
6
Your Challenges






Data volumes high – and increasing
Systems strained
Pressure to streamline operations
Heterogeneous environment
Uptime requirements
Risk management
Usable, Manageable, Scalable
7
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
8
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
9
Architecture
Publisher
Java-based GUI
Unified Admin Point
With Monitoring
Subscriber
Database
Operational
Data Store
TCP/IP
Journal Log
Redo/Archive Logs
Publisher Engine
And Metadata
Message
Queue
Subscriber Engine
And Metadata
Web
Services
Business
Process
10
Information Awareness
 Visibility into individual transactions
Real-Time Operational Conversions
Insert
Insert
Update
Insert
Delete
Insert
11
Filtering
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
ROW SELECT
 Row filtering allows you to select rows
 Column filtering allows you to select columns
REP_NO = 25
CUST_NO
L_NAME
F_NAME
REP_NO
37283
Duggan
Ira
25
89732
Muntz
Josie
25
12
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
Increase
Field Size
Concatenation
Century
Dates
Transform
Fields
Derived
Fields
EMP_ID
FULL_NAME
HIRE_DATE
STATUS
%SALARYMAX
001234
Nicole Moreiro
01/05/1997
Active
92%
002345
Val Ellison
04/12/1997
Inactive
80%
13
XML Mapping
CUSTOMER ORDER TABLE
Order Number
Order Date
Product Code
Customer Code
S906
02/14/05
X5PR
CUS112
CUSTOMER TABLE
Customer
Code
Customer
Name
Customer
Address 1
Customer
Address 2
CUS112
ABC Delivery
1234 Avenue St
Waterloo
<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>
14
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
15
Business Problems
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
Data Protection for
High Availability and
Disaster Recovery
Real-time Event
Detection


Mitigate risk and offload
production systems
Pro-actively monitor and respond
to business changes
……DataMirror has the right tools today…
16
Thank You
Paul O’Hagan
Senior Solutions Architect
905-415-0310 x305
[email protected]
17
Customer Examples





Loading an ODS
Real Time BI
Application Integration
Batch Window Elimination
eBusiness Enablement
18
Sun Solaris
ORACLE
Apps 11i
Point of Sale
System
Redo Log
ODS
Sun Solaris
ORACLE
9iR2
Enterprise
Data
Warehouse
19

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
20
Business Solutions – Secure Public Web Access to court information – Workload
balancing by offloading reporting to Oracle
iSeries
Web
Access21
 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.
22
OS/390
Flow of information from
OS/390 (host) to stage to data centres
Stage AS/400
Flow of information
from individual
data centres to
OS/390 (host)
Data Centres
Business & Technology Driver:
Real-Time Supply Chain Visibility, On-line Gift Registry synchronized in real-time
23
 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
24
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
27
 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
28
Business Solutions – Online Gift Registry synchronized bi-directionally in real-time with
production data, Real-time Business Intelligence for better decision making
29
 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
30