The scenario is JDBC to IDOC using Graphical Mapping in PI 7.1
I am looking at extracting data from a view in sql server into PI to make sure that data can be extracted into PI. In the ESR the DT , MT , MI and OM has been definied.
In the Integration directory the configuration has been done correctly and the SQL Query and Update statement looks like below.
Select Query Statement : SELECT * FROM view
Update Statement: <test>
The Sender CC is active but I cannot see any xml messages in PI ?? At this point I would have expected records to be fixed by PI.
Please advice.
Thanks,
Hari