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

[Former Member]

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

[former_member192892]

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

[Former Member]

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

[former_member192892]

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

Thanks

Varun