Skip to Content
0
Jan 16, 2012 at 01:47 PM

Interface from db table to sap ecc table: RFC Adapter or Inobound Proxy?

57 Views

Hi,

this is a simple scenario

the sender is an oracle table, say OtableOne, containing the fields as:

Ofield1

Ofield2

Ofield3

.

.

Ofield100

The receiver is SAP ECC table, say ZStableOne, containing the fields as:

Sfield1

Sfield2

Sfield3

.

.

Sfield100

So the scenario looks like:

DbApplication-->JdbcSenderAdapter-->PI-->(Proxy/RfcAdapter??)-->SAP Ecc

for the sender side, creation of DTs was easy, with the help of the feature: Import SQL Table's Metadata using JDBC adapter, SAP PI 7.1 Mapping Enhancements Series: Import SQL Table's Metadata

Initially, i thought of using proxy on receiver side.

for the receiver side, creation of the DTs, from scratch is too much time consuming.

then, we decided to use RFC adapter.

in SAP ecc, we created an RFC, with parameter of table type ZStableOne,

imported the RFC(metadata) into ESR, so the target DT structures readily available as part of request message type of the RFC, and then mapped the fields, and completed the scenario using RFC receiver adapter.

I have two queries:

1. For these kinds of scenarios from the performance, maintenance point of view, is it recommended to use Proxy or RFC receiver adapter?

2. Similar to feature: Import SQL Table's Metadata using JDBC adapter, is there any easy way available to import SAP table's metadata into ESR?

thanks,

Madhu_1980