How to retrive data from SQL or any database.

[former_member185856]

Hi Experts,

I am integrating FTP, DATABASE and SAP R/3 system.

1. FTP system stores xml files processed by customer requesting account info.

2. Database system ( SQL/Oracle) consists of Details about Customer accounts.

3. Finally response ( Account info ) to be sent to SAP R/3 system (customer request and database response)

Scenario: Customer request regarding account info is stored as xml in FTP server. XI has to pick the xml file and retrieve the relevant data from Database (SQL / Oracle) and store the whole data in SAP R/3 System.

Please let me know which BAPI I need to use for this scenario..and if you could explain the steps involved for this scenario that will really helps me.

Thanks and Regards,

Sunil

[Former Member]

Using db lookup would also be a possible solution, ie :

FTP (xmlfile) -> XI - [db lookup to retrieve cust. account while performing mapping to target structure] -> R/3 (RFC or proxy)

Thus, you do not have to use BPM, and it is easy to implement ...

Hope this helps

Chris

[former_member193376]

Hi

Check out these blogs (file to jdbc and file to RFC scenarios)

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

/people/arpit.seth/blog/2005/06/27/rfc-scenario-using-bpm--starter-kit

Thanks

Saiyog Gonsalves

[prateek]

Please let me know which BAPI

I think the functional person would be better choice to answer this question.

U may configure:

File - XI - RFC/Idoc/ABAP Proxy scenario

Use JDBC lookups in mapping

Regards,

Prateek

[VijayKonam]

I dont think there will be a separate bapi for this scenario.

Use file adapter to pickup the file, call the JDBC adapter in synchronous mode (call a Stored Procedure) and then call an RFC or proxy to push the data in to R3.

Refer and File to Jdbc and File to RFC scenarios. You might need to use BPM if you below SP14 on XI 3.0 I believe..!!

VJ