How to trigger data from Oracle to PI

[Former Member]

Hi All,

i have a requiremnt like, we need to get the data from the database table and send it PI. In the database a stored procedure is used,PI executes the stored procedure and gets the data. in the channel i have given the polling interval as 1min because as and when the data is updated in the database it has to be send to PI without any delay.

My question is,instead of calling the stored procedure for every 1 min. is there any way where oracle can send the data directly to PI whenever data is updated in the table?

Thanks,

Hemanth.

[Former Member · Accepted solution]

Hi,

You can use HTTP adapter instead of using stored procedure......

Thanks

Veeru

[Shabarish_Nair]

Depends on the DB version. (i think if the version is greater than oracle 9i for example)

There are options where a HTTP or WS call can be triggered.

[Former Member]

Hi,

If needs the data to be send to PI as an when then write a trigger at the database level and post the same using HTTP to the PI..

In PI use HTTP adapter..

HTH

Rajesh