128 lines
12 KiB
Plaintext
128 lines
12 KiB
Plaintext
<mxfile host="Electron" agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) draw.io/26.0.4 Chrome/128.0.6613.186 Electron/32.2.5 Safari/537.36" version="26.0.4">
|
|
<diagram id="C5RBs43oDa-KdzZeNtuy" name="Page-1">
|
|
<mxGraphModel dx="1434" dy="844" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
|
|
<root>
|
|
<mxCell id="WIyWlLk6GJQsqaUBKTNV-0" />
|
|
<mxCell id="WIyWlLk6GJQsqaUBKTNV-1" parent="WIyWlLk6GJQsqaUBKTNV-0" />
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-3" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="WIyWlLk6GJQsqaUBKTNV-3" target="Pj3-XqvsJGA5nLsvHgkQ-2" edge="1">
|
|
<mxGeometry relative="1" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="WIyWlLk6GJQsqaUBKTNV-3" value="Aufruf von SQL Prozedur:<br>[PRDEX_COLLECT_INPUT]" style="rounded=1;whiteSpace=wrap;html=1;fontSize=12;glass=0;strokeWidth=1;shadow=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
|
|
<mxGeometry x="305" y="160" width="190" height="40" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-1" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="Pj3-XqvsJGA5nLsvHgkQ-0" target="WIyWlLk6GJQsqaUBKTNV-3" edge="1">
|
|
<mxGeometry relative="1" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-0" value="START<br>Zeitplan oder <br>externer Auslöser" style="ellipse;whiteSpace=wrap;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
|
|
<mxGeometry x="340" y="42" width="120" height="80" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-5" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="Pj3-XqvsJGA5nLsvHgkQ-2" target="Pj3-XqvsJGA5nLsvHgkQ-4" edge="1">
|
|
<mxGeometry relative="1" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-2" value="Lese von SQL Tabelle:<br>[TBDEX_CONFIG_PROFILE]<br><br>Parameter: Name, LogLevel,..." style="whiteSpace=wrap;html=1;rounded=1;glass=0;strokeWidth=1;shadow=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
|
|
<mxGeometry x="305" y="229" width="190" height="80" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-7" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="Pj3-XqvsJGA5nLsvHgkQ-4" target="Pj3-XqvsJGA5nLsvHgkQ-6" edge="1">
|
|
<mxGeometry relative="1" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-10" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="Pj3-XqvsJGA5nLsvHgkQ-4" target="Pj3-XqvsJGA5nLsvHgkQ-9" edge="1">
|
|
<mxGeometry relative="1" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-4" value="Daten für Export vorhanden?" style="rhombus;whiteSpace=wrap;html=1;rounded=1;glass=0;strokeWidth=1;shadow=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
|
|
<mxGeometry x="340" y="341.5" width="120" height="99.5" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-6" value="EXIT<br>ggf. Log" style="ellipse;whiteSpace=wrap;html=1;rounded=1;glass=0;strokeWidth=1;shadow=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
|
|
<mxGeometry x="560" y="351.25" width="80" height="80" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-8" value="Nein" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
|
|
<mxGeometry x="466" y="362" width="60" height="30" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-13" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="Pj3-XqvsJGA5nLsvHgkQ-9" edge="1">
|
|
<mxGeometry relative="1" as="geometry">
|
|
<mxPoint x="400" y="616.625" as="targetPoint" />
|
|
</mxGeometry>
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-9" value="Schreibe in SQL Tabelle:<br style="border-color: var(--border-color);">[TBDEX_INPUT]<br><br>PK zu Daten für Export" style="whiteSpace=wrap;html=1;rounded=1;glass=0;strokeWidth=1;shadow=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
|
|
<mxGeometry x="305" y="492" width="190" height="70" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-11" value="Ja" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
|
|
<mxGeometry x="386" y="462" width="60" height="30" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-22" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="Pj3-XqvsJGA5nLsvHgkQ-14" target="Pj3-XqvsJGA5nLsvHgkQ-21" edge="1">
|
|
<mxGeometry relative="1" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-24" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="Pj3-XqvsJGA5nLsvHgkQ-14" target="Pj3-XqvsJGA5nLsvHgkQ-23" edge="1">
|
|
<mxGeometry relative="1" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-14" value="Aufruf von SQL Prozedur:<br>[PRDEX_PROFILE_EXECUTION]" style="whiteSpace=wrap;html=1;rounded=1;glass=0;strokeWidth=1;shadow=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
|
|
<mxGeometry x="305" y="601.75" width="190" height="41.25" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-16" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;dashed=1;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="Pj3-XqvsJGA5nLsvHgkQ-15" target="WIyWlLk6GJQsqaUBKTNV-3" edge="1">
|
|
<mxGeometry relative="1" as="geometry">
|
|
<mxPoint x="246" y="181" as="targetPoint" />
|
|
</mxGeometry>
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-18" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=0.5;exitY=1;exitDx=0;exitDy=0;dashed=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="Pj3-XqvsJGA5nLsvHgkQ-15" edge="1">
|
|
<mxGeometry relative="1" as="geometry">
|
|
<mxPoint x="300" y="610" as="targetPoint" />
|
|
<Array as="points">
|
|
<mxPoint x="135" y="610" />
|
|
</Array>
|
|
</mxGeometry>
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-15" value="Lese von SQL Tabelle:<br>[TBDEX_CONFIG_RESOURCES]<br><br>Variablen und Funktionen" style="rounded=1;whiteSpace=wrap;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
|
|
<mxGeometry x="60" y="134" width="200" height="93" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-30" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="Pj3-XqvsJGA5nLsvHgkQ-21" target="Pj3-XqvsJGA5nLsvHgkQ-29" edge="1">
|
|
<mxGeometry relative="1" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-21" value="Schreibe in SQL Tabelle:<br>[TBDEX_TEMP_PROCESS]<br><br>Zähler zum Export Vorgang" style="whiteSpace=wrap;html=1;rounded=1;glass=0;strokeWidth=1;shadow=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
|
|
<mxGeometry x="190" y="720" width="170" height="80" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-28" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="Pj3-XqvsJGA5nLsvHgkQ-23" target="Pj3-XqvsJGA5nLsvHgkQ-27" edge="1">
|
|
<mxGeometry relative="1" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-23" value="Schreibe in SQL Tabelle:<br>[TBDEX_TEMP_CONTENT]<br><br>Daten zum Export Vorgang" style="whiteSpace=wrap;html=1;rounded=1;glass=0;strokeWidth=1;shadow=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
|
|
<mxGeometry x="440" y="720" width="160" height="80" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-26" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.75;entryDx=0;entryDy=0;dashed=1;strokeColor=default;startArrow=classic;startFill=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" source="Pj3-XqvsJGA5nLsvHgkQ-25" target="Pj3-XqvsJGA5nLsvHgkQ-14" edge="1">
|
|
<mxGeometry relative="1" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-25" value="Lese/Schreibe SQL Tabelle:<br>[TBDEX_CONFIG_NUMBER_RANGE]" style="rounded=1;whiteSpace=wrap;html=1;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
|
|
<mxGeometry x="10" y="640" width="220" height="60" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="4reIC0GdjGwffdaKzI53-2" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;entryX=0.5;entryY=0;entryDx=0;entryDy=0;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="Pj3-XqvsJGA5nLsvHgkQ-27" target="4reIC0GdjGwffdaKzI53-0">
|
|
<mxGeometry relative="1" as="geometry">
|
|
<mxPoint x="380" y="1030" as="targetPoint" />
|
|
<Array as="points">
|
|
<mxPoint x="520" y="990" />
|
|
<mxPoint x="399" y="990" />
|
|
</Array>
|
|
</mxGeometry>
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-27" value="Schreibe in SQL Tabelle:<br>[TBDEX_OUTPUT_REFERENCES]" style="whiteSpace=wrap;html=1;rounded=1;glass=0;strokeWidth=1;shadow=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
|
|
<mxGeometry x="410" y="890" width="220" height="60" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="4reIC0GdjGwffdaKzI53-1" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="Pj3-XqvsJGA5nLsvHgkQ-29" target="4reIC0GdjGwffdaKzI53-0">
|
|
<mxGeometry relative="1" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="Pj3-XqvsJGA5nLsvHgkQ-29" value="Schreibe in SQL Tabelle:<br>[TBDEX_OUTPUT]" style="whiteSpace=wrap;html=1;rounded=1;glass=0;strokeWidth=1;shadow=0;" parent="WIyWlLk6GJQsqaUBKTNV-1" vertex="1">
|
|
<mxGeometry x="190" y="890" width="170" height="60" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="4reIC0GdjGwffdaKzI53-0" value="Abruf über SQL View:<br>[VWDEX_OUTPUT]" style="whiteSpace=wrap;html=1;rounded=1;glass=0;strokeWidth=1;shadow=0;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
|
|
<mxGeometry x="339" y="1030" width="120" height="60" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="4reIC0GdjGwffdaKzI53-3" value="Lese SQL Tabellen:<br>[TBDEX_CONFIG_OUTPUT_XXX]" style="rounded=1;whiteSpace=wrap;html=1;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
|
|
<mxGeometry x="570" y="630" width="220" height="60" as="geometry" />
|
|
</mxCell>
|
|
<mxCell id="4reIC0GdjGwffdaKzI53-6" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="4reIC0GdjGwffdaKzI53-3" target="Pj3-XqvsJGA5nLsvHgkQ-14">
|
|
<mxGeometry relative="1" as="geometry">
|
|
<mxPoint x="470" y="401" as="sourcePoint" />
|
|
<mxPoint x="570" y="401" as="targetPoint" />
|
|
</mxGeometry>
|
|
</mxCell>
|
|
</root>
|
|
</mxGraphModel>
|
|
</diagram>
|
|
</mxfile>
|