on 03-07-2007 11:11 PM
my scenario is complete async scenario is file to JDBC. data from File will be inserted into a Master table and two child tables. Can anybody has any suggestions as how to implement this scenario. Also, i appreciate how to handle error situtaions in this case.
Thanks,
Sudha Madhuri
Sudha,
check the follwoing Blogs,
Please refer this links for more info..
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
take a look at this blog
/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes
with BPM
1. receive step - http receive
- transformation - http to jdbc select
2. send step (sync for example)
- transformation - jdbc request to file
3. send step file
without BPM
1. receive http - select + insert the selected data into table1 (stored procedure for example)
2. sender jdbc adapter can poll table1 and map into file
and file adapter
try this blog for stored procedures.
/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi
now I got it...
/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn
For more info, look at these links,
http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
Regards
Sreeram.G.reddy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please see the below links to get an idea about the JDBC scenarios..
/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 - File to JDBC
/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response - XI: How-to on JDBC receiver response
How to check JDBC SQL Query Syntax and verify the query results inside a User Defined Function of the Lookup API -
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
JDBC - http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm
multiple tables with JDBC - http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous
Receiver JDBC scenario - /people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn
Regards
Chilla..
<i>Points rewarded if it is useful..</i>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sudha,
For a simple File to JDBC insertion, look into this blog,
<a href="/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30">FILE to JDBC Adapter using SAP XI 3.0</a>
Also, look into this link and understand the format of the target datatype for the JDBC receiver Adapter.
<a href="http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm">Document Formats for Receiver JDBC Adapter</a>
As you need to insert into multiple tables, you will have multiple STATEMENT level tags with Action as Insert and under ACCESS you will have to give the column names of the corresponding table.
Error Handling~
JDBC adapters support synchronous calls and so you can get the status of your Insert calls and then decide on what the future coruse of action is. This would need a BPM though.
A better solution if you need to only montior Technical errors would be to use XI Alerts.
Regards
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.