Sender JDBC adapter challenge..
We have unique situation where PI needs to pull millions of records from SQL Server.
Due to Internal constraint, the host of DB server would not allow PI to update any data so i cannot use the update
statement to mark, records which are processed.
I have asked them to built the update statement in Stored procedure, which also is partly approved.
Currently we have query which fetches X no of records ( fixed) out of Y ( total no of records) and every time PI channels is called next set of
X no of records come to PI. In the next polling, next set,next X records will come, till the end of records is achieved.
However, once the end of record is achieved, PI should be smart enough not to start from the Top again and do not poll the records again
without any help from SQL statement & update.
Can someone advice, if this is possible in PI 7.1 and how to achieve this .
Thanks for your time!