Sending data from Oracle to XI on HTTP

[Former Member]

Hi,

We have few interfaces where we use JDBC adaptor to pull data from different Oracle databases.

these Channels are scheduled to run oncer at night.

Now the requirement is to make the interfaces real time so that data is always up to date in SAP system.

Only way i could figure out was if in some way we can write triggers on filed level changes in Oracle DB and send the same to XI using HTTP.

I need your suggestions if this is possible. if yes then how

[Former Member]

Hi Tarun,

this is a bit difficult, because the changes a initiated in the database and there is no mechanism how PI would know that something has changes.

What I would suggest you is to analyse, how "real-time" data you need. would be 1 minute delay too long? if no, simply set the polling interval accordingly.

If the data really needs to be sent immediately, then you have to do as said above - develop some application. I'm not an Oracle expert, but maybe there is an option of setting up a web service client and if so, create a trigger, if the value is changed, send a request to PI.

Peter

[Former Member]

Thanks all of you,

Delay of 1 minute is not the issue .... data that comes in includes vendors and Purchasing documents fot those vendors. (just 1 of the many examples).

when you poll the channel for 1 minuet interval..... it ends up readin all fields of the table. where as mayube the change to affected cud be only 1 field. we want to minimise the load on our XI server which is kinda stressed out.

As for other solution ........... i guess creating a stored procedure to trigger on table change is a suitable option but which webservice to call from this trigger...... and can oracle send data on HTTP.... this way XI is always ready for any coming data. does not get more real time than that.

Regards,

Tarun bahal

[Former Member]

Sorry even i have not created any webservice...but i guess u can create in java and .net and then execute it by calling in stored procedure.

Please refer following links...u will get some info which u can combine to implemenet ur scenario.

http://java.sun.com/webservices/docs/1.6/tutorial/doc/ - tutorial to create web service in JAVA

http://awads.net/wp/2005/11/30/http-post-from-inside-oracle/

-

http://msdn.microsoft.com/en-us/library/aa258254(SQL.80).aspx - Trigger with example - IMP

http://msdn.microsoft.com/en-us/library/ms181591(SQL.90).aspx - Sending Request

Regards,

Manisha

[Former Member]

Hey even I will configuring same scenario..so gathered some info..let me tell u that..

U can write trigger (kind of stored procedure) which gets executed on insert, update or delete (whichever operation u mention) and then execute web service which will in turn call xi for further processing.

Regards,

Manisha

[former_member181985]

Then you might need a proprietary application which can monitor DB table fields then select the new inserts or updates from DB and then post them to XI using HTTP adapter.