on 08-09-2007 12:20 PM
Hi ,
JDBC->XI->RFC
I am Integrating Oracle database with SAP(RFC).
How should adapter knows some thing updated in Oracle.
How Should the Triggers in Oracle.How we have to write Query in XI..
Points Will be awarded for the Solution..
Regards,
Jayasimha
Jayasimha,
I'd suggest you this,
Pl make an archive table to store all the updated/deleted data using Triggers. Also please give a column in this table to store the time of updation.
In your sender JDBC adapter query the latest records from this archive table based on the updation datetime..
Thats al
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Refer the below links ...
check the below blogs
/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30
/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures
/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter
See the below links also ..
/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response - XI: How-to on JDBC receiver response
JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous
Receiver JDBC scenario - /people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn
/people/ajay.kumar/blog/2005/03/24/writing-bsp-for-sap-r3-version-46
/people/sravya.talanki2/blog/2006/12/27/aspirant-to-learn-sap-xiyou-won-the-jackpot-if-you-read-this-part-iii
/people/prasad.illapani/blog/2006/10/25/how-to-check-jdbc-sql-query-syntax-and-verify-the-query-results-inside-a-user-defined-function-of-the-lookup-api
/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter
/people/swaroopa.vishwanath/blog/2007/01/22/ale-configuration-for-pushing-idocs-from-sap-to-xi
/people/udo.martens/blog/2005/09/30/one-logical-system-name-for-serveral-bpm-acknowledgements
/people/community.user/blog/2006/09/21/xi-rfcadapter-reconnect-issue
/people/sap.user72/blog/2005/12/22/new-to-xi
Rewards point if useful
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Jayasimha, do you mean whenever data is updated in your database, XI should call RFC???
Thanks
Varun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.