sap pi 7.1 to sap bw scenario

[Former Member]

Dear friends,

I have the following sender below:

SQL database(JDBC sender) --- sap pi 7.1 --- sap bw 7.0

How efficient is this scenario compared to using DB connect or UD Connect to connect from sql to sap bw 7.0. Considering the amount of messages that will be sent from sql.

Also from sap pi7.1 to sap bw is RFC or proxy better?

Please provide your valuable suggestions and any documentation or samples regarding the above scenario.

Thanks you !

Teresa

[baskar_gopalakrishnan2 · Accepted solution]

>How efficient is this scenario compared to using DB connect or UD Connect to connect from sql to sap bw 7.0. Considering the amount of messages that will be sent from sql.

Generally JDBC connection using adapter is effiicient and if you could control the resultset select records using the select query then no issue at all. Using Jdbc adapter you can easily pull or read records from table few thousands per message.

>Also from sap pi7.1 to sap bw is RFC or proxy better?

Depends on the requirement. Generally Proxy is more efficient for high volume messages than RFC. Plus via proxy coding you can handle more application logic such as error handling, validation and more.

[Former Member · Accepted solution]

Thanks Bhaskar. Are there any guides on sdn on how to connect sap pi 7.1 to sap bw 7? Also how to develop such a scenario ?

Regards,

Teresa

[Former Member · Accepted solution]

Refer this-

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/18dfe590-0201-0010-6b8b-d21dfa992...

[baskar_gopalakrishnan2 · Accepted solution]

The above link is self explanatory. There are plenty of documents for JDBCm proxy and RFC scenarios in sdn. Please search for it.