cancel
Showing results for 
Search instead for 
Did you mean: 

how do I configure JDBC scenario

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

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>

bhavesh_kantilal
Active Contributor
0 Kudos

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