Skip to Content
avatar image
Former Member

JDBC->XI->RFC(V.V.Urgent)

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Aug 09, 2007 at 11:28 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 09, 2007 at 11:21 AM

    Jayasimha, do you mean whenever data is updated in your database, XI should call RFC???

    Thanks

    Varun

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 09, 2007 at 11:22 AM

    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

    Add comment
    10|10000 characters needed characters exceeded