Skip to Content
0
Former Member
Jun 04, 2011 at 05:58 PM

JDBC Sender Config

53 Views

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