jdbc to sap [server proxy]

[Former Member]

Hi ,

We have a scenario where I am sending datafrom MSsql database to SAP . Due to huge volume of data we are opting to use proxy on SAP side instead of IDOCs  to post all the gl , ap , ar documents using BAPI_ACC_DOCUMENT_POST. 

After creating the data type and message type and service interface in PI the inbound server proxy on sap side was activated and it generated a class and a method . Within the method it says "Insert Implementation here" unlike in client proxy where the code is automatically generated.

Could you please enlighten as to what code needs to be implemented here within the method? How will this method be called every time we execute a stored procedure on SQL [JDBC] side ? Say we have 200,000 records in the SQL table and we are executing stored procedure 200 times to pick data in chunks will PI automatically invoke the code withing the method or is there  a way to control hwo PI invokes this method ?

Also will use of Proxy improve performance over use of IDOCs? Using IDOCs it takes a long time in SAP to post all the documents.

Please advice!!

Thanks,

Teresa

[Shabarish_Nair · Accepted solution]

you will have to code the ABAP logic there i.e within the implementation framework - ref

http://wiki.sdn.sap.com/wiki/display/XI/Step-by-step+FTP+to+ABAP+Proxy

[Former Member]

Dear Teresa

Proxy is adapter less configuration so will be definitely faster. However you would have to put efforts in development of proxy code.

Yes you are right, whenever PI picks records from DB, they proxy code would be invoked.

Regards

Monika