Issues with Generic SQL (Microsoft) MA and configuring WaterMark Delta Strategy RRS feed

  • Question

  • I have configured the Generic SQL MA on a MIM 2016 SP1 sync engine to connect to an HR view. Everything is working fine with the exception of running Delta Imports. 

    The MA is currently configured to use the watermark delta strategy.  The “Water Mark Query” defaults to SELECT GETDATE();.  We have a watermark column in the view that contains the datetime the record was last updated.  I've used the following reference to configure the Generic SQL MA.

    When running a delta import, the operation fails with a no-start-ma error.  Can anyone provide me additional information on how the watermark works and what step I am missing to configure deltas? Thanks.

    Tuesday, August 22, 2017 7:52 PM