-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdata_integration.drawio
More file actions
126 lines (126 loc) · 16.7 KB
/
data_integration.drawio
File metadata and controls
126 lines (126 loc) · 16.7 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<mxfile host="app.diagrams.net" agent="Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36" version="26.0.3">
<diagram name="CRM & ERP" id="hLIjLHAYCb3o381HsihC">
<mxGraphModel dx="1434" dy="1985" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="1920" pageHeight="1200" math="0" shadow="0">
<root>
<mxCell id="3UP7FawPSVQ9M-GqKKiO-0" />
<mxCell id="3UP7FawPSVQ9M-GqKKiO-1" parent="3UP7FawPSVQ9M-GqKKiO-0" />
<mxCell id="gd-LYYQTuDr1hK2L6fpe-44" value="" style="rounded=1;whiteSpace=wrap;html=1;arcSize=6;fillColor=none;dashed=1;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="160" y="-910" width="810" height="660" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-46" value="" style="rounded=1;whiteSpace=wrap;html=1;arcSize=6;fillColor=none;dashed=1;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="1210" y="-910" width="460" height="650" as="geometry" />
</mxCell>
<mxCell id="3UP7FawPSVQ9M-GqKKiO-40" value="<font style=""><b>Data Integration&nbsp;</b><font style="font-size: 20px;">(how to tables are related)</font><br style="font-size: 38px;"></font>" style="text;html=1;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;whiteSpace=wrap;rounded=1;fontSize=38;fontFamily=Helvetica;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="30" y="-1160" width="770" height="54" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-4" value="crm_cust_info" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=40;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;rounded=1;fillColor=#dae8fc;strokeColor=#6c8ebf;fontSize=24;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="640" y="-530" width="270" height="150" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-5" value="cst_id" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;fontSize=23;sketch=1;curveFitting=1;jiggle=2;" parent="gd-LYYQTuDr1hK2L6fpe-4" vertex="1">
<mxGeometry y="40" width="270" height="40" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-27" value="cst_key" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;fontSize=23;sketch=1;curveFitting=1;jiggle=2;" parent="gd-LYYQTuDr1hK2L6fpe-4" vertex="1">
<mxGeometry y="80" width="270" height="40" as="geometry" />
</mxCell>
<mxCell id="bEobllu9cBh29OJUA82D-7" value="CUSTOMER" style="text;html=1;strokeColor=#82b366;fillColor=#d5e8d4;align=center;verticalAlign=middle;whiteSpace=wrap;overflow=hidden;fontSize=20;fontStyle=1;sketch=1;curveFitting=1;jiggle=2;" parent="gd-LYYQTuDr1hK2L6fpe-4" vertex="1">
<mxGeometry y="120" width="270" height="30" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-8" value="<font style="font-size: 18px;">Customer Information</font>" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;fontSize=18;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="645" y="-560" width="260" height="30" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-9" value="crm_prd_info" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=40;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;rounded=1;fillColor=#dae8fc;strokeColor=#6c8ebf;fontSize=24;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="640" y="-796" width="270" height="110" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-10" value="prd_key" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;fontSize=23;sketch=1;curveFitting=1;jiggle=2;" parent="gd-LYYQTuDr1hK2L6fpe-9" vertex="1">
<mxGeometry y="40" width="270" height="40" as="geometry" />
</mxCell>
<mxCell id="bEobllu9cBh29OJUA82D-4" value="PRDOUCT" style="text;html=1;strokeColor=#b85450;fillColor=#f8cecc;align=center;verticalAlign=middle;whiteSpace=wrap;overflow=hidden;fontSize=20;fontStyle=1;sketch=1;curveFitting=1;jiggle=2;" parent="gd-LYYQTuDr1hK2L6fpe-9" vertex="1">
<mxGeometry y="80" width="270" height="30" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-11" value="<font style="font-size: 18px;">Current &amp; History Product Infromation</font>" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;fontSize=18;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="590" y="-826" width="360" height="30" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-15" value="crm_sales_details" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=40;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;rounded=1;fillColor=#dae8fc;strokeColor=#6c8ebf;fontSize=24;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="216" y="-693" width="270" height="150" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-16" value="prd_key" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;fontSize=23;sketch=1;curveFitting=1;jiggle=2;" parent="gd-LYYQTuDr1hK2L6fpe-15" vertex="1">
<mxGeometry y="40" width="270" height="40" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-20" value="cst_id" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;fontSize=23;sketch=1;curveFitting=1;jiggle=2;" parent="gd-LYYQTuDr1hK2L6fpe-15" vertex="1">
<mxGeometry y="80" width="270" height="40" as="geometry" />
</mxCell>
<mxCell id="bEobllu9cBh29OJUA82D-11" value="SALES" style="text;html=1;strokeColor=#9673a6;fillColor=#e1d5e7;align=center;verticalAlign=middle;whiteSpace=wrap;overflow=hidden;fontSize=20;fontStyle=1;sketch=1;curveFitting=1;jiggle=2;" parent="gd-LYYQTuDr1hK2L6fpe-15" vertex="1">
<mxGeometry y="120" width="270" height="30" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-17" value="<font style="font-size: 18px;">Transactional Records about Sales &amp; Orders</font>" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;fontSize=18;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="218.5" y="-733" width="265" height="30" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-22" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;entryX=0;entryY=0.5;entryDx=0;entryDy=0;endArrow=none;endFill=0;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" source="gd-LYYQTuDr1hK2L6fpe-20" target="gd-LYYQTuDr1hK2L6fpe-5" edge="1">
<mxGeometry relative="1" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-23" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;entryX=0;entryY=0.5;entryDx=0;entryDy=0;endArrow=none;endFill=0;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" source="gd-LYYQTuDr1hK2L6fpe-16" target="gd-LYYQTuDr1hK2L6fpe-10" edge="1">
<mxGeometry relative="1" as="geometry">
<mxPoint x="530" y="-660" as="sourcePoint" />
</mxGeometry>
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-24" value="erp_cust_az12" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=40;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;rounded=1;fillColor=#fff2cc;strokeColor=#d6b656;fontSize=24;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="1304" y="-581" width="270" height="110" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-25" value="cid" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;fontSize=23;sketch=1;curveFitting=1;jiggle=2;" parent="gd-LYYQTuDr1hK2L6fpe-24" vertex="1">
<mxGeometry y="40" width="270" height="40" as="geometry" />
</mxCell>
<mxCell id="bEobllu9cBh29OJUA82D-9" value="CUSTOMER" style="text;html=1;strokeColor=#82b366;fillColor=#d5e8d4;align=center;verticalAlign=middle;whiteSpace=wrap;overflow=hidden;fontSize=20;fontStyle=1;sketch=1;curveFitting=1;jiggle=2;" parent="gd-LYYQTuDr1hK2L6fpe-24" vertex="1">
<mxGeometry y="80" width="270" height="30" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-26" value="<font style="font-size: 18px;">Extra Customer Information (Birthdate)</font>" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;fontSize=18;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="1254" y="-611" width="360" height="30" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-35" value="erp_loc_a101" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=40;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;rounded=1;fillColor=#fff2cc;strokeColor=#d6b656;fontSize=24;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="1303" y="-400" width="270" height="110" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-36" value="cid" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;fontSize=23;sketch=1;curveFitting=1;jiggle=2;" parent="gd-LYYQTuDr1hK2L6fpe-35" vertex="1">
<mxGeometry y="40" width="270" height="40" as="geometry" />
</mxCell>
<mxCell id="bEobllu9cBh29OJUA82D-10" value="CUSTOMER" style="text;html=1;strokeColor=#82b366;fillColor=#d5e8d4;align=center;verticalAlign=middle;whiteSpace=wrap;overflow=hidden;fontSize=20;fontStyle=1;sketch=1;curveFitting=1;jiggle=2;" parent="gd-LYYQTuDr1hK2L6fpe-35" vertex="1">
<mxGeometry y="80" width="270" height="30" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-37" value="<font style="font-size: 18px;">Location of Customers (Country)</font>" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;fontSize=18;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="1251" y="-430" width="360" height="30" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-40" value="erp_px_cat_g1v2" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=40;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;rounded=1;fillColor=#fff2cc;strokeColor=#d6b656;fontSize=24;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="1299" y="-797" width="270" height="110" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-41" value="id" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;whiteSpace=wrap;html=1;fontSize=23;sketch=1;curveFitting=1;jiggle=2;" parent="gd-LYYQTuDr1hK2L6fpe-40" vertex="1">
<mxGeometry y="40" width="270" height="40" as="geometry" />
</mxCell>
<mxCell id="bEobllu9cBh29OJUA82D-6" value="PRDOUCT" style="text;html=1;strokeColor=#b85450;fillColor=#f8cecc;align=center;verticalAlign=middle;whiteSpace=wrap;overflow=hidden;fontSize=20;fontStyle=1;sketch=1;curveFitting=1;jiggle=2;" parent="gd-LYYQTuDr1hK2L6fpe-40" vertex="1">
<mxGeometry y="80" width="270" height="30" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-42" value="<font style="font-size: 18px;">Product Categories</font>" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;fontSize=18;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="1249" y="-826" width="360" height="30" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-43" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;entryX=1;entryY=0.5;entryDx=0;entryDy=0;endArrow=none;endFill=0;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" source="gd-LYYQTuDr1hK2L6fpe-41" target="gd-LYYQTuDr1hK2L6fpe-10" edge="1">
<mxGeometry relative="1" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-45" value="<font style="font-size: 35px;"><b>CRM</b></font>" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#dae8fc;strokeColor=#6c8ebf;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="470" y="-940" width="230" height="50" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-47" value="<font style="font-size: 35px;"><b>ERP</b></font>" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#fff2cc;strokeColor=#d6b656;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="1320" y="-940" width="230" height="50" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-48" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;entryX=1;entryY=0.5;entryDx=0;entryDy=0;endArrow=none;endFill=0;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" source="gd-LYYQTuDr1hK2L6fpe-36" target="gd-LYYQTuDr1hK2L6fpe-27" edge="1">
<mxGeometry relative="1" as="geometry" />
</mxCell>
<mxCell id="gd-LYYQTuDr1hK2L6fpe-49" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;entryX=1;entryY=0.5;entryDx=0;entryDy=0;endArrow=none;endFill=0;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" source="gd-LYYQTuDr1hK2L6fpe-25" target="gd-LYYQTuDr1hK2L6fpe-27" edge="1">
<mxGeometry relative="1" as="geometry" />
</mxCell>
<mxCell id="ewpIsNDN0GunfStNLF3E-1" value="<font style="font-size: 18px;">Customer Relationship Management</font>" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;fontSize=18;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="410" y="-980" width="360" height="30" as="geometry" />
</mxCell>
<mxCell id="ewpIsNDN0GunfStNLF3E-2" value="<font style="font-size: 18px;">Enterprise Resource Planning</font>" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;fontSize=18;sketch=1;curveFitting=1;jiggle=2;" parent="3UP7FawPSVQ9M-GqKKiO-1" vertex="1">
<mxGeometry x="1250" y="-971" width="360" height="30" as="geometry" />
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>