Store PI Payload data on a database Table
We are on PI 7.1 and have a business need in which we need to store some data of the PI Message payload in a Database table (SQL server table). We have synchronous as well as async scenarios, the need is that when any message comes in PI , it should go to the intended target but at the same time, some attributes of the payload should be written to a database.
Below are some of the options i can think of:
Configure multiple receivers: The drawback is that if the scenario is sync, we need to use BPM for multiple receivers.
JDBC Lookup: In the Message mapping, have a JDBC lookup which will write the data to Database table, as given in blog. /people/arpil.gupta/blog/2008/11/03/workaround-for-jdbc-scenarios (i have read the comments section of it too)
ABAP mapping: Add an extra ABAP mapping step in Operations Mapping, this Mapping will write certain attributes to a table on PI system, we can configure another interface to get the table from this table and write to the Database.
Configure TREX: This is the easiest option but requires separate installation (and probably separate license).
Has anyone implemented this kind of scenario? what was the approach? is there any other way to achieve this functionality.
Edited by: Saif Manzar on Jun 15, 2011 7:48 PM