Hi,
Involved in a project integrating proprietary Sybase system with SAP and trying to understand how PI communicates with us. Looking for answers to the following questions:
1. Was told that SAP PI must use JDBC adapter to talk to Sybase either using Sybase provided JDBC driver or using a JDBC-ODBC bridge if only Sybase ODBC driver is available. Is this true?
2. Assuming that I have an item table in Sybase and SAP-PI needs to insert/update 50 records from an IDOC into this table, will the JDBC Adapter (which I assume is running on the PI server), will the JDBC Adapter in essences perform 50 seperate INSERT SQL calls, one per data row? SAP contractor was trying to tell me that a single "message" will be sent to my database by JDBC Adapter and that the 50 "INSERT" SQL calls will occur on my database server. I find it very hard to believe this.
3. Assuming that I need to pass heirarchal data from my database to SAP-PI in which the data comes from 2+ tables (such as order_header and order_line). If PI is going to access the database directly, it seems that the standard practice is to build a buffer table or stored procedure that combines the columns from the various underlying tables into a single resultset rather than either having PI select data from multiple datas individually or by having a stored procedure return multiple result sets. Is this true?
4. Is it possible to have PI execute a stored procedure which returns multiple resultsets where each resultset has a different column definitions?
Start Free Trial
