RFC to JDBC scenario

[Former Member]

Hi Mentors

I need to send customization tables (T tables) data to an SQL database. There are nearly 40tables that need to be sent. We are thinking of two approaches:

1. RFC to JDBC Communication --> We created a program which sends selected table metadata and table data to XI. Can a dynamic target structure be created based on the metadata and data sent from R/3? If so how will the mapping look like?

2. File to JDBC Communication --> Create a common file structure through single file adapter and map the structures to target structure.

Can you please let me know which approach is fine and also answer RFC to JDBC query. Any help is greatly appreciated.

Regards

JD.

[Former Member]

Structure cant be Dynamic...

RFC to JDBC is the best option.... because Functional Consultant , who is triggering Report in SAP R/3 need worry about File name... if u use File to JDBC, you have to sychronize file name with file name in communication channel, which is not suggested..

as SAP R/3 is sender, it is better to go to RFC Sender...

[Former Member]

we can't make the structure dynamic ,

instead you can send data as bunch from rfc of file and break it as per your need at receiver side i.e. stored procedure.

[Former Member]

Hi,

go through ....

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 - File to JDBC

Regards

[Former Member]

Hi,

You can send the all data as in one line (Similar to Blob), and then on JDBC side you can just call the stored proceudre to separate those fields as per the length. Or you can do this in mapping also.

You can't decide the structre dynamically, something common you need to take.

Thanks

Swarup