MDM case study cross brand integration.pptx - Stream Integration

triangledriprockInternet και Εφαρμογές Web

7 Αυγ 2012 (πριν από 4 χρόνια και 10 μήνες)

359 εμφανίσεις

May, 2011

Case Study:

MDM and Cross Brand
Implementation



2

© Copyright 2010 Stream Integration | Confidential

DRAFT



Context

»
Fortune 500 integrated manufacturer

»
Line of business: Corporate headquarters, Sales & Marketing


»
The client narrative

“For any company to grow in the marketplace, a deeper understanding of their
customers is key and must be built upon a solid, information
-
led transformation agenda.

Many companies are challenged to answer basic questions like:

-

who are our top customers?

-

how many customers do we have?

-
how much business did we do with a specific customer?

The go
-
forward growth strategy is founded on a better understanding of the customer”


»
The technical narrative

»
IBM Mainframe environment for
DB2 data
bases

»
WebSphere as the application servers





3

© Copyright 2010 Stream Integration | Confidential

DRAFT

Business Need

»
Support the creating and maintenance of the organizations “book of business” that will
enhance the Sales & Marketing organization to drive top
-
line revenue

»
Specifically,


Enhance identification of current customer organizations and organizations that are not
current customers


Enhance information about customers to support better customer and marketing
analytics


Rationalize the view of the customers and reduce or eliminate the many stove
-
piped
customer databases

4

© Copyright 2010 Stream Integration | Confidential

DRAFT

Technical Solution

Component

Contribution to the Solution

MDM Server

MDM Server provided CRUD

services for organizations
(customers) and organizational hierarchies. MDM manages
logic for Sales planning cycles

ETL Engine

DataStage organizes

data for distribution to consuming
systems

External

Rules Engine

Java
-
based engine manages rules

that govern the creation
and maintenance of client organizations

Legacy Customer Data Base

Legacy

data store. Will be retired

User Interface

General user interface for the creation and maintenance of
customers and their hierarchies. Also an advanced, data
stewardship interface

ETL for Data

Integration

DataStage engine manages batch transfer

of data between
components, including the
management of

business
transformations and data rules

MQ for Data Integration

Manages real time exchange of data between systems

5

© Copyright 2010 Stream Integration | Confidential

DRAFT

Distributed

Mainframe

High Level Context for WCC Usage for Basel II Compliance

S
D

Future Channel
Applications
On
-
Line
Application
(Life Cycle)

Acxiom

Data
Sources
MDM
Data
Subscribers
ESB
ETL HUB
MDM Data Store

DB2 7.1

MDM Application Server
WCC 7.0

Project Summary
-

Deliver CDI solution incorporating major Websphere
components: DataStage (WDS), QualityStage (WQS), Message
Broker (WBI). External applications included mainframe/green
screen apps, Web apps and DataStage. Supported various
interfaces to WCC include WBI, WICS (legacy B2B message broker)
and WCC Batch Framework


Project Duration



12 Months


Special Aspects

-

Java composites incorporate delta

management logic, mitigating complexity
of front
-
end

application development Integration with
other

Websphere components: DataStage,
QualityStage, WBI


Initial load Integration layer


-

Batch Framework

Delta load Integration layer



-

WBI

On
-
Line Integration layer



-

WBI & WICS

Project Customizations



2 XML composites


6 Java composites


Minor model modifications


Minor DTD modifications


# of Party Records



450 Million

# of Account Records



500 Million

# of Concurrent Users



15 Initial

Initial Load Volume



450K

Delta Loan Volume



4K Nightly

Datastage

Oracle

MDM Enterprise Data Sources


Legacy CIF Files

Create a page that looks like
this

6

© Copyright 2010 Stream Integration | Confidential

DRAFT

»
Enable Sales & Marketing to organize to deploy to under
-
served and un
-
served clients

»
Enhanced customer and marketing analytics by improved linkage to firmographic data in
external reference sources (e.g., Dun&Bradstreet).

»
Improved ability for different parts of the organization to engage a single client in a unified
and coordinated manner

»
Simplified management of large client organizations

»
Simplifies data views of existing clients

Benefits