Oracle DB at the receiver end

[Former Member]

Hi All,

I have a scenario to insert/update/create product details into oracle backend from SAP. If the product is not available, the product should be created along with update of different details into Oracle DB tables. Does anyone worked on this type of scenario in which Oracle is at the receiver end (JDBC adapter). What are the best practices to follow? Please send across advices/weblogs or links if any.

Thanks

Deno

[bhavesh_kantilal]

Deno,

this is standars JDBC receiver adapters functionality.

You can achieve this using the option INSERT_UPDATE in the JDBC receiver adapter.

The INSERT_UPDATE will check if the entry exists and update if it exists else it wil create a new entry.

take a look at this link for the document format of your JDBC receievr datatype,

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

Bhavesh

[MichalKrawczyk]

Hi,

you can either use : UPDATE_INSERT action

in the sql document format

or you can check if product exists (in a BPM) and do the insert/update

based on that info

but if you use the product then you must use some sort of application right?

maybe at first try checking if there already are some

products interfaces ?

as if there are any they would handle all

of the checks etc (like BAPIs)

it's always better to use interfaces then

direct jdbc inserts...

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>