7 billion (CDN) - Canadian Tire Corporation, Limited i - PowerPoint PPT Presentation

Loading...

PPT – 7 billion (CDN) - Canadian Tire Corporation, Limited i PowerPoint presentation | free to download - id: 101ec-MjRmO



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

7 billion (CDN) - Canadian Tire Corporation, Limited i

Description:

7 billion (CDN) - Canadian Tire Corporation, Limited is Canada's most ... 90% of Canadians shop at a Canadian Tire store, 40% are in our stores every week ... – PowerPoint PPT presentation

Number of Views:239
Avg rating:3.0/5.0
Slides: 28
Provided by: ccli3
Learn more at: http://www.irmac.ca
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: 7 billion (CDN) - Canadian Tire Corporation, Limited i


1
Canadian Tire Corporation, Limited
  • IRMAC
  • Enterprise Application Integration
  • Ken Dschankilic, Manager Integration Architecture
  • April 16, 2003

2
Agenda
  • Who is Canadian Tire
  • EAI Defined
  • The Integration Problem
  • Integration Frameworks
  • Integration Design Patterns
  • Dave Callinghams EAI Components
  • Integration at Canadian Tire
  • Q A

3
Today, we are an inter-related family of
businesses
Customer Count 172.1MM Retail Sales
5529.5MM
Customer Count8.7 million Retail Sales 510.4MM
Customer Count 226.8MM Retail Sales 7.4
Billion
Customer Count 1.7MM Retail Sales 53.4MM
Customer Count 40.1MM Retail Sales 911.9MM
Customer Count 4.2MM GOR 352.3MM
4
Canadian Tire Corporation, Limited
  • 7 billion (CDN) - Canadian Tire Corporation,
    Limited is Canadas most shopped retailer
  • More than 1,000 retail outlets (Canadian Tire
    Associate Stores, Gas Bars, Marks outlets)
    across Canada
  • More than 45,000 employees
  • More than 25 million customer transactions each
    year
  • 90 of Canadians shop at a Canadian Tire store,
    40 are in our stores every week

5
Canadian Tire Corporation, Limited
  • Canadian Tire Petroleum is the countrys largest
    independent retailer of gasoline
  • 203 gas bars
  • 21 Simoniz car washes
  • Canadian Tire Money is the most widely
    recognized loyalty program in Canadian retail
  • Canadian Tire Financial Services is the largest
    non-bank issuer of MasterCard in Canada
  • Our website ended 2001 among the countrys top
    three e-commerce websites

6
EAI Defined
7
What is Application Integration
  • Yankee Group
  • the continuous process of improving the
    enterprises entire information technology
    base-applications, information, communications,
    and infrastructure to support the business.
  • Gartner Group says
  • Application integration is defined as making
    independently designed application systems work
    together.
  • Mercator
  • EAI is the process of integrating different
    applications to enable an enterprise to
    communicate with a single voice.

8
The Integration Problem
Imagine if you didnt have common electric
outlets and plugs in your house, and every time
you bought a new appliance, you had to wire up
the appliance to the wires in your wall. And
everybodys wires in everybodys walls were
different. And everybodys appliance wiring was
different. Thats really the way it works today
with trying to integrate business software
applications. - Paul Margolis, past chairman of
the OAG, Inc.
9
The Integration Problem
  • Multiple, disparate applications
  • Multiple platforms
  • Multiple databases
  • Multiple transaction processors
  • Multiple data entry points
  • Multiple versions of the same data
  • Incompatible business data

10
Factors Contributing to the Problem
  • Application systems are built at different times
    by different groups operating independently of
    each other
  • Organizations are stuck w/ incompatible
    architectures and hard-to-maintain, but
    harder-to-eliminate legacy applications
  • Organizations are embracing a buy before build
    strategy that favours purchased application
    packages over internal development

11
ITs Dirty Little Secret
Application System B
Extract
Down load file
Extract
trans-action file
Load
Down load file
Program
Load
Program
Update
Down load file
Extract
Load
Database Replicator
Program
Extract
Load
Down load file
Planning Systems
Program
Program
Application System A
Application System C
12
Integration Framework
  • Need a systematic approach to the problem
  • No E.F. Codd of Integration
  • No mathematical basis
  • No relevant academic leadership
  • Multiple Vendor Specific Frameworks
  • unlike DBMS marketplace where DB implementations
    are similar
  • Integration Software vendors have widely
    different implementation frameworks

13
Integration Framework
  • Standards only recently impact integration design
    patterns
  • in the DBMS marketplace, standards were
    established early in the development life cycle
  • in the Integration marketplace, only w/in the
    last 2 years have standards such as XML, Web
    Services emerged

14
Integration Framework
  • A Framework is required for integration
  • Adapters
  • Transformation
  • Asynchronous messaging
  • Intelligent Routing
  • Business Process Management
  • Canonical Messages

15
Integration Patterns
  • 3 Main Patterns to solve the integration
    problems
  • Data Consistency
  • asynchronous, loosely coupled
  • Multi-Step Business Process
  • asynchronous, loosely coupled
  • Composite Application Integration
  • synchronous, tightly coupled

16
Data Consistency Pattern
Add UPC 17988
Add prod 1234
Add prod 1234
Add item 050 1234
17
Multi-Step Business Processes Pattern
Ship Notice 981126
Alloc Order 981126
Ship Notice 981126
Alloc Order 981126
StoreOrder 981126
StoreOrder 981126
18
Composite Application Pattern
Legacy Applications
Purchased application packages
New code data
Check Credit
Check Logistics
Check Inventory
Place Order
19
Vendor Implementations
20
Integration at CTC
21
What needed to be fixed
  • Organization issues
  • where does the Competency Centre reside
  • who does the work
  • Methodology
  • no consistent way to document interfaces
  • Exception Management
  • escalation process of data issues.

22
Key Data Issues
  • Data Quality
  • Data Consistency
  • Data Ownership
  • Semantic Knowledge and Behaviour
  • Latency
  • Formats

23
Hub and Spoke Pattern
Hub Spoke
Point to Point
Hub and spoke organizing principles 1. Dont
connect anything directly to anything 2.
Applications are autonomous and share no
databases directly 3. Knowledge of
interconnections removed from source and
targets and moved to the hub
Benefits 1. Operational simplification 2.
Adaptation to change 3. Reuse leverage
24
CTC Integration Infrastructure
  • 2 Brokers are in place
  • Homegrown Broker supports near-time integration
    patterns
  • Broker is MVS based using MQSeries to connect to
    applications on
  • AS/400, NT, DEC/ALPHA, AIX, MVS
  • Mercator supports batch integration patterns
  • Mercator is used for most of the transformations
  • Bulk data movement is done using homegrown File
    Transfer/MQSeries

25
CTC Integration Infrastructure
  • 150 interfaces
  • 40 w/ re-usable objects (source/target/mapping
    objects)
  • 45 applications involved in integration with the
    Broker
  • Real-time messaging a combo of XML and ASCII
    payloads
  • 4000 FT/MQ per day
  • 450 Queue Managers

26
What Worked
  • Re-use of infrastructure
  • FT/MQ, Maps
  • Mercator for batch legacy data recently XML,
    DB2 MQ Adapters (95)
  • Messaging - APIs (5)
  • Methodology Design Patterns
  • Competency Centre
  • IMS Bridge to unlock legacy transactions
  • Phased rollout - unplug old-turn on new functions
    at the hub

27
Canadian Tire Corporation, Limited
  • IRMAC
  • Enterprise Application Integration
  • Ken Dschankilic, Manager Integration Architecture
  • April 16, 2003
About PowerShow.com