סיפור לקוח פיננסי - שילוב אוטומציה בבדיקות הסבות נתונים

(EDI: Electronic
Data Interchange)
EDI
1
2
XML
!
!
XML
"
XML
"
$
EDI
#
!
!
!
XML schema
1
Electronic Data Interchange (EDI) - Advantages Of Edi, How Edi Works, Security Issues, The Future Of Edi Companies, Internet, Vans, and Information
Electronic Data Interchange (EDI) - Advantages Of Edi, How Edi Free Encyclopedia of Ecommerce 2
Works, Security Issues, The Future Of Edi
!EDI
3
"
$
$
'((&
$
XML
'((
XML
<MT_CUST_ASSET_TYPE>G</MT_CUST_ASSET_TYPE>
<SUG-MUTZAR-PENSIONI>3</SUG-MUTZAR-PENSIONI>
http://www.stevetrefethen.com/blog/UsingCruiseControlNETtomanageEDIInvoiceprocessing.aspx 3
%
XML
!
XML
XML
!
G
XML
SUG-MUTZARPENSIONI
3 MT_CUST_ASSET_TYPE
XML
!
"
!
"
'((
'((&
$
!
!
!
!
!
KDT
! QTP
Excel $
Inputs
KDT
XML
XML
$
$
XPath4
%
$
5
http://www.w3schools.com/xpath/xpath_intro.asp 4
http://www.ibm.com/developerworks/xml/library/x-contain/index.html 5
)
XML
XML
6XML Schema
INPUT_XPATH
$
OUTPUT_XPATH
/Mimshak/Mutzarim/Mutzar/NetuneiMutzar/YeshutLakoach/MISPARZIHUY-LAKOACH/
/HEADER/CUSTOMER/MAT_ID/
Excel
XML schema
XML
#
$
!
$
Microsoft.XMLDOM7
XPATH
Excel
Excel $
Node.length 9 Select Nodes()8
$
$
$
$
+
+
! +
!
!
!
http://www.w3schools.com/schema/schema_intro.asp 6
http://msdn.microsoft.com/en-us/library/aa468547.aspx 7
http://msdn.microsoft.com/en-us/library/system.xml.xmlnode.selectnodes.aspx 8
http://www.w3schools.com/dom/prop_comment_length.asp 9
*
XML
XML
!
#
Excel $
$
!
XML
,(!
!
)(
KDT
!
!
"
Excel $
"
Excel $
!
QC
!
!
XML
!
!
XML schema
XML
'
!
XML Schema
!
)(-.(
KDT
QTP
!
!
EDI
%&'
KDT
. KDT
(
ERP SAP
&
#
#
.