Transcript SC_MDM_ImplementationDetails_Scardx

MDM Implementation Details
[for S* Card Next Generation System]
1-
1. MDM Use Cases
1.
2.
3.
4.
MDM system manages multiple data domains.
Each domain consists of 1 or more base objects.
Each domain also has different source systems; some of them have multiple source systems.
Three ways to create master data; each data domain has its fixed source interface(s)
• Online Sync Interfaces – Real-time interface with the source systems
• Batch File Interfaces – Daily processing of the incoming file data
• IDD User Interfaces – IDD controls the master data Life Cycle Management with enterprise workflow system
5. Two ways to publish master data; each data domain can be configured to publish data to the requesting
target systems
• Online Sync Interfaces – Real-time interface to the target systems
• Batch File Interfaces – Daily processing of the outgoing file data
MDM
Data Domains
Online
Source
Systems
Party
1 Parent + n Children
Organization
Online
Target
Systems
Employee
Batch
Source
Systems
Master 1
Master 2
MDM IDD
Master 3
-2-
Batch
Target
Systems
2. MDM Deployment Architecture
MDM – 6 Jboss instances on each node ; 2 for interfaces, 2 for hub instances, 2 for cleanse instances
1 hub instance(H101) for processing SIF interfaces, the other (O101) for IDD connection only.
PWC – 2 Integration services on one Powercenter domain.
MDM AP1
A
W101 Service Domain
JBOSS
Cluster
W102 Service Domain
Other Systems
User Browser
EAI (Tibco)
L4
A
W201 Service Domain
A
MDM AP2
W202 Service Domain
H101 HUB Domain Instance
H201 HUB Domain Instance
A
JBOSS
Cluster
O101 IDD Domain Instance
O201 IDD Domain Instance
C101 Cleanse Domain
B101 Cleanse Domain
B201 Cleanse Domain
Publish Domain
C201 Cleanse Domain
Publish Domain
Agent (Tibco Queue Connection)
JBOSS Instance
A
MDM DB1
RAC
JBOSS Cluster
Distributed
Hornet Queue
PMDM
MDM DB2
SIF (EJB) Connection
Cleanse Connection
IDD Connection
JMS Connection
JMS Connection (Secondary)
Power Center
※ JMS Queue is not used to publish data any more: Queue message format is corrupted often. Only c_repos_mq_data_change table is used to publish.
-3-
3. Data Flow – Online Interfaces
A. Service domain (W) and Hub domain (H) instances are working.
B. Inbound interfaces are synchronous and outbound interfaces are all asynchronous.
W101
A
S
A
S
MDM AP1
LOB
B101
H101
C101
W102
LOB
User
PUB
Legacy
MDM DB1
EAI
EAI
RAC
MDM DB2
W201
A
B201
S
H201
A
S
W202
PUB
Legacy
C201
MDM AP2
W
MDM Service Domain
S
MDM SIF API (EJB Connection)
H
MDM HUB Domain
Normal EJB Connections
A
EAI Agent (TIPCO Queue)
C
MDM Cleanse Domain
EJB Connections on Hub instance Failover
-4-
3. Data Flow – File Interfaces
A. Powercenter is loading files into landing table and Hub instances are working batch jobs.
B. Enterprise Batch Job Controller initiates the PWC job and MDM batch job.
MDM AP1
LOB
B101
PWC
H101
PUB
C101
Legacy
MDM DB1
Batch Job
Controller
LOB
EAI
EAI
RAC
Shared
Folder
MDM DB2
B201
PWC
H201
PUB
C201
MDM AP2
H
MDM HUB Domain
C
MDM Cleanse Domain
-5-
Legacy
3. Data Flow – User Interfaces with IDD
A. MDM User creates and modifies the data through IDD with the enterprise workflow added.
B. MDM Users are controlled by the enterprise SSO(Authorization), IM(Identity), and AM(Authorization)
systematically linked to MDM SAM.
MDM AP1
LOB
B101
O101
PUB
C101
User
HTTP
Proxy
With SSO
Legacy
MDM DB1
L4
EAI
RAC
MDM DB2
B201
O201
PUB
C201
MDM AP2
O
MDM IDD Domain
C
MDM Clenase Domain
-6-
Legacy
4. MDM Usage Summary
 Summary of MDM data domains
Number of
Source
Systems(*)
Number of
Target
Systems(**)
BIZPARTY
1
Organization
Number of Total
Records
Number of Daily Inbound Transactions
6
Less than 50 million
(for parent)
Maximum of 0.2 million is expected in normal
days. 4 times a year, more than 0.5 million
transactions can be processed in a day.
2
50
Less than 10 thousand
Maximum of 1 thousand.
Employee
6
50
Less than 1 million
Maximum of 1 thousand.
Master1
1
2
Less than 1 thousand
Maximum of 100 in a year
Master2
2
1
Less than 1 thousand
Maximum of 1 thousand in a year
Master3
1
1
Less than 1 thousand
Maximum of 100 in a year
Data Domain
Online
Source
Systems
MDM
Data Domains
Party
1 Parent + n Children
Organization
Employee
Batch
Source
Systems
Online
Target
Systems
Master 1
Master 2
MDM IDD
(*) Specific numbers are not exact.
Just for reference.
(**) Target systems are increasing more
and can easily be configured to publish.
Master 3
-7-
Batch
Target
Systems
End Of Document
-8-