| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: 9i to UDB using Generic Conectivity
Hello Sundeep,
sm> We are looking to pull some data (batch jobs no distributed OLTP) sm> from a SAP/UDB on AIX into our 9i DB on AIX. We do have a gateway to sm> mainframe DB2 but not to the UDB on AIX. The Hetrogeneous Services sm> Admin guide seems to explain how to get the Generic connectivity set sm> up.
You have to carefully design everything and remember that SAP and other BIG ERP products don't support reading data directly from database tables (especially data currently in use) because SAP maintain it's own buffer cache, and by reading from tables you are bypassing this cache, and so this can lead to unpredictable results.
In one of our projects where we needed data from SAP system we have implemented gateway that reads data from SAP tables using SAP's interface RFC and feeds it to the database, but since RFC SDK is also available for Java, you can also easily load library to database and connect to SAP from database stored procedures to retrieve all necessary data.
--
Best regards,
Edgar
 |
 |