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