|
|
SAP AG.co in Will Give information of SAP related meterials Like SAP Platform and Operation,,SAP Security , SAP Enterprise Portal (EP), ,SAP Knowledge Management (KW), SAP Business Intelligence (BI), Exchange Infrastructure (XI),Application Server, Mobile (MI), Master Data Management MDM, Composit Appications Frame work,Web Dynpros,OOPABAP,Blog,Intergration Bulder, Integration Repository (IB),Integration Directory (ID).System Landscape Directory (SLD), And Adopter Configuration like File to File,File to JDBC, File to IDoc, File Content Convertion, RFC, HTTP,SOAP,XI Interview Questions,Xi Sertification Questions, and many more about SAP Netweaver Platform XI Training And Tutorial and XI interview Questions ..
SAP Exchange Infrastructure Tutorials
SAP XI Exercises File to RDBMS
Exercise 2 – File sender to RDBMS receiver
To verify that the data is posted to the SQL server please execute the following url: http://<DBhost>/Workshop?sql=SELECT%20*%20from%20Vendormaster%20FOR%20XML%20AUTO&root=root
Appendix: naming conventions and terminology
Exercise 1
Area |
Obj. type |
Object name |
Description |
SLD |
BS |
XIWS_legacy_BS_XX[00..30] |
Business system for legacy app |
|
BS |
XIWS_SQLSERVER_BS |
Business system for RDBMS |
|
SWC |
XI RIG US workshop [00..30] |
Individual SWC for exercises |
|
SWC |
XI RIG US workshop base comp |
Base SWC for usage dependency |
Int. Rep. |
NS |
urn:xiworkshop:groupXX[00..30]:legacy |
Namespace for legacy objects |
|
|
urn:xiworkshop:xirig |
Namespace for common objects |
|
Data type |
Vendor_DT |
Vendor data type |
|
|
Address_DT |
Nested DT |
|
|
VendorMaster_insert_DT (in base SWC) |
XML canonical format for JDBC. |
|
Msg.type |
Vendor |
Vendor message type |
|
|
VendorMaster_insert (in base SWC) |
XML canonical format for JDBC. |
|
Msg.int. |
Vendor_out |
Message interface (outbound) |
|
|
VendorMaster_in (in own SWC) |
XML canonical format for JDBC. |
|
Msg.map |
Vendor__VendorMaster_insert |
Message mapping |
|
Int.map |
Vendor_out__VendorMaster_in |
Interface mapping |
Int. Dir |
scenario |
xiworkshop_groupXX[00..30] |
Common for all exercises |
|
service |
XIWS_legacy_BS_XX[00..30] |
Derived from BS (no party) |
|
Service |
XIWS_SQLSERVER_BS |
RDBMS receiver |
|
Send c.c. |
File_sender |
Sender comm. channel |
|
Rec. c.c. |
JDBC_Receiver_XX |
Receiver c.c. for RDBMS service |
File sys |
folder |
\\hostname\workshop\groupXX[00..30 ] |
D:\workshop\groupXX[00..30] |
Previous
Back to SAP XI Tutorials |
|
|
|